How to check identity tables in Sybase database
Sybase ASE Sybase Identity column, Sybase Image column, Sybase text columnBelow query can be used to find identity tables in Sybase database.
1select @@servername 'Server',db_name() 'DB',convert(char(35),object_name(id)) as "Table_Name", convert(char(35),name) as "Column_Name" from syscolumns where status=128
2go
Sample output:
