blob: 9eed697fa59041bad1e39bbab0d94c2a43651f62 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
IF (object_id( 'tipopagto' ) IS NOT NULL)
BEGIN
declare @sql nvarchar(max) = (select
'alter table ' + quotename(schema_name(schema_id)) + '.' +
quotename(object_name(parent_object_id)) +
' drop constraint '+quotename(name) + ';'
from sys.foreign_keys s
where object_name(referenced_object_id) = 'tipopagto' for xml path('')
)
EXEC sp_executesql @sql;
END
|
