|
-
Removing identity column
How to remove identity property from a column throught SQL statement?
-
Removing identity column (reply)
alter table TAB alter column COL. Redeclare the COL as its current definition but omitting IDENTITY. See Books Online for syntax if you need more.
------------
Gang at 6/26/01 1:07:59 PM
How to remove identity property from a column throught SQL statement?
-
Removing identity column (reply)
It did not work
------------
Bill at 6/26/01 2:16:33 PM
alter table TAB alter column COL. Redeclare the COL as its current definition but omitting IDENTITY. See Books Online for syntax if you need more.
------------
Gang at 6/26/01 1:07:59 PM
How to remove identity property from a column throught SQL statement?
-
Removing identity column (reply: it doesn't work)
------------
Gang at 6/26/01 1:07:59 PM
How to remove identity property from a column throught SQL statement?
-
Removing identity column (reply)
My mistake. You can do achieve this in EM by going into table design mode and unchecking the IDENTITY check box for the column, but in the background, it creates a new table.
You can verify this if you make the change in a database diagram and right-click for "save change script".
------------
at 6/26/01 2:49:57 PM
It did not work
------------
Bill at 6/26/01 2:16:33 PM
alter table TAB alter column COL. Redeclare the COL as its current definition but omitting IDENTITY. See Books Online for syntax if you need more.
------------
Gang at 6/26/01 1:07:59 PM
How to remove identity property from a column throught SQL statement?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote