/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 vote101 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote112 views1 answer
ORACLE PARSE STRING
SQL
0 vote107 views1 answer
Mysql update from n to 100
SQL
0 vote107 views1 answer
Sql server pivot rows to columns
SQL
0 vote106 views1 answer
Mql5 datetime get hour
SQL
0 vote102 views1 answer
Low level operator in dbms
SQL
0 vote98 views1 answer
Postgresql alter column nullable
SQL
6 votes95 views1 answer
Oracle list primary key
SQL
1 vote84 views1 answer
Can we drop a primary key
SQL
-2 votes105 views1 answer
Remove root password mysql
SQL