TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
TAN WhoAMI
NA
291
0
SQL CE 4.0 Database in Visual Studio 2010 Server Explorer
Mar 13 2013 8:48 PM
I manage to get SQL CE 4.0 Database in Visual Studio 2010, and see it in the Server Explorer.
However, I see one difference between the SQL Server Database and SQL CE 4.0 Database in the Server Explorer.
With the SQL Server Database, I am able to go to its individual Tables, and Open Table Definition, and Insert Column/Delete Column. This allows Insert Column in between any existing columns.
With the SQL CE 4.0 Database, I do not see the Open Table Definition option. The only option I can choose is: Edit Table Schema. Inside Edit Table, I can only Insert new Column as the last Column, and I cannot insert column in between those existing columns. Why? The only workaround is to delete those existing columns, insert the new column, and insert back those deleted columns, which is very troublesome.
Say I have Columns A, B, C, D, and I want to insert Column A1, after Column A. I need to remove Columns B,C, and D and insert Column A1, then insert Columns B,C and D again.
Did anyone face the same problems? What are the better solutions?
Reply
Answers (
0
)
coding for sending sms from vb.net application
C# Windows Application -- Automatic Email with an Attachmen