[Script Of Apr. 1] How to list the foreign keys and primary keys of a SQL Server table

  • Article

image

Apr.

1

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/How-to-list-the-foreign-dd76873a.

You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This T-SQL script will demonstrate how to list the foreign keys and the primary keys the foreign keys reference to.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery