The following query will enable you to list all the tables in your database that don't have an IDENTITY Column:
SELECT SysSchemas.name + N'.' + SysTables.name
FROM sys.tables AS SysTables
INNER JOIN sys.schemas AS SysSchemas
ON SysTables.[schema_id] = SysSchemas.[schema_id]
WHERE NOT EXISTS
(
SELECT 1 FROM sys.identity_columns AS IDCol
WHERE IDCol.[object_id] = SysTables.[object_id]
);
Visit the DevX Tip Bank