Posted by kb on 09/10/07 17:11

> 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


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

• Next in forum: Re: Identity Column in INFORMATION_SCHEMA or the sys tables
• Prev in forum: CREATE TABLE syntax error...
• Thread view: Re: Identity Column in INFORMATION_SCHEMA or the sys tables

[Reply to this message]