How to select database from a particuler server (mssql server 2005)

By hdeepak ·

I want to make a button which browse the all database in a particuler server. How can I do this.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Which DBMS ?

by Tony Hopkinson In reply to How to select database fr ...

MS SQL they are in the system table sysdatabases, there will be an sp_help... as well.
MySQL it's show databases

Once you've got the drop them in a list or combo box. Presumably the user doing the showing has the relevant permissions.

Collapse -

List of databases

by p.j.hutchison In reply to How to select database fr ...

To get a list of databases use:

use master
select name from sysdatabases;

Then your web page can use the information to populate a drop down list populated by the database names using ASP, PHP or Perl to create the web page.

Related Discussions

Related Forums