I have found that how to determine what columns are primary key column of a given table by using this query:

```
 SELECT CONSTRAINT_NAME, COLUMN_NAME
 FROM
 INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
 WHERE TABLE_NAME='tablename_here' AND
 CONSTRAINT_NAME LIKE 'PK_%'

```

I can find , what the identity seed and increment is by using this query:

```
SELECT IDENT_SEED('tablename_here'), IDENT_INCR('tablename_here')

```

I cant use the constraint information, because a primary key constraint can be across multiple columns. And i cant seem to find any Transact SQL function to give my the identity information. 

Can anybody help me to understand how to find the identity information?

I am using SQL Server 2000.