Is there a way to check if INDENTITY is enabled on a table?

From: "CK" <c_kettenbach@xxxxxxxxxxx>
Date: Tue, 27 Nov 2007 17:44:06 GMT

Is there a way to check if INDENTITY is enabled on a table?

I want to provide a table name and see if Identity (Autonumber) is enabled
on it. Is this possible?

Thanks for any help.

Cheers,

~ck

.

Follow-Ups:
- Re: Is there a way to check if INDENTITY is enabled on a table?
  - From: Erland Sommarskog

Prev by Date: Re: ORDER BY AND GROUP BY CLAUSE
Next by Date: SQL Server moving to larger drive
Previous by thread: Re: ORDER BY AND GROUP BY CLAUSE
Next by thread: Re: Is there a way to check if INDENTITY is enabled on a table?
Index(es):
- Date
- Thread