Tip: Identify Tables Without an Identity Column

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