• There Is no such a way when database engine is SQL server 2000.the following query returns error:

    SELECT [object_id], [name] FROM sys.columns

    WHERE is_identity = 1