Trigger Preventing Table Creation in SQL Server
In this article, I will provide information about creating triggers that prevent table creation in SQL Server.
In SQL Server, in some cases, we may not want a table to be created in the current database.
You can easily do this using the code below.
CREATE TRIGGER StopTableCreation ON DATABASE FOR CREATE_TABLE AS PRINT 'This database does not allow new tables.'; ROLLBACK TRANSACTION; --Create Table Code CREATE TABLE Table1 ( ID INT );
When you run the above code, you will see a result similar to the one below.
As you can see, we could not create a table.
Good luck to everyone in business and life.