主键的定义

来源: BlogBus 原始链接: http://oiea.blogbus.com:80/logs/2004/08/319026.html 存档链接: https://web.archive.org/web/20060225015642id_/http://oiea.blogbus.com:80/logs/2004/08/319026.html

主键的定义 一：在建表语句中定义 CREATE TABLE EmailContacts ( ContactID int Not Null CONSTRAINT pk_EmailContacts_ContactID PRIMARY KEY CLUSTERED , FirstName nvarchar(20), LastName nvarchar(35), Email1 nvarchar (255) ) 二：在修改语句中定义 ALTER TABLE ContactExtProps ADD CONSTRAINT pk_ContactExtProps_ContactID_PropID PRIMARY KEY NONCLUSTERED ( ContactID, PropID ) oiea 发表于 2004-08-10 | 引用Trackback(0) | 编辑