--旧テーブルの主キー制約を削除 if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TC1システムM') AND (xtype = 'PK')) ALTER TABLE dbo.OLD_TC1システムM DROP CONSTRAINT PK_TC1システムM GO if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TDA会社M') AND (xtype = 'PK')) ALTER TABLE dbo.OLD_TDA会社M DROP CONSTRAINT PK_TDA会社M GO if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TDA勘定科目M') AND (xtype = 'PK')) ALTER TABLE dbo.OLD_TDA勘定科目M DROP CONSTRAINT PK_TDA勘定科目M GO if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TTA社員台帳F') AND (xtype = 'PK')) ALTER TABLE dbo.OLD_TTA社員台帳F DROP CONSTRAINT PK_TTA社員台帳F GO if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TC2演習M') AND (xtype = 'PK')) ALTER TABLE dbo.OLD_TC2演習M DROP CONSTRAINT PK_TC2演習M GO --主キー制約を再登録 ALTER TABLE [dbo].[TC1システムM] ADD CONSTRAINT [PK_TC1システムM] PRIMARY KEY CLUSTERED ( [システムCD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TDA会社M] ADD CONSTRAINT [PK_TDA会社M] PRIMARY KEY CLUSTERED ( [システムCD], [演習CD], [会社CD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TDA勘定科目M] ADD CONSTRAINT [PK_TDA勘定科目M] PRIMARY KEY CLUSTERED ( [システムCD], [演習CD], [勘定CD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TTA社員台帳F] ADD CONSTRAINT [PK_TTA社員台帳F] PRIMARY KEY CLUSTERED ( [システムCD], [演習CD], [会社CD], [社員番号], [支給年月] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TC2演習M] ADD CONSTRAINT [PK_TC2演習M] PRIMARY KEY CLUSTERED ( [システムCD], [演習CD] ) ON [PRIMARY] GO