Record and relations

Before delete: check if record is related with other tables

DECLARE @tableName nvarchar(50) = 'CGAPDC'
DECLARE @valueToSearch nvarchar(100) = '320000001'
SELECT 'SELECT * FROM ' + TableName + ' WHERE ' + ColName + ' = ''' + @valueToSearch + '''' As sSQL
FROM (
SELECT
OBJECT_NAME(f.parent_object_id) TableName,
COL_NAME(fc.parent_object_id,fc.parent_column_id) ColName
FROM
sys.foreign_keys AS f
INNER JOIN
sys.foreign_key_columns AS fc
ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN
sys.tables t
ON t.OBJECT_ID = fc.referenced_object_id
WHERE
OBJECT_NAME (f.referenced_object_id) = @tableName
) T1