To check whether data table is exist or not

Question

Hi I am trying to write the code using c#. Needed code to check whether the particulare data table from a database is exist or not. If not then create the table. Please help me.

Len La Sala · Answer

Hi For SQL Server try this it works for me I found it at http://sqlserver2000.databases.aspfaq.com/how-do-i-determine-if-a-table-exists-in-a-sql-server-database.html IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_NAME='tablename') SELECT 'tablename exists.' ELSE SELECT 'tablename does not exist.'