表添加到我创建的每个数据库中 [英] Table added to every database I create

问题描述

我从来没有听说过这个，也没有人问我。我大约一年前通过SSMS创建了一个数据库，并在其中放入了一个4GB的表。我不知道我做了什么，但每次创建新数据库时，它都会自动将该表的副本放在那里。这很容易删除，但会让数据库创建变得很痛苦。



我会很感激解决方案以及我是怎么做到的。



谢谢

I have never heard of this nor has anyone I've asked. I created a database via SSMS about a year ago and put a 4GB table in it. I don't know what I did, but every time I create a new database it puts a copy of that table in there automatically. It's easy to delete but makes DB creation a pain.

A solution would be appreciated as well as learning how the hell I did it.

Thanks

推荐答案

您已在模型数据库中创建了该表。每个数据库创建都会复制一个。请注意，在SQL Server中不是数据库，但实例是顶级逻辑和功能对象。



[更新]

不是主人，模型。

You have created that table in the model database. That one is replicated on every database creation. Please noted, that in SQL Server not the database, but the instance is the top level logical and functional object.

[Update]
Not master, model.

这篇关于表添加到我创建的每个数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！