Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set identity off in T-Sql
Message
 
 
To
24/05/2011 08:25:52
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01511557
Message ID:
01511570
Views:
38
You don't have to but you can if you are interested to know how it's done.

>I'm sorry I don't understand fully.
>
>In SSMS I click Design, and remove the identity property. Before pressing Ctrl+S, I guess I should generate a scipt. But how? It's not in the Script Table as-menu.
>
>
>>SQL Server doesn't have command to add or remove IDENTITY property of a column. You can do it in SSMS. Generate a script before applying changes to see how it's done.
>>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform