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

6 votes177 views1 answer
Rank function in oracle with example
SQL
0 vote191 views1 answer
Normalization in database 2nd normal form
SQL
-1 vote244 views3 answers
MAKE TABLE FIT in oracle sql
SQL
1 vote202 views1 answer
Oracle nvl2
SQL
0 vote205 views1 answer
Amount of entries in a table psql
SQL
0 vote247 views3 answers
Constraint sql
SQL
0 vote192 views1 answer
Add alternate add column sql
SQL
0 vote279 views1 answer
ORA-00942
SQL
0 vote231 views1 answer
Implode in sql query
SQL
0 vote187 views1 answer
Mysql Error Code: 1005
SQL