When I add a new database to our dev server (using SSMS), it automatically creates 5 tables.
These are copies of application tables that already exist in another database.
I assume this is some recent SQL Server feature I don't know about where tables can be marked as 'common' or some such, and so get added automatically to new databases.
But how can I stop it happening?
For the avoidance of confusion, this database is not scripted, it is created directly from the SSMS GUI (right-click Databases > New Database)
(moved from StackOverflow)