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
Post a Comment