May 9, 2011 at 8:45 am
Hi,
RDBMS sql server 2005
I have a table with int column.
Now when I add identity with SSMS , it say you have to drop and recreate table.
can you please tell me how can I add identity to existing column?
May 9, 2011 at 8:53 am
You gave the answer yourself. Drop the column and add it again with the identity property.
John
May 9, 2011 at 8:55 am
no other way?
as this column can be primary and reference exist on many places, so drop and recreate can create some problems.. 🙁
May 9, 2011 at 10:15 am
If you do it in the table design mode of SSMS, all of that will be taken care of automatically and safely.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply