Get Foreign Key of all the tables for Sqlserver DB

This script will create two views and select the data from the TableReferences view. This view will give list of all the foreignkeys of the selected database with its constraint name, the table name and column name(s) on which the constraint is created and the referencing table name and column name(s).

5 (2)

2006-09-25 (first published: )

582 reads

Blogs

Using Azure Data Factory Mapping Data Flows to populate Data Vault

By

(2019-May-24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure...

New Azure “SQL Server settings” blade in the Azure Portal

By

I just noticed today that there is a new blade in the Azure portal...

Mass Backup All Sessions

By

Migrating Extended Event Sessions from one server to another should be a simple task....

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Buffer Pool calculation

By avpco

Hello Colleagues. Could you tell me about how MS SQL Server 2016 SE determines...

SSIS Scale out deployment in a high availability cluster

By KobusV

Good day all, Just wondering if it will be possible to have a scale-out...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers