Answers for "query to get all primary keys and foreign key"

query to get all primary keys and foreign key

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')
GO

Posted by: Guest on January-11-2022

Code answers related to "query to get all primary keys and foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "query to get all primary keys and foreign key"

Code answers related to "query to get all primary keys and foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "query to get all primary keys and foreign key"

Code answers related to "query to get all primary keys and foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us