SQL Server 2008 automatically creates table when creating new database [duplicate]

Question

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.

Answer 1

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.