Very Computer

I wonder if anyone could tell me how to "discover" the Identity column (the
auto-increasing one) of an SQL Server table, using (classic) ADO's
OpenSchema method? That is, how can I find out if a column is the Identity
column?

If anyone knows how to do the same witrh an Access database, I'd be
interested in that too, though I know this isn't the right forum...

Many thanks in advance!

/Mats Helander

SELECT t1.TABLE_NAME,
       c1.COLUMN_NAME
  FROM INFORMATION_SCHEMA.TABLES  t1
 INNER JOIN INFORMATION_SCHEMA.COLUMNS c1
    ON t1.TABLE_NAME = c1.TABLE_NAME
 WHERE c1.TABLE_SCHEMA = 'dbo'
   AND t1.TABLE_TYPE = 'BASE TABLE'
   AND COLUMNPROPERTY(OBJECT_ID(c1.TABLE_NAME),
                        c1.COLUMN_NAME, 'IsIdentity') = 1

--
- Anith

All the best

/Mats

Quote:> Try:

> SELECT t1.TABLE_NAME,
>        c1.COLUMN_NAME
>   FROM INFORMATION_SCHEMA.TABLES  t1
>  INNER JOIN INFORMATION_SCHEMA.COLUMNS c1
>     ON t1.TABLE_NAME = c1.TABLE_NAME
>  WHERE c1.TABLE_SCHEMA = 'dbo'
>    AND t1.TABLE_TYPE = 'BASE TABLE'
>    AND COLUMNPROPERTY(OBJECT_ID(c1.TABLE_NAME),
>                         c1.COLUMN_NAME, 'IsIdentity') = 1

> --
> - Anith