--入れ替え対象の旧テーブルをリネームするために
--リネーム先名称のテーブルがあれば削除する
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OLD_TDA消費税率M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OLD_TDA消費税率M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OLD_TDA商品M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OLD_TDA商品M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OLD_TDA材料M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OLD_TDA材料M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OLD_TSK伝票仕入売上明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OLD_TSK伝票仕入売上明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OLD_TSA仕入売上書類明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OLD_TSA仕入売上書類明細F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OLD_TKH小売販売TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OLD_TKH小売販売TRN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OLD_TC2演習M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OLD_TC2演習M]
GO



--テーブルをリネームしても主キー制約はリネームされないので
--リネームするテーブルの主キー制約を削除しておく
if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TDA消費税率M') AND (xtype = 'PK'))
ALTER TABLE dbo.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.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.TDA材料M DROP CONSTRAINT PK_TDA材料M
GO

if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TSK伝票仕入売上明細F') AND (xtype = 'PK'))
ALTER TABLE dbo.TSK伝票仕入売上明細F DROP CONSTRAINT PK_TSK伝票仕入売上明細F
GO

if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TSA仕入売上書類明細F') AND (xtype = 'PK'))
ALTER TABLE dbo.TSA仕入売上書類明細F DROP CONSTRAINT PK_TSA仕入売上書類明細F
GO

if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TKH小売販売TRN') AND (xtype = 'PK'))
ALTER TABLE dbo.TKH小売販売TRN DROP CONSTRAINT PK_TKH小売販売TRN
GO

if exists (SELECT name FROM sysobjects WHERE (name = N'PK_TC2演習M') AND (xtype = 'PK'))
ALTER TABLE dbo.TC2演習M DROP CONSTRAINT PK_TC2演習M
GO



--入れ替え対象テーブルをリネームする
EXEC sp_rename 'TDA消費税率M', 'OLD_TDA消費税率M'

EXEC sp_rename 'TDA商品M', 'OLD_TDA商品M'

EXEC sp_rename 'TDA材料M', 'OLD_TDA材料M'

EXEC sp_rename 'TSK伝票仕入売上明細F', 'OLD_TSK伝票仕入売上明細F'

EXEC sp_rename 'TSA仕入売上書類明細F', 'OLD_TSA仕入売上書類明細F'

EXEC sp_rename 'TKH小売販売TRN', 'OLD_TKH小売販売TRN'

EXEC sp_rename 'TC2演習M', 'OLD_TC2演習M'