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

Expand Post »

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!

Similar Threads

Python-mysql for checking table exist or not in Python

Ratte

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

38 posts
since Oct 2007

Permalink

Mar 27th, 2008

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

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

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
)

Then in c# run an Execute non query. Place that into a try catch

JerryShaw

Reputation Points: 69

Solved Threads: 75

Posting Pro in Training

Offline

465 posts
since Nov 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: identify current user asp.net c# project

Next Thread in C# Forum Timeline: AppDomain.CurrentDomain.CreateInstanceFromAndUnwrap()

DaniWeb Message

Cancel Changes

User Name
Password