如何为表中的现有列添加标识约束 - 请参阅帮助 [英] How I Can Add Identity Constraint For The Existing Column In A Table-Pls Help

问题描述

如何为表格中的现有列添加标识约束？例如：table_name - employee及其中一个要生成标识的列是employee_id请帮助

How i can add identity constraint for the existing column in a table ? for example : table_name - employee and its one of the column to make identity is employee_id Kindly help

推荐答案

试试这个：



添加或删除身份列上的属性



如果它说



SQL中不允许保存更改服务器

Try this:

Add or Remove Identity Property on Column

if it says

"Saving changes is not permitted in SQL Server"

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers.  clear the Prevent saving changes that require the table to be re-created check box.

这篇关于如何为表中的现有列添加标识约束 - 请参阅帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！