这个触发器中如何检查要删除的数据表如何存在，请教各位老师，弟子三扣首了！

Question

CREATE    TRIGGER [e_del_subscribe_send_log] ON [dbo].[e_send_log] 
FOR DELETE
AS
declare @esl_id varchar(100)
Select @esl_id =esl_id From deleted
/*
delete each country subscripion Queue user table
*/
if object_id('e_subscribe_send_log_'+@esl_id) is not null
exec('drop TABLE [dbo].[e_subscribe_send_log_'+@esl_id+']')

Answer 1

if exists(select name from sysobjects where id=object_id('tablename') and xtype='u')
print 'exist'

Answer 2

if exists(select name from sysobjects where id=object_Id('tablename') )

Answer 3

CREATE    TRIGGER [e_del_subscribe_send_log] ON [dbo].[e_send_log] 
FOR DELETE
AS
declare @esl_id varchar(100)
Select @esl_id =esl_id From deleted
/*
delete each country subscripion Queue user table
*/if exists (select * from dbo.sysobjects where id = object_id(N'[e_subscribe_send_log_'+@esl_id+']') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
exec('drop table [dbo].[e_subscribe_send_log_'+@esl_id+']')GO

Answer 4

CREATE    TRIGGER [e_del_subscribe_send_log] ON [dbo].[e_send_log] 
FOR DELETE
AS
declare @esl_id varchar(100)
Select @esl_id =esl_id From deleted
/*
delete each country subscripion Queue user table
*/
if objectproperty(object_id(@esl_id),'IsUserTable')=1
  exec('drop TABLE [dbo].[e_subscribe_send_log_'+@esl_id+']')