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 there,then 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. }

Checking if a table exists

Amit Gupta

Umer Ali