Tables NOT having FK

,

Following script lists the tables NOT having FK.

SELECT name   
  FROM sysobjects 
 WHERE xtype='U' 
   AND objectproperty(object_id(name),'TableHasForeignKey')= 0
 ORDER BY 1

Rate

5 (1)

Share

Share

Rate

5 (1)