/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 vote128 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote130 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote140 views1 answer
Create table with float datatype in sql server
SQL
1 vote130 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote137 views1 answer
How to find sql server name
SQL
0 vote132 views1 answer
Empty table sqlite
SQL
0 vote142 views1 answer
Look at running processes redshift
SQL
1 vote136 views1 answer
Round one decimal place mysql
SQL
0 vote141 views1 answer
Query for backup a database at another location in file system
SQL
2 votes145 views1 answer
Install postgresql centos 5
SQL