/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

1 vote283 views1 answer
Last 6 months postgresql
SQL
0 vote280 views1 answer
Mysql query single row
SQL
0 vote277 views1 answer
Install ms sql server management studio
SQL
0 vote280 views1 answer
Dnsmasq.conf location macos
SQL
0 vote279 views3 answers
Convert sql query to python pandas
SQL
0 vote302 views3 answers
How to run sql query
SQL
0 vote299 views3 answers
Sql query checker
SQL
0 vote364 views1 answer
Sqlite display headers on columns
SQL
0 vote306 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote332 views3 answers
Characters found after end of sql statement
SQL