Herkese merhaba,
Bu kısımda SQL Server’da veritabanındaki tüm constraintleri listeleme kodları olacak.
SELECT OBJECT_NAME(object_id) AS ConstraintName ,
SCHEMA_NAME(schema_id) AS SchemaName ,
OBJECT_NAME(parent_object_id) AS TableName ,
type_desc AS ConstraintType
FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT'