How to determinate if a database exist?

[ad]

How can I determinate if a database exist in my SqlServer?

 

[Sahil Malik [MVP C#]]

select * from sys.all_objects where name = 'YourTableName' and type='U'


--

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________

 

[Sericinus hunter]

How can I determinate if a database exist in my SqlServer?

if exists select 1 from information_schema.schemata where catalog_name = 'your_db_name'
select 1
else
select 0

 

[Andy L]

For ADO.NET 2.0, SqlConnection (and all provider specific connection
classes) has a GetSchema method.
Before 2.0, only OleDbConnection provided Schema information.

'eg for ADO.NET 2.0
Using sc As New SqlConnection("Server=. ;Integrated Security=SSPI")
sc1.Open()
Dim dt As DataTable = sc1.GetSchema("databases")

For Each dr As DataRow In dt.Rows
For Each dc As DataColumn in dt.Columns
Console.WriteLine(dc.ColumnName & ":" & dr(dc))
Next
Next
End Using