If exists table using dynamic sql

[SnehaAgrawal]

Hi
I want to check if a particular table exists or not in my DB.But that I have to check using dynamic sql.Can anyone provide me with the syntax

[ck9663]

What do you have so far?

-- CK

[SnehaAgrawal]

I didn't get u?
What I am trying to do is use the following query if that particular table exist in my DB.
The query is

select * from @Tablename

@Tablename is my parameter passed from my prog.
before using the select query I just wanna check if that table exists in my DB if Yes then go for select else return from my SP

could u help out with this?

[ck9663]

try:

IF OBJECT_ID(@Tablename) is not null
  then proceed
else
  table does not exist
 

or

if exists(select 1 from dbname..sysobjects where name = @Tablename and xtype = 'U')
   then proceed
else
  table does not exists
 
 

Happy Coding!!!

--- CK