March 24, 2004 at 10:35 pm
Hai All,
How can i remove the IDENTITY property of a column through T-SQL commands (I know how to do it from EM)
Thanks
subban
March 24, 2004 at 11:38 pm
if you only want to remove it temporarily, check out SET IDENTITY_INSERT in BOL
My Blog:
March 25, 2004 at 12:17 am
Not direct command in TSQL to alter a identity column.
Even EM does a DROP and RECREATE (and a rename) internally.
To confirm this, go to design view of a table , alter identity column and click on third button (Save Change Script) to see the script generated by EM.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply