DaniWeb Forum Index > Software Development > C#

C# RSS

How to check if table exists, if not create it (exceptions)...

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2007

Posts: 35

Reputation: Ratte is an unknown quantity at this point

Solved Threads: 0

Ratte

Offline

Light Poster

How to check if table exists, if not create it (exceptions)...

Mar 26th, 2008

I need my program to connect to a database, check if a table exists, and if not, create it.

I intend to check the presence of a table by simply running a "select * from table" query via an SqlCommand. I am going to put this in a try block. My problem is, how/where do I actually create the table? In the catch block? What if the SqlException was not due to the table not existing, but for instance due to an incorrect password? What is the best way to do this?

Thanks!

•

Join Date: Nov 2006

Posts: 436

Reputation: JerryShaw is on a distinguished road

Solved Threads: 72

JerryShaw

Offline

Posting Pro in Training

Re: How to check if table exists, if not create it (exceptions)...

Mar 27th, 2008

A better approach is to see if it exists through sysObjects, and create it there, catch any errors on that.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
IF  NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Country_Master]') AND type in (N'U'))
 
CREATE TABLE [dbo].[Country_Master](
	[County_id] [int] IDENTITY(1,1) NOT NULL,
	[CountryName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
IF  NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Country_Master]') AND type in (N'U'))

CREATE TABLE [dbo].[Country_Master](
	[County_id] [int] IDENTITY(1,1) NOT NULL,
	[CountryName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)