1、创建两个字段的外键
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
COMMIT
BEGIN TRANSACTION
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.AdminRightDetail ADD CONSTRAINT
FK_AdminRightDetail_AdminUserInfo FOREIGN KEY
(
AdminID
) REFERENCES dbo.AdminUserInfo
(
AdminID
)
GO
ALTER TABLE dbo.AdminRightDetail ADD CONSTRAINT
FK_AdminRightDetail_AminRightGroup FOREIGN KEY
(
GroupID
) REFERENCES dbo.AminRightGroup
(
GroupID
)
GO
COMMIT
2、创建两个字段的主键
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE NONCLUSTERED INDEX IX_AdminRightDetail ON dbo.AdminRightDetail
(
AdminID,
GroupID
) ON [PRIMARY]
GO
COMMIT
由此可以看到他是把我的主键当作了一个索引来建立的,所以我要写的创建主键索引和创建外键的写法是不相同的.