Technical Article

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: )

588 reads

Blogs

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

Daily Coping 18 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Read the latest Blogs

Forums

CREATING TRIGGER THAT INSERT DATA WHEN A PARTICULAR COLUMN OF A TABLE IS UPDATED

By LD3060

Hello, I am looking for a way whereby a trigger will be created ONLY...

Disk Latency in SQL MI

By cooldude001

For SQL Managed Instance, disk latency for Reads and Writes, when I query through...

Event log filling up with Sql error

By IT researcher

Windows event log filling up with ERROR 1 : "The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-]' running...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers