How do I determine if a column is an identity column in MSSQL 2000?

sql-server tsql metadata
Bialecki picture Bialecki · Oct 9, 2008 · Viewed 27.3k times · Source

I want to do this in code, not with ALT+F1.

Answer

Blorgbeard is out picture Blorgbeard is out · Oct 9, 2008

You can also do it this way:

select columnproperty(object_id('mytable'),'mycolumn','IsIdentity')

Returns 1 if it's an identity, 0 if not.

Related questions

How do you determine what SQL Tables have an identity column programmatically

I want to create a list of columns in SQL Server 2005 that have identity columns and their corresponding table in T-SQL. Results would be something like: TableName, ColumnName

Read More
Get the unique constraint columns list (in TSQL)?

I can get a list of unique constraints fairly easily with the following query: select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_TYPE='UNIQUE' But how do I get a list of the columns that each unique constraint applies to?

Read More
How do you list all the indexed views in SQL Server?

How can you get a list of the views in a SQL server database that have indexes (i.e. indexed views)? I've found it's pretty easy to run an "ALTER VIEW" as I'm developing and overlook that I'm not only …

Read More