-- 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