VIDEOS_DROP.sql

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

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

BEGIN TRAN
PRINT N'➕ JOB IS STARTED';

IF NOT EXISTS (SELECT 1 FROM [sys].[tables] WHERE [name] = N'VIDEOS') BEGIN
	PRINT N'❌ TABLE [VIDEOS] WAS NOT FOUND';
END ELSE BEGIN
	DROP TABLE IF EXISTS [VIDEOS];
	PRINT N'➕ DROP TABLE [VIDEOS] 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;