check table is exist or not in database

Question

i want to program how to check that a table is exist in database or not using asp.net and c# please suggest a simple method

Sanjeeb Lenka · Answer

you can use this query select * from information_schema.tables where table_name ='your table name'

Girish Sapariya · Answer

Hi Anita check this: http://stackoverflow.com/questions/464474/check-if-a-sql-table-exists