if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP0アクセスログログインID一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SP0アクセスログログインID一覧]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP0アクセスログ一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SP0アクセスログ一覧]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP0アクセスログ更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SP0アクセスログ更新]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP0アクセスログ集計]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SP0アクセスログ集計]
GO

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

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