|
|
Posted by kb on 09/10/07 17:15
>> Where can one find the identity column for a table in the
>> INFORMATION_SCHEMA or the sys tables? Or is there a function that can
>> return the name or id of the identity column for a particular table?
>
> SELECT name
> FROM sys.columns
> WHERE object_id=OBJECT_ID('dbo.YourTableHere','U') AND is_identity=1
SQL 7.0 / 2000 version:
SELECT name
FROM dbo.syscolumns
WHERE id=OBJECT_ID('dbo.YourTableHere','U') AND
COLUMNPROPERTY(id,name,'IsIdentity')=1
--
Tom
http://kbupdate.info/ | http://suppline.com/
Navigation:
[Reply to this message]
|