Query for selecting all datase? - Databases forum at WebmasterWorld - WebmasterWorld

Forum Moderators: open

Message Too Old, No Replies

Query for selecting all datase?

andrewneil

9:34 am on Oct 25, 2012 (gmt 0)

How can i display all data base of our database?Please write the query?

phranque

10:56 am on Oct 25, 2012 (gmt 0)

WebmasterWorld Administrator

10+ Year Member

Top Contributors Of The Month

SHOW DATABASES:
http://dev.mysql.com/doc/refman/5.5/en/show-databases.html [dev.mysql.com]

pavanraj

7:57 am on Dec 29, 2012 (gmt 0)

10+ Year Member

list databases in db2 will show up databases.Then the query is
EXEC sp_databases
SELECT name
FROM sys.databases
Try it.......