How to know Identity columns of a table?

[Satya Maheshwari]

Hi

I have a requirement wherein I need to list the labels of identity (auto generated) columns of a table. I am using MS-SQL server and JDBC. Could you please tell, how to do this?

TIA

[Paul Sturrock]

You can interrogate the database meta data (see the java.sql package for a suitable class to do this). Or you can use the database's own catalog stored procedures and views. Depending on which versio nyou are on, you should get all you need from sys.objects or sys.columns.

[Satya Maheshwari]

Thanks for the information. I am planning to use the below query to fetch the result:

select t.name,c.name 
from sys.tables t,
     sys.all_columns c
where c.object_id = t.object_id 
and c.is_identity > 0