2018-07-19 18:18:19 +01:00
|
|
|
declare @TableName nvarchar(max)
|
|
|
|
|
set @TableName = 'yourTableName'
|
|
|
|
|
--In case you wish to delete objects related to all the tables you can uncomment the following:
|
2018-07-19 18:24:34 +01:00
|
|
|
--set @TableName = ''
|
2018-07-19 18:18:19 +01:00
|
|
|
|
2017-10-04 12:06:48 -07:00
|
|
|
-- Generate the script to drop Data Sync tables
|
2018-07-19 18:18:19 +01:00
|
|
|
select 'drop table [DataSync].['+ st.name+ '];' from sys.tables as st join sys.schemas as ss on ss.schema_id = st.schema_id
|
|
|
|
|
where ss.name = 'DataSync' and st.name like '%' + @TableName + '_dss_%'
|
|
|
|
|
|
|
|
|
|
-- Generate the script to drop Data Sync stored procedures
|
|
|
|
|
select 'drop procedure [DataSync].['+ sp.name+ '];' from sys.procedures as sp join sys.schemas as ss on ss.schema_id = sp.schema_id
|
|
|
|
|
where ss.name = 'DataSync' and sp.name like '%' + @TableName + '_dss_%'
|
2017-10-04 10:56:18 -07:00
|
|
|
|
2018-07-19 18:18:19 +01:00
|
|
|
-- Generate the script to delete Data Sync triggers
|
|
|
|
|
select 'drop trigger [' + schema_name(schema_id) + '].[' + name + ']'
|
|
|
|
|
from sys.objects where type = 'TR' and name like '%' + @TableName + '_dss_%'
|
|
|
|
|
|
|
|
|
|
-- Generate the script to delete Data Sync-related udtt
|
|
|
|
|
select 'drop type [DataSync].['+ st.name+ '];' from sys.types as st join sys.schemas as ss on st.schema_id = ss.schema_id
|
2018-12-03 19:16:17 +00:00
|
|
|
where ss.name = 'DataSync' and st.name like '%' + @TableName + '_dss_%'
|
