/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 votes348 views1 answer
Tsql copy table
SQL
0 vote194 views2 answers
Raise notice in postgresql function
SQL
3 votes199 views2 answers
Oracle sql drop sequence
SQL
0 vote197 views1 answer
Run mssql server terminal
SQL
0 vote225 views1 answer
Sql field equals multiple values
SQL
0 vote225 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote187 views1 answer
Create table employees oracle
SQL
1 vote206 views1 answer
Update from select oracle
SQL
0 vote285 views1 answer
Sql select max value for each group
SQL
3 votes214 views3 answers
Mysql order by list
SQL