Disable database droping sql

CREATE OR ALTER TRIGGER TRG_PreventDropProductionDB ON ALL SERVER
FOR DROP_DATABASE
AS
BEGIN
    IF DB_NAME() = 'ProductionDatabase'
        BEGIN
            RAISERROR('You cannot drop the production database.', 16,1);
            ROLLBACK;
        END
END
GO

Source: dba.stackexchange.com

Similar codes

-1 vote256 views1 answer
Add bool column in sql
SQL
0 vote244 views1 answer
Time mysql w3
SQL
5 votes240 views2 answers
Oracle to_timestamp
SQL
0 vote251 views1 answer
Python mysql executemany
SQL
0 vote266 views2 answers
Athena drop partition
SQL
2 votes276 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote276 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote269 views2 answers
How to add CHECK constraint to a column in postgres
SQL
4 votes262 views1 answer
Create db table
SQL
0 vote215 views1 answer
Mysqli or pdo
SQL