/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 vote306 views1 answer
T sql return on letters only
SQL
9 votes314 views1 answer
Oracle get table schema
SQL
0 vote332 views1 answer
Mysql master slave setup with keepalived
SQL
11 votes315 views2 answers
Set default column value sql
SQL
0 vote326 views1 answer
What is ssrs and ssis in sql server
SQL
1 vote334 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote317 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote332 views2 answers
Alter table add multiple columns mysql
SQL
0 vote340 views1 answer
Compare subqueries oracle
SQL
0 vote333 views1 answer
Sql query to find duplicate email address
SQL