determining if an SQL database exists, etc.

BobLewiston · 04-12-2009, 05:39 PM

Could someone please give me the simplest possible C# code snippets / SQL queries to determine whether:

* a given SQL database exists,
* a given existing SQL database is accessible, and
* a given table exists within a given existing SQL database?

Thanks for whatever help anyone can provide.

office politics · 04-12-2009, 06:46 PM

list of databases and tables should be in the system tables

Connect to SQL Server from command prompt - list tables and database

BobLewiston · 04-12-2009, 06:55 PM

office politics:

I want to be able to do this programatically.

kmote · 04-12-2009, 07:15 PM

Best thing to do is attempt a connect and check the return.

Member Login