Below query can be used to find identity tables in Sybase database.

1> select @@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
2> go

Sample output: