Finding a Identity Specification using SQL
Posted
by J Harley
on Stack Overflow
See other posts from Stack Overflow
or by J Harley
Published on 2010-06-08T09:27:00Z
Indexed on
2010/06/08
9:32 UTC
Read the original article
Hit count: 228
Good Morning,
I have an MS SQL database, of which there is a column that has an identity specification.
However, if I do a SQL query such as:
SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME =
It doesn't tell me if the column is an identity specification - is there a query that will?
Many Thanks, Joel
© Stack Overflow or respective owner