Norway


The following query will enable you to list all the in your database that doesn’t have an :

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]
  );



Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here