DEV Community

LFC

Posted on Sep 24, 2019

Query to get Primary Key & Foreign Key columns

#sql #database #sqlserver

I want to share this query for SQL Server to get PK, FK, and Data Type information from a DB Table.

Enjoy!

Timeless DEV post...

The most used technology by developers is not Javascript.

It's not Python or HTML.

It hardly even gets mentioned in interviews or listed as a pre-requisite for jobs.

I'm talking about Git and version control of course.

One does not simply learn git