SQL Server database deleted but still contain table structures? -


in sql server management studio 2008, have deleted database , checked directory database files stored , files have disappeared.

if "new database" sql server management studio same name deleted database expecting empty, find tables deleted database still exist.

so question is, how can tables exist in new database has same name database deleted?

when create database, sql server uses model database template. model database copied , renamed new database.

perhaps model database contains of tables. verify theory, examine model database under "system databases".


Comments

Popular posts from this blog

jquery - Invalid Assignment Left-Hand Side -

java - Play! framework 2.0: How to display multiple image? -

gmail - Is there any documentation for read-only access to the Google Contacts API? -