Welcome to WebmasterWorld Guest from 184.72.177.182

Forum Moderators: open

Message Too Old, No Replies

Query for selecting all datase?

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

New User

joined:Oct 20, 2012
posts:7
votes: 0


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

Administrator

WebmasterWorld Administrator phranque is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Aug 10, 2004
posts:10544
votes: 8

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

New User

joined:Dec 29, 2012
posts:4
votes: 0


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