Figure 1 - Databrid showing the Browser Tab for Oracle
The Browser tab allows the you to browse various parts of the database schema.
For Oracle the browsing is done via a particular schema user and displays information on tables, views, sequences etc. Features include the generation of database creation statements for tables, views etc, browsing table or view data, truncating tables, etc.
|
Figure 1 - Databrid showing the Browser Tab for Oracle |
On the left hand side of the browser is where the lists object database objects are shown. What objects are shown is determined by the Schema User, displayed top right hand side. Figure 1 is showing database objects for the user SCOTT. By clicking on the button to the right of the user a list of all available users will be displayed. If a different user is selected from this list then only the database objects for this user will be displayed.
For MySql the browsing is done via a particular database and displays information on tables, views, procedures and local temporary names. Features include browsing table or view data, truncating tables, etc.
 |
Figure 2 - Databrid showing the Browser Tab for MySql |
On the left hand side of the browser in figure 2 is where the lists object database objects are shown. What objects are shown is determined by the Database, displayed top right hand side. Figure 2 is showing database objects for the database mysql. By clicking on the button to the right of the user a list of all available databases will be displayed. If a different user is selected from this list then only the database objects for this database will be displayed.
Beside the schema user(Oracle)/database(MySql) are two buttons. The button on the left refreshes all of the database object views and the details views shown below the button. The button on the right just refreshes the details of the database object (shown below the button), not the database object view itself.
The lists of database objects that can be displayed is explained below along with what details can be displayed for each of these objects.
This tab shows information on links between databases.
|
Button |
Description |
|
Drop Database Link |
Drops the Database Link |
|
Tab |
Description |
|
Details |
Information about the Database Link (ie creation date etc). |
|
Grants |
Which user and roles have grants for this Database Link. |
This tab shows table indexes.
|
Button |
Description |
|
Drop Index |
Drops the Index |
|
Tab |
Description |
|
Columns |
The table columns that are part of the Index. |
|
Details |
Information about the Index (i.e. creation date, status, etc.). |
|
Grants |
Which user and roles have grants for this Index. |
This tab shows all procedures, functions and packages.
|
Button |
Description |
|
Compile |
Compiles the selected Function/Package/Procedure. |
|
Copy Script to Clipboard |
Copies the creation script to the clipboard. |
|
Save Script to file |
Copies the creation script to a file. |
|
Compile All Objects |
Compiles all invalid objects (i.e. Procedures, Views, etc.). |
|
Tab |
Description |
|
Arguments |
For Functions and Procedures this shows the Procedure/Function name. Clicking on the name will show the arguments for this Procedure/Function. For Packages this lists all of the Function and Procedure names belonging to this Package. Clicking on a name will then show the argument for all Procedures and Functions with that name. |
|
Details |
Information about the Procedure/Function/Package (i.e. creation date, status, etc.). |
|
Code |
Shows the Procedure/Function/Package code. Packages are shown in two tabs, one for the header and the other for the Package body. |
|
Grants |
Which user and roles have grants for this Procedure/Function/Package. |
This tab show all sequences.
|
Button |
Description |
|
Drop Sequence |
Drops the Sequence |
|
Copy Script to Clipboard |
Copies the Sequence creation script to the clipboard. |
|
Save Script to file |
Copies the Sequence creation script to a file. |
|
Tab |
Description |
|
Details |
Information about Sequence (i.e. creation date, status, etc.). |
|
Grants |
Lists the users and roles that have grants for this Sequence. |
|
Script |
Shows the Sequence creation statement. |
This tab shows Synonyms.
|
Button |
Description |
|
Drop Synonym |
Drops the Synonym |
|
Copy Script to Clipboard |
Copies the Synonym creation script to the clipboard. |
|
Save Script to file |
Copies the Synonym creation script to a file. |
|
Tab |
Description |
|
Details |
Information about Synonym (i.e. creation date, etc.). |
|
Grants |
Lists the users and roles that have grants for this Synonym. |
|
Script |
Shows the Synonym creation statement. |
This tab shows details on all tables.
|
Button |
Description |
|
Drop Table |
Drops the Table. |
|
Copy Script to Clipboard |
Copies the table creation Script to the clipboard. |
|
Save Script to file |
Copies the table creation Script to a file. |
|
Truncate Table |
Truncates (deletes records and is not reversible) the contents of the Table. |
|
Tab |
Description |
|
Columns |
A description of each column in the Table. |
|
Indexes |
Details about all indexes on the Table. |
|
Constraints |
Details about all constraints on this Table. |
|
Details |
Information about Table (i.e. creation date, etc.). |
|
Data |
The actual data from the Table. This tab contains a filter buttons that can be used to create a where clause that reduces the amount of data shown. |
|
Grants |
Lists the users and roles that have grants for this Table. |
|
Script |
Shows the table creation statements. |
This tab shows information on Database Triggers.
|
Button |
Description |
|
Drop Trigger |
Drops the Trigger |
|
Copy Script to Clipboard |
Copies the Trigger creation script to the clipboard. |
|
Save Script to file |
Copies the Trigger creation script to a file. |
|
Compile |
Compiles the selected Trigger. |
|
Compile All Objects |
Compiles all invalid database objects (Procedures, Views, Triggers, etc.). |
|
Tab |
Description |
|
Columns |
The columns used by the Trigger. |
|
Details |
Information about Trigger (i.e. creation date, etc.). |
|
Grants |
Lists the users and roles that have grants for this Table. |
|
Code |
Shows the code for the Trigger. |
This tab lists types.
|
Button |
Description |
|
Drop Type |
Drops the Type |
|
Copy Script to Clipboard |
Copies the Type creation script to the clipboard. |
|
Save Script to file |
Copies the Type creation script to a file. |
|
Tab |
Description |
|
Script |
Shows the Type creation statements. |
This tab shows information on Views.
|
Button |
Description |
|
Drop View |
Drops the View. |
|
Copy Script to Clipboard |
Copies the View creation script to the clipboard. |
|
Save Script to file |
Copies the View creation script to a file. |
|
Compile |
Compiles the selected View. |
|
Compile All Objects |
Compiles all invalid database objects (Procedures, Views, Triggers, etc.). |
|
Tab |
Description |
|
Columns |
A Description of each column in the View |
|
Details |
Information about View (i.e. creation date, etc.). |
|
Data |
The actual data the View shows. |
|
Code |
The View Code. |
|
Grants |
Lists the users and roles that have grants for this View. |
|
Script |
Shows the View creation statements. |
This tab shows all Local Temporary Names. There is no buttons or detail information for this tab.
This tab shows all procedures and functions.
|
Tab |
Description |
|
Arguments |
The view shows the Procedure or Functions arguments. |
This tab shows details on all tables.
|
Button |
Description |
|
Drop Table |
Drops the Table. |
|
Truncate Table |
Truncates (deletes records and is not reversible) the contents of the Table. |
|
Tab |
Description |
|
Columns |
A description of each column in the Table. |
|
Primary Key |
This lists the columns in the primary key. |
|
Indexes |
Details about all indexes on the Table. |
|
Imported Keys |
Details about the foriegn keys on this table and the primary keys they are related to. |
|
Export Keys |
Details which foriegn key are linked to this tables primary keys. |
|
Data |
The actual data from the Table. This tab contains a filter buttons that can be used to create a where clause that reduces the amount of data shown. |
|
Table Privs |
Lists privileges assigned to this table. |
|
Column Privs |
Lists privileges assigned to the columns in this table. |
This tab shows information on Views.
|
Tab |
Description |
|
Columns |
A description of each column in the Table. |
|
Data |
The actual data from the Table. This tab contains a filter buttons that can be used to create a where clause that reduces the amount of data shown. |
|
Table Privs |
Lists privileges assigned to this table. |
|
Column Privs |
Lists privileges assigned to the columns in this table. |