If exists table using dynamic sql

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

re: If exists table using dynamic sql

What do you have so far?

-- CK

re: If exists table using dynamic sql

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?

re: If exists table using dynamic sql

try:
or

Happy Coding!!!

--- CK