alter column identity

Results 1 to 2 of 2

Thread: alter column identity

  1. #1
    Join Date
    Dec 1969

    Default alter column identity

    Is it possible to alter a column and give it identity through a script? I know you can through the IDE, so, you should be able to do it via a script! And I am aware of the work around of adding another column as identity and then dropping that column that you were wanting to replace. But, I&#039;m not interested in that. I&#039;m interested in altering a column to identity. Like the following:<BR><BR>alter table tablename<BR>alter column id int identity not null<BR><BR><BR>Any help would be appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: alter column identity

    You can&#039;t do it with one statement. Drop it first and add it again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts