/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 vote174 views1 answer
Inserted row count tsql
SQL
0 vote196 views1 answer
Look at running processes redshift
SQL
0 vote175 views1 answer
Openquery join two tables
SQL
0 vote187 views1 answer
How to create a table based on another table in mysql
SQL
0 vote182 views1 answer
Dbms_output sql developer
SQL
0 vote163 views1 answer
Oracle db get table sizes
SQL
1 vote177 views3 answers
Union in sql
SQL
0 vote177 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote186 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
2 votes214 views3 answers
How to replace null values in sql
SQL