determining if an SQL database exists, etc.

[thedougster]

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.

 

[hmckillop]

Not sure if this is what you were looking for, but here goes (untested!)

1 -

IF db_id('AdventureWorks') IS NOT NULL
Print 'Database Exists'
ELSE
Print 'Database Does Not Exists'

2 - unsure what you mean - but will assume has the current user acces rights

SELECT [Name] as DatabaseName from master.dbo.sysdatabases
WHERE ISNULL(HAS_DBACCESS ([Name]),0)=1
ORDER BY [Name]

3 -

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

"I'm living so far beyond my income that we may almost be said to be living apart

 

[thedougster]

hmckillop:

Please pardon what I'm sure is a stupid question, but I'm a newbie stumbling around in the dark:

Are these SQL queries or VB snippets? If it's VB, do you know where I can find this in C#?

 

[bborissov]

No, these are pure T-SQL queries.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[hmckillop]

Hello "the dougster"

There is no C# "equivalent" of these. you can execute them from c# which will involve opening a database connection to your server.

If you need to do something like that then plenty of examples on the net.

try this one for starters

http://www.codeproject.com/KB/database/sql_in_csharp.aspx

Its a fairly comprehensive beginners guide.



"I'm living so far beyond my income that we may almost be said to be living apart