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?
by Falik She » Wed, 30 Jan 2002 22:48:48
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?
by Narayana Vyas Kondredd » Wed, 30 Jan 2002 23:06:28
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?
1. how to alter an identity column to a non-identity column
Whether and How to do it with a simple alter table alter column statement?
Thanks,
-charles
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
2. how to use the package dbms_job ?
3. multiple ALTER COLUMNs in one ALTER TABLE statement?
4. US-IL-SENIOR TECHNICAL LEAD/ARCHITECT / ORACLE
5. Help with Alter Table Alter Column
6. DSO Question
7. Alter Table Alter Column Syntax
8. SQL Experts... how can you do this?
11. Alter table alter column syntax
12. Alter table Alter column problem.