Find the tables which does not have an Identity Key column

 
SELECT   isc.table_name
FROM     information_schema.columns AS isc
         INNER JOIN sys.tables
         ON       SYS.tables.object_id = object_id(isc.TABLE_NAME)
WHERE    SYS.tables.type               = 'u'
GROUP BY isc.table_name
HAVING   MAX(COLUMNPROPERTY( OBJECT_ID(isc.table_name), isc.column_name,'Isidentity')) =0--( To get the table which doesnot contains identity columns')
ORDER BY isc.table_name