Skip to content

DEV Community

DEV Community is a community of 722,735 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in

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!

Discussion (0)

Subscribe

Read next

Should I use SQLite, PostgreSQL, or MySQL?

Saji Wang - Sep 21

Create an Oracle database Docker image

zankyr - Aug 23

How browsers handle authentication?

Ahmed Ossama - Sep 25

Spring Data — Transactional Caveats

Semyon Kirekov - Sep 25