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 |
|
twinklestar0802
Starting Member
17 Posts |
 Posted - 2005-10-26 : 23:56:25
|
| How can I know that a column is auto incremented or not? What are the commands used to know this??Thanks guys |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-27 : 00:09:07
|
| SELECT object_name(id) tbl, name col FROM syscolumns WHERE ColumnProperty(id, name, 'IsIdentity')=1Look up COLUMNPROPERTY in Books Online for more information. |
 |
|
|
|
|
|
AutoIncrement Column