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.

[vecs]

List all accessible databases on server:

EXEC master..sp_databases

List all system tables, tables, views in current database:

EXEC sp_tables

List all tables with given name in specific database:

USE database_name
EXEC sp_tables @table_name = '_user'

[ck9663]

There are system tables that you can use to check if it's existing master.sysdatabases; sysobjects - for the tables...to check if it's accessible, let your front-end connection handle it. Establish your connection and just throw an error. "Accessible" is a relative. It might be there but depending on the user account, it might not be "accessible"


--- CK