--旧テーブルの主キー制約を削除
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