Get All Tables with Foreign Key status
When i was writing a Code Generator, i needed to get all the table with foreign key status from my database. Following query return that.
select [Name], Case WHEN object_id IN (SELECT parent_object_id
FROM sys.objects WHERE[type] ='F') THEN 1 ELSE 0 END HasFKey from sys.objects
WHERE [type] in('U') order by [Name]
Advertisement
