/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 vote130 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote143 views1 answer
Postgres reorder columns
SQL
3 votes165 views2 answers
@sqlresultsetmapping
SQL
1 vote74 views1 answer
Postgres reset auto increment
SQL
0 vote121 views1 answer
Php delete database
SQL
0 vote160 views1 answer
Sparql if bound query
SQL
5 votes120 views2 answers
Get number of columns sql
SQL
0 vote78 views1 answer
How to see the content of tables in pgadmin
SQL
2 votes165 views1 answer
Tcl in sql
SQL
0 vote123 views1 answer
Python sql last insertend
SQL