Norway


Full Text Search: The to Better Natural Language Queries for NoSQL in Node.js

Date: 1/31/ @ 2 p.m. ET

The following query will enable you to list all the in your database that don’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]
  );

 

Visit the DevX Tip Bank

 



Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here