Condividi tramite


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

image

Nov.

19

image

image

Script Download:   

The articles is available for download from https://gallery.technet.microsoft.com/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