SqlServer 初始化和升级脚本

 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

由此可以看到他是把我的主键当作了一个索引来建立的,所以我要写的创建主键索引和创建外键的写法是不相同的.