bluebunny72 icon

UET Delete Script

bluebunny72 | PRO | 02/03/17 04:31:02 PM UTC | 0 ⭐ | 462 👁️ | Never ⏰ | []
SQL |

4.49 KB

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
--**********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'

Comments