TR_DATAFORMINSTANCE_DELETE

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