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

Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method

By

Yesterday in this post I described a method to correct permissions when upgrading a...

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options

By

Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Random number in results searching IDNUMBER >= '1000205830' and IDNUMBER

By nilknarf1972

IDNUMBER >= '1000205830' and IDNUMBER <= '1000206010' ORDER BY ID_NUM DESC I'm also getting...

how to create triggers with delete and update

By mcfarlandparkway

how to create triggers with delete and update i have a table called dbo.OrderDetail...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers