How to get all database names with MS SQL & MySQL ? | NinethSense

How to get all database names with MS SQL & MySQL ?

Filed in SQL on Dec.28, 2005

with Microsoft SQL Server we can list all the database names with System Procedures
sp_databases
or
EXEC sp_helpdb

And in MySQL, its much more simple :
show databases;

Rating: 5.0/5 (1 vote cast)

Share:

Related posts:

Leave a Reply

You must be logged in to post a comment.

Categories
- Architecture
- Articles
- ASP.NET
- C#
- Code Snippets
- DOTNET
- Flex
- General
- Java
- Managed C++
- News
- OpenSource
- Patterns
- PHP
- Project Management
- SharePoint
- SQL
- VB.NET
- VSTO
- Web Design
- WPF-WCF-WF
Pages
I am an expert!
I contribute here!

These are the places in internet I usually use for technical as well as moral knowledge sharing:

DiGiTaLmAnIc
Latest
Blogroll
March 2010

M T W T F S S

« Feb

1 2 3 4 5 6 7

8 9 10 11 12 13 14

15 16 17 18 19 20 21

22 23 24 25 26 27 28

29 30 31
Old Posts
- March 2010 (4)
- February 2010 (13)
- January 2010 (6)
- December 2009 (13)
- November 2009 (5)
- October 2009 (13)
- September 2009 (17)
- August 2009 (13)
- July 2009 (28)
- June 2009 (20)
- May 2009 (21)
- April 2009 (22)
- March 2009 (22)
- February 2009 (18)
- January 2009 (14)
- December 2008 (15)
- November 2008 (3)
- October 2008 (25)
- September 2008 (3)
- August 2008 (11)
- July 2008 (11)
- June 2008 (8)
- May 2008 (10)
- April 2008 (10)
- March 2008 (9)
- February 2008 (9)
- January 2008 (21)
- December 2007 (6)
- November 2007 (14)
- October 2007 (9)
- September 2007 (6)
- August 2007 (7)
- July 2007 (7)
- June 2007 (12)
- May 2007 (19)
- April 2007 (10)
- March 2007 (3)
- February 2007 (3)
- January 2007 (1)
- December 2006 (3)
- November 2006 (4)
- October 2006 (9)
- September 2006 (3)
- August 2006 (2)
- July 2006 (10)
- June 2006 (4)
- May 2006 (4)
- March 2006 (5)
- February 2006 (4)
- January 2006 (10)
- December 2005 (5)
My Tweets
- @anuraj D unfortunate :( 2010/03/12
- Looking a way back to 100% technology thoughts. Wakeup! wakeup! (myself ;-)) 2010/03/12
- ...Looking around for new freelance projects... 2010/03/12
- @amazedsaint Dude, did you get my mail? 2010/03/09
- Sh*t! Why the hell I am pressing Ctrl+Shift+B for saving the document in Microsoft Word???? 2010/03/07
Subscribe

Enter your email address:
Tags

MCPD InfoPath SQL visual studio 2008 MVC Microsoft Toolkit Training Kit Windows7 SharePoint ESB Silverlight MVVM ViewModel Framework 4 Architecture Command MCTS Velocity Binding Codename IIS WPF ASP.NET visual studio WSS Strip comments SharePoint 2010 Shortcuts LINQ TFS ebook SEO CTD visual studio 2010
TopPosts