/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 vote309 views2 answers
Postgresql gset
SQL
1 vote271 views1 answer
Can we drop a primary key
SQL
0 vote305 views1 answer
Get a list of tables and the primary key
SQL
2 votes309 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote285 views1 answer
How to install mysql without admin rights
SQL
7 votes310 views5 answers
Sql remove spaces
SQL
0 vote293 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
2 votes337 views3 answers
Xampp mysql database not starting
SQL
1 vote328 views1 answer
Sql server if exists update else insert
SQL
0 vote279 views1 answer
How to export table data from mysql table in sql format
SQL