3

I am using SQL Server 2008. When I create a database by right clicking on the database folder and create new database, it creates the database with the name I given.

Additionally, the tables that are generated automatically are from a previously created table with different database name.

BIDeveloper
  • 2,628
  • 4
  • 36
  • 51
durai
  • 359
  • 1
  • 4
  • 12

1 Answers1

8

When a database is created, it is created based on the model database, as described here:

The model database is used as the template for all databases created on an instance of SQL Server. Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system. The entire contents of the model database, including database options, are copied to the new database.

So, you probably just need to remove the tables from model.

Gordon Linoff
  • 1,242,037
  • 58
  • 646
  • 786
  • I was able to remove the view from the model database but i cant find any tables in there! what i am missing? – durai May 09 '16 at 12:08
  • I cant able to find the tables in model database! what should i do to remove the tables from model and where to find them – durai May 09 '16 at 12:20
  • @durai . . . There are a bunch of system tables that are created when you create a database. You should edit the question and explain what the tables are. – Gordon Linoff May 09 '16 at 12:32
  • The tables i am mentioning are user created tables – durai May 09 '16 at 12:54