ALTER TABLE ... ALTER COLUMN IDENTITY 
Author Message
 ALTER TABLE ... ALTER COLUMN IDENTITY
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?



Sat, 17 Jul 2004 21:48:48 GMT
 ALTER TABLE ... ALTER COLUMN IDENTITY

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?



Sat, 17 Jul 2004 22:06:28 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. how to alter an identity column to a non-identity column

2. multiple ALTER COLUMNs in one ALTER TABLE statement?

3. Help with Alter Table Alter Column

4. Alter Table Alter Column Syntax

5. Alter table alter column

6. alter table alter column

7. Alter table alter column syntax

8. Alter table Alter column problem.

9. ALTER TABLE ALTER COLUMN

10. ALTER TABLE ALTER COLUMN to set Default

11. Alter table alter column text

12. syntax for ALTER TABLE ALTER COLUMN DEFAULT


 
Powered by phpBB® Forum Software