Determine Whether a Table Has an Identity Column

This code is for MSSQL Server, but applicable for MS SSQL Server 7 or above. Check in T-SQL:


SELECT OBJECTPROPERTY(object_id('TableToBeChecked'), 'TableHasIdentity')

SQL Server returns 1 if the table has an identity column, 0 if it doesn't.

Jaya Nehru Kumar

Submit a Tip

Browse "Database Development" Tips

Browse All Tips

Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.

Thanks for your registration, follow us on our social networks to keep up-to-date

WEBINAR:On-Demand

Determine Whether a Table Has an Identity Column

WEBINAR:

On-Demand