简明扼要,,,,复合主键的约束怎么写??
RT。。。。用代码写,,不是用鼠标加
[解决办法]
试试这个:
alter table 表
add constraint pk_xxxx primary key(字段1,字段2)
[解决办法]
USE [北风贸易]
GO
/****** 对象: Index [PK_authors] 脚本日期: 01/13/2014 20:35:44 ******/
ALTER TABLE [dbo].[authors] ADD CONSTRAINT [PK_authors] PRIMARY KEY CLUSTERED
(
[au_id] ASC,
[au_lname] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]