How to check a table is created in db?

[zjut]

In c#, Microsoft sql 2000, the name of db is "tc",and i want to check the
table "csharp" is exist or not . if it isnot exist, create it.!
======================================
SqlCommand cmd = new SqlCommand();
connection.open();
sSQL = "...." // how to write it.
cmd.CommandText = sSQL;
cmd.ExceutNonQuery();
.....
other statement
=============================

[Benny Tordrup]

if not exists (select table_name from information_schema.tables where
table_name ='tc')
Create table tc (....)
"zjut" <zj**@discussions.microsoft.com> skrev i en meddelelse
news:C2**********************************@microsof t.com...

In c#, Microsoft sql 2000, the name of db is "tc",and i want to check the
table "csharp" is exist or not . if it isnot exist, create it.!
======================================
SqlCommand cmd = new SqlCommand();
connection.open();
sSQL = "...." // how to write it.
cmd.CommandText = sSQL;
cmd.ExceutNonQuery();
....
other statement
=============================

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

You can check if it does exist or not by querying sysobjects , those with
xtype = 'U' are tables

To create it you could send a CREATE table command.
Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation


"zjut" <zj**@discussions.microsoft.com> wrote in message
news:C2**********************************@microsof t.com...

In c#, Microsoft sql 2000, the name of db is "tc",and i want to check the
table "csharp" is exist or not . if it isnot exist, create it.!
======================================
SqlCommand cmd = new SqlCommand();
connection.open();
sSQL = "...." // how to write it.
cmd.CommandText = sSQL;
cmd.ExceutNonQuery();
....
other statement
=============================