Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Query for selecting all datase?

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

How can i display all data base of our database?Please write the query?
10:56 am on Oct 25, 2012 (gmt 0)
7:57 am on Dec 29, 2012 (gmt 0)

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