修改SQL Server 2008 R2中的表 [英] Modify table in sql server 2008 R2

问题描述

您好所有访客
我在修改sql server 2008 R2中的表时遇到问题.
我创建了一个表(员工).它有7个字段.我在该表上工作后，我想我错过了该表上的1个重要字段.因此，我需要在表上添加新字段.在表上添加新字段之后，我保存它，但是它不允许我保存.它让我将其保存到文件中.

有人知道我可以解决这个问题吗?

最好的问候，

Hi all visitors
I have problem with modified my table in sql server 2008 R2.
i have created one table(Employee). it has 7 fields.After i work on that table, I think that i missed 1 important field on that table.So i need to Add new field on my table.After i add new field on my table, I save it but it doesn''t let me to Save. It lets me to save it to a file.

Anybody know how i can solve that problem?

Best Regards,

推荐答案

如果在SQL Server Management Studio中进行此操作，则可以通过以下步骤将其保存到表中.
1.点击工具->选项
2.单击设计器->表和数据库设计器.
3.取消选中阻止保存需要重新创建表的更改".
4.单击确定.
尝试再次保存该表.

If you are doing this in SQL Server Management Studio, here are some steps that will allow you to save to the table.
1. Click Tools->Options
2. Click Designers->Table and Database Designers.
3. Uncheck Prevent saving Changes that require table re-creation.
4. Click OK.
Try saving the table again.

这篇关于修改SQL Server 2008 R2中的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！