Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SERVER list of databases
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00765398
Message ID:
00765498
Views:
19
>>>>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.

<*whack*> 2.6-itis strikes again. Thanks, Sergey.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Reply
Map
View

Click here to load this message in the networking platform