dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday Jan 25th 2018 by Hannes du Preez

Language: SQL, Level: Beginner: - This query will enable you to list all the tables in your database that don't have an IDENTITY column.

The following query will enable you to list all the tables in your database that doesn'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]
  );
Home
Mobile Site | Full Site