-- tables with identity columns select * from information_schema.tables where table_type = 'base table' and objectproperty(object_id(table_name),'IsMsShipped') = 0 and objectproperty(object_id(table_name),'TableHasIdentity') = 1
July 2005