[RecreateDatabase] #sqlserver #sql

exe.sql

EXEC sp_RecreateDatabase @DatabaseName = N'YourDatabase'; -- Thay 'YourDatabase' bằng tên cơ sở dữ liệu của bạn

index.sql

CREATE PROCEDURE sp_RecreateDatabase
    @DatabaseName nvarchar(50)
AS
BEGIN
    IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = @DatabaseName)
    BEGIN
        EXEC('ALTER DATABASE [' + @DatabaseName + '] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;');
        EXEC('DROP DATABASE [' + @DatabaseName + '];');
    END

    EXEC('CREATE DATABASE [' + @DatabaseName + '];');
    EXEC('ALTER DATABASE [' + @DatabaseName + '] SET RECOVERY SIMPLE;');
END
GO