/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

8 votes163 views1 answer
Oracle current date plus 1 month
SQL
8 votes184 views3 answers
Postgres connection string
SQL
1 vote217 views1 answer
Postgres power
SQL
15 votes185 views2 answers
Select Options
SQL
8 votes176 views5 answers
Grant permission in postgres
SQL
1 vote197 views2 answers
Mysql insert generate serie
SQL
3 votes197 views2 answers
How to start mysql in terminal
SQL
5 votes200 views1 answer
Sql table columns
SQL
2 votes150 views1 answer
Latest record in sql
SQL
1 vote186 views4 answers
Postgres extract date from timestamp
SQL