/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 vote279 views1 answer
Php get closest location by latitude longitude
SQL
1 vote241 views1 answer
Foreign key in oracle sql developer
SQL
0 vote283 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote264 views2 answers
Change database postgres
SQL
0 vote301 views1 answer
Sql date time query find
SQL
2 votes296 views1 answer
Oracle generated column
SQL
0 vote286 views1 answer
Delete data from database sqlite android
SQL
0 vote277 views1 answer
Show size of all tables postgres
SQL
0 vote331 views3 answers
How to find all role in mysql
SQL
5 votes266 views1 answer
Pl sql asynchronous procedure calls
SQL