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 vote364 views1 answer
Query for all indexes in table postgres
SQL
0 vote351 views1 answer
Mariadb mysql root access denied
SQL
0 vote392 views1 answer
000webhost database values insert
SQL
4 votes322 views1 answer
Sql list users and roles
SQL
0 vote349 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote403 views1 answer
Add new column in sql with foreign key
SQL
0 vote393 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote357 views1 answer
Create query in where clasue
SQL
0 vote398 views1 answer
Dataframe lambda elif
SQL
0 vote331 views1 answer
Deleted table in sql trigger
SQL