ALTER TABLE ... ALTER COLUMN IDENTITY

ALTER TABLE ... ALTER COLUMN IDENTITY

Post by Falik She » Wed, 30 Jan 2002 22:48:48



MSSQL 2K

How one can alter a column to IDENTITY column using TSQL?

I have table i.e. Table1
column1    Int
coulmn2    varchar(50)

Now I want to change the coulmn1 definition to Identity property using TSQL.
any help?

 
 
 

ALTER TABLE ... ALTER COLUMN IDENTITY

Post by Narayana Vyas Kondredd » Wed, 30 Jan 2002 23:06:28


Falik, not possible through ALTER TABLE. For more info:
http://www.tsqlsolutions.com/Articles/Index.cfm?ArticleID=22080
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


Quote:> MSSQL 2K

> How one can alter a column to IDENTITY column using TSQL?

> I have table i.e. Table1
> column1    Int
> coulmn2    varchar(50)

> Now I want to change the coulmn1 definition to Identity property using
TSQL.
> any help?