UET Delete Script

--**********Delete Table Class Relationship(s)
IF EXISTS (SELECT TOP 1 1 FROM [dbo].[table_class] WHERE [TABLE_NAME] = 'jobtran' AND [class_name] = 'ILC_JobTran' AND [sys_delete] = 0) AND
    NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_JobTran' AND [fld_name] <> 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
        IF EXISTS (SELECT TOP 1 1 FROM [dbo].[table_class] WHERE [TABLE_NAME] = 'jobtran' AND [class_name] = 'ILC_JobTran' AND [CommittedRowPointer] IS NULL)
            DELETE [dbo].[table_class] WHERE [TABLE_NAME] = 'jobtran' AND [class_name] = 'ILC_JobTran'
        ELSE
            UPDATE [dbo].[table_class] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [TABLE_NAME] = 'jobtran' AND [class_name] = 'ILC_JobTran'

IF EXISTS (SELECT TOP 1 1 FROM [dbo].[table_class] WHERE [TABLE_NAME] = 'projlabr' AND [class_name] = 'ILC_Projlabr' AND [sys_delete] = 0) AND
    NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_Projlabr' AND [fld_name] <> 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
        IF EXISTS (SELECT TOP 1 1 FROM [dbo].[table_class] WHERE [TABLE_NAME] = 'projlabr' AND [class_name] = 'ILC_Projlabr' AND [CommittedRowPointer] IS NULL)
            DELETE [dbo].[table_class] WHERE [TABLE_NAME] = 'projlabr' AND [class_name] = 'ILC_Projlabr'
        ELSE
            UPDATE [dbo].[table_class] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [TABLE_NAME] = 'projlabr' AND [class_name] = 'ILC_Projlabr'

IF EXISTS (SELECT TOP 1 1 FROM [dbo].[table_class] WHERE [TABLE_NAME] = 'Projtran' AND [class_name] = 'ILC_Projtran' AND [sys_delete] = 0) AND
    NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_Projtran' AND [fld_name] <> 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
        IF EXISTS (SELECT TOP 1 1 FROM [dbo].[table_class] WHERE [TABLE_NAME] = 'Projtran' AND [class_name] = 'ILC_Projtran' AND [CommittedRowPointer] IS NULL)
            DELETE [dbo].[table_class] WHERE [TABLE_NAME] = 'Projtran' AND [class_name] = 'ILC_Projtran'
        ELSE
            UPDATE [dbo].[table_class] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [TABLE_NAME] = 'Projtran' AND [class_name] = 'ILC_Projtran'


--**********Delete Class Field Relationship(s)
IF EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_JobTran' AND [fld_name] = 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
    UPDATE [dbo].[user_class_fld] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [class_name] = 'ILC_JobTran' AND [fld_name] = 'Uf_ILC_Timesheet'

IF EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_Projlabr' AND [fld_name] = 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
    UPDATE [dbo].[user_class_fld] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [class_name] = 'ILC_Projlabr' AND [fld_name] = 'Uf_ILC_Timesheet'

IF EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_Projtran' AND [fld_name] = 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
    UPDATE [dbo].[user_class_fld] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [class_name] = 'ILC_Projtran' AND [fld_name] = 'Uf_ILC_Timesheet'


--**********Delete Class(s)
IF EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class] WHERE class_name = 'ILC_JobTran' AND [sys_delete] = 0) AND
    NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_JobTran' AND [fld_name] <> 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
    UPDATE [dbo].[user_class] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [class_name] = 'ILC_JobTran'

IF EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class] WHERE class_name = 'ILC_Projlabr' AND [sys_delete] = 0) AND
    NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_Projlabr' AND [fld_name] <> 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
    UPDATE [dbo].[user_class] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [class_name] = 'ILC_Projlabr'

IF EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class] WHERE class_name = 'ILC_Projtran' AND [sys_delete] = 0) AND
    NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_Projtran' AND [fld_name] <> 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
    UPDATE [dbo].[user_class] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [class_name] = 'ILC_Projtran'


--**********Delete Field
IF EXISTS (SELECT TOP 1 1 FROM [dbo].[user_fld] WHERE [fld_name] = 'Uf_ILC_Timesheet' AND [sys_delete] = 0) AND
    NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [fld_name] = 'Uf_ILC_Timesheet' AND [sys_delete] = 0)
    UPDATE [dbo].[user_fld] SET [sys_apply] = 'Delete', [sys_delete] = 1 WHERE [fld_name] = 'Uf_ILC_Timesheet'