Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2009-07-30 : 07:32:34
|
| Hi allCan any one help me in removing IDENTITY property of a column.I have table a below structure.Create table Temp(EmpID Int Identity(1,1),Name Varchar(50))Now my problem is to remove the identity for EmpID column.ThanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-07-30 : 07:44:57
|
| For Remove:ALTER TABLE tablename ALTER COLUMN column_b INTFor Disabling Identity insert:SET IDENTITY_INSERT <Table_Name> ONFor enabling Identity insert:SET IDENTITY_INSERT <Table_Name> OFFSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-07-30 : 07:54:09
|
| u can disable the identity property in design mode |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-07-30 : 10:53:15
|
| .... |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-07-30 : 10:57:26
|
quote:
Originally posted by senthil_nagore
For Remove:ALTER TABLE tablename ALTER COLUMN column_b INT
Thats all I can see you needing to me |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-08-05 : 05:55:37
|
| <<ALTER TABLE tablename ALTER COLUMN column_b INT>>Still identity will be part of a columnMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Remove the IDENTITY for a column in a table.