/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 vote359 views2 answers
Mysql on update current_timestamp
SQL
0 vote337 views1 answer
Get first monday of month sql
SQL
0 vote352 views1 answer
Mysql terminal run sql file
SQL
2 votes349 views4 answers
Mysql select into new table
SQL
2 votes330 views1 answer
Oracle cpu per session
SQL
0 vote338 views1 answer
Sql row number in result set
SQL
3 votes356 views1 answer
Uppercase and lowercase in sql
SQL
0 vote359 views1 answer
Cast float mysql
SQL
0 vote333 views1 answer
Linked server delete openquery
SQL
0 vote311 views1 answer
Sql truncate table referencing itself
SQL