|
?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
由此可以看到他是把我的主键当作了一个索引来建立的,所以我要写的创建主键索引和创建外键的写法是不相同的.
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
