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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2005-10-06 : 18:53:42
|
| Guys, I am trying to query the database to find all columns which have identity property I have tried querying the syscolumns and also tried to use information schema views, but I cudn't get farPlease let me if you have any other way to find it outThanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-06 : 19:26:43
|
| SELECT table_name, column_name as Identity_ColumnFROM information_schema.columns WHERE COLUMNPROPERTY(OBJECT_ID(table_name),column_name,'IsIdentity')=1order by table_nameTara |
 |
|
|
|
|
|
Query for Identity columns