/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

2 votes220 views1 answer
Db.relationship sqlalchemy flask
SQL
4 votes231 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote229 views1 answer
How to get button for every record from mysql
SQL
1 vote199 views1 answer
Create temporal table in sql
SQL
12 votes206 views4 answers
Psql command not found
SQL
0 vote204 views1 answer
Mysql Error Code: 1005
SQL
32 votes208 views6 answers
Insert into values select
SQL
0 vote209 views1 answer
ORACLE PARSE STRING
SQL
0 vote201 views2 answers
How to type a blank discord messgae
SQL
0 vote202 views1 answer
Sql datediff month
SQL