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

972 reads

Blogs

Azure SQL Database – Contained user Model

By

I always follow a contained user model when setting up users within my Azure...

Logging Messages with Raiserror – #SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 8 Mar 2021

By

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

Read the latest Blogs

Forums

History Snapshots - Bulk create for many reports

By Thorsten1981

Hi guys, just found the History Snapshot Option within SSRS. Do you know if...

Wait for query to finish before returning results

By oRBIT

When I do "select * from ... " from a large table, the result...

Reading a Specific File from an S3 bucket Using Python

By prashant239

Comments posted to this topic are about the item Reading a Specific File from...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers