Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set identity off in T-Sql
Message
From
24/05/2011 08:53:29
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01511557
Message ID:
01511571
Views:
33
I got that. But I just don't know how to generate the script. Can you tell me please?

>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.
>>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform