determining if an SQL database exists, etc.

[BobLewiston]

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]

list of databases and tables should be in the system tables

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

 

[BobLewiston]

office politics:

I want to be able to do this programatically.

 

[kmote]

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