Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SERVER list of databases
Message
From
13/03/2003 13:25:04
Sergey Berezniker
New York, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL SERVER list of databases
Miscellaneous
Thread ID:
00765398
Message ID:
00765490
Views:
25
>>>Does anyone have a way to get a list of databases from SQL Server?
>>
>>
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA
>>-- or
>>sp_helpdb
>
>-- or
>
>SQLTABLES(lnConnectionHandle)

It returns the list of tables not databases.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform