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

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



--テーブルをリネームしても主キー制約及びデフォルトフラグはリネームされないので
--リネームするテーブルの主キー制約及びデフォルトフラグを削除しておく
--※デフォルト「DF_」のDROPスクリプトは出力できないのでCREATEスクリプトから名称をコピペするしかない・・・
if exists (SELECT name FROM sysobjects WHERE (name = N'PK_ctdItemM') AND (xtype = 'PK'))
ALTER TABLE dbo.ctdItemM DROP CONSTRAINT PK_ctdItemM
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_ctdItemM_StandardPrice') AND (xtype = 'D'))
ALTER TABLE dbo.ctdItemM DROP CONSTRAINT DF_ctdItemM_StandardPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_ctdItemM_SellsPrice') AND (xtype = 'D'))
ALTER TABLE dbo.ctdItemM DROP CONSTRAINT DF_ctdItemM_SellsPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_ctdItemM_TransportPrice') AND (xtype = 'D'))
ALTER TABLE dbo.ctdItemM DROP CONSTRAINT DF_ctdItemM_TransportPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_ctdItemM_RegistrationType') AND (xtype = 'D'))
ALTER TABLE dbo.ctdItemM DROP CONSTRAINT DF_ctdItemM_RegistrationType
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_ctdItemM_SGroupCode') AND (xtype = 'D'))
ALTER TABLE dbo.ctdItemM DROP CONSTRAINT DF_ctdItemM_SGroupCode
GO

if exists (SELECT name FROM sysobjects WHERE (name = N'PK_W@ctdItemM') AND (xtype = 'PK'))
ALTER TABLE dbo.W@ctdItemM DROP CONSTRAINT PK_W@ctdItemM
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@ctdItemM_StandardPrice') AND (xtype = 'D'))
ALTER TABLE dbo.W@ctdItemM DROP CONSTRAINT DF_W@ctdItemM_StandardPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@ctdItemM_SellsPrice') AND (xtype = 'D'))
ALTER TABLE dbo.W@ctdItemM DROP CONSTRAINT DF_W@ctdItemM_SellsPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@ctdItemM_TransportPrice') AND (xtype = 'D'))
ALTER TABLE dbo.W@ctdItemM DROP CONSTRAINT DF_W@ctdItemM_TransportPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@ctdItemM_RegistrationType') AND (xtype = 'D'))
ALTER TABLE dbo.W@ctdItemM DROP CONSTRAINT DF_W@ctdItemM_RegistrationType
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@ctdItemM_SGroupCode') AND (xtype = 'D'))
ALTER TABLE dbo.W@ctdItemM DROP CONSTRAINT DF_W@ctdItemM_SGroupCode
GO

if exists (SELECT name FROM sysobjects WHERE (name = N'PK_cthPTenantTItem') AND (xtype = 'PK'))
ALTER TABLE dbo.cthPTenantTItem DROP CONSTRAINT PK_cthPTenantTItem
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_cthPTenantTItem_StockPrice') AND (xtype = 'D'))
ALTER TABLE dbo.cthPTenantTItem DROP CONSTRAINT DF_cthPTenantTItem_StockPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_cthPTenantTItem_StandardPrice') AND (xtype = 'D'))
ALTER TABLE dbo.cthPTenantTItem DROP CONSTRAINT DF_cthPTenantTItem_StandardPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_cthPTenantTItem_SellsPrice') AND (xtype = 'D'))
ALTER TABLE dbo.cthPTenantTItem DROP CONSTRAINT DF_cthPTenantTItem_SellsPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_cthPTenantTItem_TransportPrice') AND (xtype = 'D'))
ALTER TABLE dbo.cthPTenantTItem DROP CONSTRAINT DF_cthPTenantTItem_TransportPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_cthPTenantTItem_RegistrationType') AND (xtype = 'D'))
ALTER TABLE dbo.cthPTenantTItem DROP CONSTRAINT DF_cthPTenantTItem_RegistrationType
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_cthPTenantTItem_DisplayFlag') AND (xtype = 'D'))
ALTER TABLE dbo.cthPTenantTItem DROP CONSTRAINT DF_cthPTenantTItem_DisplayFlag
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_cthPTenantTItem_DisplaySeq') AND (xtype = 'D'))
ALTER TABLE dbo.cthPTenantTItem DROP CONSTRAINT DF_cthPTenantTItem_DisplaySeq
GO

if exists (SELECT name FROM sysobjects WHERE (name = N'PK_W@cthPTenantTItem') AND (xtype = 'PK'))
ALTER TABLE dbo.W@cthPTenantTItem DROP CONSTRAINT PK_W@cthPTenantTItem
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@cthPTenantTItem_StockPrice') AND (xtype = 'D'))
ALTER TABLE dbo.W@cthPTenantTItem DROP CONSTRAINT DF_W@cthPTenantTItem_StockPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@cthPTenantTItem_StandardPrice') AND (xtype = 'D'))
ALTER TABLE dbo.W@cthPTenantTItem DROP CONSTRAINT DF_W@cthPTenantTItem_StandardPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@cthPTenantTItem_SellsPrice') AND (xtype = 'D'))
ALTER TABLE dbo.W@cthPTenantTItem DROP CONSTRAINT DF_W@cthPTenantTItem_SellsPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@cthPTenantTItem_TransportPrice') AND (xtype = 'D'))
ALTER TABLE dbo.W@cthPTenantTItem DROP CONSTRAINT DF_W@cthPTenantTItem_TransportPrice
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@cthPTenantTItem_RegistrationType') AND (xtype = 'D'))
ALTER TABLE dbo.W@cthPTenantTItem DROP CONSTRAINT DF_W@cthPTenantTItem_RegistrationType
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@cthPTenantTItem_DisplayFlag') AND (xtype = 'D'))
ALTER TABLE dbo.W@cthPTenantTItem DROP CONSTRAINT DF_W@cthPTenantTItem_DisplayFlag
GO
if exists (SELECT name FROM sysobjects WHERE (name = N'DF_W@cthPTenantTItem_DisplaySeq') AND (xtype = 'D'))
ALTER TABLE dbo.W@cthPTenantTItem DROP CONSTRAINT DF_W@cthPTenantTItem_DisplaySeq
GO



--入れ替え対象テーブルをリネームする
EXEC sp_rename 'ctdItemM', 'OLD_ctdItemM'

EXEC sp_rename 'cthPTenantTItem', 'OLD_cthPTenantTItem'