You've already forked ssms-addin
mirror of
https://github.com/alex-bochkov/ssms-addin.git
synced 2025-11-23 22:04:53 +02:00
13 lines
575 B
Transact-SQL
13 lines
575 B
Transact-SQL
SELECT '[' + s.name + '].[' + o.name + '].[' + i.name + ']' AS keyname
|
|
from sys.foreign_keys i
|
|
INNER JOIN sys.objects o ON i.parent_object_id = o.object_id
|
|
INNER JOIN sys.schemas s ON o.schema_id = s.schema_id
|
|
WHERE i.is_not_trusted = 1 AND i.is_not_for_replication = 0;
|
|
GO
|
|
SELECT '[' + s.name + '].[' + o.name + '].[' + i.name + ']' AS keyname
|
|
from sys.check_constraints i
|
|
INNER JOIN sys.objects o ON i.parent_object_id = o.object_id
|
|
INNER JOIN sys.schemas s ON o.schema_id = s.schema_id
|
|
WHERE i.is_not_trusted = 1 AND i.is_not_for_replication = 0 AND i.is_disabled = 0;
|
|
GO
|