如何通过Management Studio(不是通过查询)在SQL Server 2005中设置唯一键? [英] How to set unique key in SQL server 2005 by Management Studio (Not by query) ?

问题描述

如何通过Management Studio在SQL Server 2005中设置唯一键(不是通过查询)?

How to set unique key in SQL server 2005 by Management Studio (Not by query) ?

推荐答案

您需要阅读一本书(任何本书！)，或在网络上参阅许多教程...

唯一键和主键之间有区别.
MSDN:主键约束 [ MSDN:唯一键约束 [

You need to read a book (any book!) or refer number of tutorials on web...

There is a difference between unique key and primary key.
MSDN: Primary key Constraints[^]

MSDN: Unique Key Constraints[^]

After creating a table, you define the columns. There is a property window associated with a column created, use that for setting various properties/constraints for that column. There is a right click option too for setting selected constraints.

浏览此链接
http://www.exforsys.com/tutorials/sql-server-2005/sql-server-defining-indexes.html

Browse this link
http://www.exforsys.com/tutorials/sql-server-2005/sql-server-defining-indexes.html

这篇关于如何通过Management Studio(不是通过查询)在SQL Server 2005中设置唯一键?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！