Trigger Preventing Table Creation in SQL Server

Hello everyone,

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.