/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

2 votes351 views1 answer
Oracle apex who is connected
SQL
11 votes369 views3 answers
Change column name sql server management studio
SQL
1 vote369 views1 answer
Continue in sql
SQL
0 vote323 views1 answer
Mariadb list tables
SQL
0 vote353 views1 answer
How to create an SQL save method in ruby
SQL
11 votes365 views3 answers
Sqlite3 create table from another table
SQL
0 vote350 views1 answer
Postgresql alter column nullable
SQL
0 vote350 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote352 views2 answers
Change database postgres
SQL
0 vote370 views1 answer
How to get specific salary in sql
SQL