SQL SERVER list of databases

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL SERVER list of databases

Message

From

13/03/2003 17:21:01

13/03/2003 16:16:45

Mike Yearwood
Toronto, Ontario, Canada

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Miscellaneous

Thread ID:

00765398

Message ID:

00765613

Views:

You're welcome.

>Hi Sergey
>
>Thanks!
>
>>>Hi All
>>>
>>>Does anyone have a way to get a list of databases from SQL Server?
>>>
>>>Thanks
>>
>>

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA
>>-- or
>>sp_helpdb

--sb--