The Database Explorer facilitates the viewing of database objects within the database server. It saves you from having to use specific SQL commands to access information from the data dictionary, making it an easy job to obtain the most up-to-date database information, simply by point and click.
The Database Explorer window is divided into two sections:
Displays a tree diagram of the database objects.
Displays relevant information of the selected database object.
Your user privileges within the database server are reflected in Database Explorer. If you do not have access to a database, the database icon will be dimmed and no sub-items will be available.
When you expand the first component of the tree you will notice that the database icon is either gray or green, to indicate which databases you have access to.
Access to the system catalog table, syscomments, is needed to view SQL text for procedures, triggers, views, default and rules objects. If you do not have access to the syscomments system table, a message "SQL Text unavailable" will be presented in the Text tab.
Note: For Adaptive Server, you are able to access the syscomments system catalog table by turning the "select on syscomments.text" parameter on, use the command:
sp_configure "select on syscomments.text", 1