Oct 30, 2003 #1 skiflyer Programmer Joined Sep 24, 2002 Messages 2,213 Location US What's the SQL command to list all the databases when connected to a server? If it's database specific... could you tell me for MySQL and MSDE? Thanks, Rob
What's the SQL command to list all the databases when connected to a server? If it's database specific... could you tell me for MySQL and MSDE? Thanks, Rob
Oct 30, 2003 Thread starter #2 skiflyer Programmer Joined Sep 24, 2002 Messages 2,213 Location US And with my own answer... (sorry) SHOW DATABASES; For MySQL anyway... doesn't appear to work for MSDE... but I'm just passing info to the MSDE guy, not running it myself. -Rob Upvote 0 Downvote
And with my own answer... (sorry) SHOW DATABASES; For MySQL anyway... doesn't appear to work for MSDE... but I'm just passing info to the MSDE guy, not running it myself. -Rob
Oct 30, 2003 Thread starter #3 skiflyer Programmer Joined Sep 24, 2002 Messages 2,213 Location US sp_helpdb to answer the MSDE portion... sorry for the all posts. -Rob Upvote 0 Downvote