How to determine if database and table exists using ADO.NET

[sampalmer21]

Is there a way I can find out if a database I have created exists in the sql server using ado.net methods? How about determining if a table exists, or any other database object for that matter?

The reason I wish to know this is so that my application can recreate the database or tables if they get deleted by the user.

[saran23]

Is there a way I can find out if a database I have created exists in the sql server using ado.net methods? How about determining if a table exists, or any other database object for that matter?

The reason I wish to know this is so that my application can recreate the database or tables if they get deleted by the user.

Hi,
use this Query in the sqlcommand and check whether the table exists or not,
U can use a SP or a direct query in Sqlcommand,
The query returns a boolean value,

Here goes the query

if exists (select * from sysobjects where xtype='u' and name='tablename')

Here u denotes user table

Thanks
Saravanan