/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

12 votes253 views10 answers
Google
SQL
2 votes218 views2 answers
Create temporary table in mysql
SQL
5 votes193 views1 answer
Oracle ORA-00054 origin
SQL
0 vote198 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote189 views1 answer
Ffeathers express mysql application users login
SQL
0 vote192 views2 answers
Mysql updating multiple column values from array variable
SQL
1 vote195 views1 answer
Oracle start job
SQL
0 vote276 views1 answer
Show all mongodb
SQL
0 vote149 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote202 views1 answer
Closure in sql
SQL