By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,199 Members | 1,725 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,199 IT Pros & Developers. It's quick & easy.

Why i can't exceute the "show databases" query

P: 51
hi friend, can you tell me, why i can't execute the "show databases" query using vb?, i use a myProv
Dec 28 '06 #1
Share this Question
Share on Google+
2 Replies


sashi
Expert 100+
P: 1,754
hi friend, can you tell me, why i can't execute the "show databases" query using vb?, i use a myProv
Hi there,

I assume you are working on MySQL, i feel it's function. Unlike in MSSQL you can use stored procedures to list databases as well as tables. Kindly refer to below, hope it helps. Good luck & Take care.

sp_databases - list all databases
sp_tables - list all tables in a particular database (must issue the use <database_name> command prior to this stored procedure)
Dec 28 '06 #2

sashi
Expert 100+
P: 1,754
Hi there,

What myProv? I might be wrong, lets see what other experts have to say. Hang on till then. :) Good luck & Take care.
Dec 28 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.