Skip to content
Search

DEV Community

LFC
LFC

Posted on

 

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!

Top comments (0)

DEV Community

An Animated Guide to Node.js Event Loop

>> Check out this classic DEV post <<

Read next

karenpayneoregon profile image

Insert/read SQL-Server images with EF Core, Dapper and SqlClient

Karen Payne -

nalgeon profile image

Regular Expressions in SQLite

Anton Zhiyanov -

efkumah profile image

An easy guide to understanding databases

Emmanuel Fordjour Kumah -

yosileyid profile image

Introducing PolygonDB: A Modern and Flexible Alternative to MongoDB with Advanced Data Management Features

Yosi Leyid -