//This stored procedure Return 'Flag' as 1/0 to mark presence/absence of table in database. It uses the database specified in connection string as host database.
create proc check_table_exist (@table_name varchar(500))
select 'Flag'=count(*) from sysobjects where type='U' and name=@table_name
SQL Server has sysobjects as the system table which contains the information about various objects in SQL Server.