Checking if a table exists

Question

Hi I am creating a SQL Server tables programmatically in C#. I want to check first if a table exists and only if it doesn't exist create one. I was looking around but I couln't find an easy way to do so. Any ideas? Thanks a lot  Rakefet

Vijaya Kadiyala · Answer

Hi Instead of making a call to find out wheather table is there or not i will issue CREATE table statement and if there are errors during this process i would like to handle it in Catch block. Thanks -- Vijaya Kadiyala www . DotNetVJ . com

Vijaya Kadiyala · Answer

Hi Instead of making a call to find out wheather table is there or not i will issue CREATE table statement and if there are errors during this process i would like to handle it in Catch block. Thanks -- Vijaya Kadiyala www . DotNetVJ . com

ramesh p · Answer

try{ DbOpen(); string strStatement =  CREATE TABLE MyNewName(PersonID COUNTER PRIMARY KEY FirstName varchar(20) LastName varchar(20)); OleDbCommand DBCommand = new OleDbCommand(strStatement DBConnection); DBCommand.ExecuteNonQuery( ); DbClose(); }catch(Exception EX) { }

Patricia · Answer

Try stored procedure sp_tables.

Tim Heap · Answer

Select count(*) from sysobjects where name = '[enter name here]' returns 0 if table not found..

venkata naidu · Answer

try { Create Table //if table already is therethen it raise the exception. //otherwise if table not there it create the table } Catch { do nothing // if table already is there then only it comes. }