Hello,

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?
Thanks.

SELECT name
FROM sys.columns
WHERE object_id=OBJECT_ID('dbo.YourTableHere','U') AND is_identity=1


--
Tom
http://kbupdate.info/ | http://suppline.com/

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/