//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))
as
begin
select 'Flag'=count(*) from sysobjects where type='U' and name=@table_name
end

SQL Server has sysobjects as the system table which contains the information about various objects in SQL Server.