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.

[mail2saion]

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

CHECK DB EXIST OR NOT:

if NOT exists(select 1 from master.dbo.sysdatabases where name =
'yourDB')
begin
print 'DB does not exists';
end

Database is accessible:

Begin
Declare @Exist Int;
Set @Exist = HAS_DBACCESS('yourDB') 
IF @Exist = 1 
Print 'Accessible';
Else
IF @Exist = 0 
Print 'Not Accessible';
Else
Print 'Invalid Database';
End

Table Exists/Not:

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TableName]') AND type in (N'U'))

Just replace TableName by your table name.

OBJECT_ID is more powerful. If you wanna know more then google it.

HAPPY PROGRAMMING....

[Ramy Mahrous]

SMO libraries for .net let you query any server programatically.
The hierarchy is:
Server->Databases->Tables, users, stored procedures, etc...
You can read more about SMO in MSDN
Overview SMO: http://msdn.microsoft.com/en-us/library/ms162557.aspx
Creating SMO Programs: http://msdn.microsoft.com/en-us/library/ms162202.aspx