create TRIGGER [dbo].[TR_DATAFORMINSTANCE_DELETE] on dbo.DATAFORMINSTANCECATALOG with execute as owner AFTER DELETE as
set nocount on
declare @DataFormID uniqueidentifier
-- declare a cursor that returns all of the deleted data forms
declare deleted_dataform_cursor cursor local FAST_FORWARD for
select ID from deleted
OPEN deleted_dataform_cursor
FETCH NEXT from deleted_dataform_cursor
into @DataFormID
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
begin
-- delete procedures and views that were created for the data form
exec USP_DATAFORMINSTANCE_DELETESUPPORTINGPROCEDURES @DataFormID
FETCH NEXT from deleted_dataform_cursor into @DataFormID
end
CLOSE deleted_dataform_cursor
DEALLOCATE deleted_dataform_cursor
|
Trigger Definition
