Skip to content

Instantly share code, notes, and snippets.

@tompazourek

tompazourek/ListPKsAndFKs.sql

Created June 26, 2016 14:03
Show Gist options
  • Save tompazourek/b49f7f02829fa962b2c84f21a779b7ee to your computer and use it in GitHub Desktop.
Save tompazourek/b49f7f02829fa962b2c84f21a779b7ee to your computer and use it in GitHub Desktop.
Download ZIP
List foreign keys and primary keys in the database
Raw
ListPKsAndFKs.sql
SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,
SCHEMA_NAME(schema_id) AS SchemaName,
OBJECT_NAME(parent_object_id) AS TableName,
type_desc AS ConstraintType
FROM sys.objects
WHERE type_desc IN ('FOREIGN_KEY_CONSTRAINT','PRIMARY_KEY_CONSTRAINT')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment