Giorgi Isaiashvili
Reputation: 91
SQL create empty database
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]
Upvotes: 1
Views: 3610
Answers (1)
Hadi
Reputation: 37368
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
Upvotes: 2
Related Questions
- TSQL | Create Database
- How to create and use database directly after creation in SQL Server?
- SQL Completely Empty Database
- Create database if not exists and then create tables in that database in SQL Server
- How to create a database from existing Database without any data?
- SQL - create database and tables in one script
- How to create a new database and tables inside it in SQL Server?
- Create a database using T SQL on a specified location
- Create a database from another database?
- sql create table