SQL create empty database

Question

when I create database in sql server, it creates some tables by default inside new database from another one, which I had created earlier, can anyone pls tell me why this is happening and how to prevent it?

I am using the following command:

CREATE DATABASE [Databasename]

Are you sure you're creating a new database, not copying? Please post some examples of your problem. — SIGSTACKFAULT
– SIGSTACKFAULT, Commented Oct 26, 2016 at 23:22

Hadi · Accepted Answer · 2016-10-26 23:30:19Z

2

Make sure you have not modified model database

The model database is used as the template for all databases created on an instance of SQL Server

answered Oct 26, 2016 at 23:30

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Giorgi Isaiashvili Over a year ago

Thats the idea, maybe I have accidently done it. Thanks a lot I'll check it

Hadi Over a year ago

Give us a feedback :)

Giorgi Isaiashvili Over a year ago

It was exactly as you said bro. Thanks again

Collectives™ on Stack Overflow

SQL create empty database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related