if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPLメッセージ取得受信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SPLメッセージ取得受信]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPLメッセージ取得送信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SPLメッセージ取得送信]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPLメッセージ受信一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SPLメッセージ受信一覧]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPLメッセージ送信一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SPLメッセージ送信一覧]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPLメッセージ送信先一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SPLメッセージ送信先一覧]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPLメッセージ開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SPLメッセージ開封]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPTメッセージ受信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SPTメッセージ受信]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPTメッセージ送信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SPTメッセージ送信]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMSメッセージ受信F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMSメッセージ受信F]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMSメッセージ送信F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMSメッセージ送信F]
GO