
May 16th, 2005, 06:20 AM
|
|
Registered User
|
|
Join Date: Dec 2004
Posts: 17
Time spent in forums: 1 h 7 m 21 sec
Reputation Power: 0
|
|
|
Identity column exists for table - how to know?
Hi,
Is there any way, that I can determine whether a table has any identity column, programmatically in SQL Server. In other words, is it stored some where like syscolumns or sysconstraints or whatever, whether a table has identity column and what column has the identity property set to on? I am referring to SQL Server 2000.
Thanks in advance
ourspt
|