how to check a particular table is exists /not in database

if EXISTS (select * from INFORMATION_SCHEMA.tables where table_name = 'tablename')
Select 'Table found'
ELSE SELECT 'TABLE NOT FOUND'