/SQL/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

Similar codes

0 vote156 views1 answer
Sql random decimal
SQL
1 vote193 views1 answer
Hangfire clear all jobs
SQL
20 votes167 views2 answers
Mysql bigint max value
SQL
0 vote168 views1 answer
Mysql sql.gz
SQL
0 vote176 views1 answer
WHERE not regex in SQL
SQL
0 vote161 views1 answer
C# mysql data reader from two tables
SQL
1 vote168 views3 answers
What is union in sql
SQL
0 vote159 views1 answer
Sql comparison operators
SQL
11 votes187 views1 answer
How to get ddl for materialized view
SQL
0 vote164 views1 answer
Postgres type equivalent to timespan c#
SQL