Report to return all foreign key information

The purpose of this task is to generate a report showing all your foreign keys. Generally this would be considered  nothing special only that this script also returns the tables, column foreign key constraint name and the relationship properties.Here's how to do it:First of all copy the script and paste it in Query AnalyzerStep 1: […]

5 (1)

2004-07-16 (first published: )

968 reads

Blogs

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

update table b if b.time falls between any of table a rows start/stop

By delizat4g

I'm trying to find a way to rewrite this dusty old cursor set based,...

Check if number exists in a column

By tim.stutzman

Hello, I am pulling some address data from a legacy system and it has...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers