Online Documentation for SQL Administrator for SQL Server

Database Explorer


Database Explorer is the navigation window for managing databases, database objects and database maintenance tasks. All objects are available within the database node of the tree. It allows viewing practically all database objects. A server appears in the Database Explorer after it is registered.

To launch the Server Explorer choose Tools | Database Explorer main menu item.

To expand/collapse a node, you can double-click it or use the +/- icons.

 

Database Explorer

 

 

The context menu of the Database in the Database Explorer allows you to:

  • disconnect from the server;

Create create database

Edit edit selected database(s)

Drop drop selected database(s)

  • rename selected database
  • perform the following tasks on the selected databases:

Backup_SQLAdmin backup database

Restore_SQLAdmin restore database

AttachDatabase attach database

DetachDatabase detach database

CheckDatabase check database

RebuildIndexes rebuild/reorganize indexes

ShrinkDatabase_SQLAdmin shrink database