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]
Advertisements
Posted in SQL.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s