May 12, 2012 at 10:27 am
Working with the eBook Head First C#. An exercise requires the creation of SQL database [compact] and tables. ContactID, the table in question and the "identity is to be set to "True". Attached please find image of Visual Studio 2008 Team Suite demonstrating the table properties. I find that identity shows no setting.
Assuming that identity is not set to True I would ask what is the appropriate way to remove the table and reconfigure
May 14, 2012 at 6:32 am
The easiest way to get rid of the table is to use the command, DROP myschema.mytable. That will immediately remove it, assuming you haven't created foreign key constraints to it from other tables.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 14, 2012 at 10:21 am
Haven't worked with Compact or VS that much for database work, but you have "autoincrement" set to true in that image. I assume that means the identity is set for that table.
May 14, 2012 at 12:15 pm
Appreciate the timely response. I suspected as much but as a complete novice I thought it wise to inquire. It is though the guidance of the learned that the student advances. I thank you
Phil Pense
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy