blob: 40a967c98634955b516c688ecec81d60ca8d7653 (
plain)
1
2
3
4
5
6
7
8
9
10
|
DECLARE @fk_name NVARCHAR(MAX)
SELECT TOP 1 @fk_name = name
FROM sys.foreign_keys
WHERE parent_object_id = object_id('adiantamento') AND object_name(referenced_object_id) = 'tipopagto'
DECLARE @sql NVARCHAR(MAX) = N'ALTER TABLE adiantamento DROP CONSTRAINT ' + @fk_name
IF @fk_name IS NOT NULL
exec sp_executesql @sql
|
