Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Jan 25, 2018

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Identify Tables Without 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]
  );
Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date