/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 vote334 views1 answer
INSERT INTO table using OpenQuery
SQL
79 votes631 views6 answers
Grepper code
SQL
0 vote333 views1 answer
What is between operator
SQL
3 votes349 views1 answer
How to uninstall microsoft sql server
SQL
4 votes339 views1 answer
Oracle error compilation line
SQL
1 vote346 views1 answer
Pv mysql import
SQL
0 vote363 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote333 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote381 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
4 votes305 views3 answers
Create table if not exists postgresql
SQL