USERS_DROP.sql

-------------------------------------------------------------------------------------------------
-- USERS_DROP
-------------------------------------------------------------------------------------------------
SET NOCOUNT ON;
SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

DECLARE @IS_COMMIT BIT = 0;
-------------------------------------------------------------------------------------------------
USE VideoHosting;

BEGIN TRAN
PRINT N'➕ JOB IS STARTED';

IF NOT EXISTS (SELECT 1 FROM [sys].[tables] WHERE [name] = N'USERS') BEGIN
	PRINT N'❌ TABLE [USERS] WAS NOT FOUND';
END ELSE BEGIN
	DROP TABLE IF EXISTS [USERS];
	PRINT N'➕ DROP TABLE [USERS] IS COMPLETED';
END;

IF (@IS_COMMIT = 1) BEGIN
	COMMIT TRAN
	PRINT N'➕ DROP IS COMMITTED'
END ELSE BEGIN
    ROLLBACK TRAN
	PRINT N'❌ DROP IS ROLL-BACKED'
END;