Bay Breeze Software, Inc.

Schema perspective

Schema perspective allows users to browse the database schema information, and also provides a set of wizards to create tables, views, synonyms and sequences. You can use the “Schema Perspective” toolbar button or the “Window” menu to switch to the perspective.

The following shows the perspective:

In the “Database Explorer”, click any table, view or synonym representing a table or a view will display its schema information. The top grid shows the column information. The bottom two grids display the indexes (including primary keys) and foreign keys on a table.

 

1. Script view

For Oracle, DB2, Microsoft SQL Server, Sybase, MySQL and PostgreSQL databases, script information will also be displayed for views, synonyms, sequences, stored procedures, triggers and packages based on whether the database supports these objects. The following shows the script view for an Oracle package body:

The script view also displays any compilation errors as error markers:

 

2. Create table wizard

Create table wizard allows users to create a table. You can invoke the wizard by right click on the “Tables” node in the database explorer, and choose the “Create Table” menu option.

The following displays the “Create Table” wizard.

Please enter the table name in this page, and then click the “Next” button to go to “Enter column information” page.

Please enter the column information, such as column name, column type and column size, and then click the “Next” button to go to the “Enter primary key and indexes” page.

Please enter the name of the primary key and indexes, and use the lookup button to choose the primary key and index columns.

After done, click the “Next” button to go to the “Enter foreign keys” page.

Please enter the foreign key name, its primary table and use the lookup button to choose the related columns.

After done, click the “Finish” button to create the table. The database explorer will be refreshed to display the newly created table.

 

3. Create view wizard

Create view wizard allows users to create a view. You can invoke the wizard by right click on the “Views” node in the database explorer, and choose the “Create View” menu option. The following shows the “Create View” wizard.

Please enter the view name in this page, and then click the “Next” button to go to the “Select database objects” page.

Please select the tables, views and synonyms that the view is based on, then click the “Next” button to go to the “Select columns” page.

Please select the view columns, and then click the “Next” button to go to the “Execute script” page.

The join conditions of the view script are created based on the table relationships. Please modify the script as needed, and then click the “Finish” button to execute the script. The database explorer will be refreshed to display the newly created view.

 

4. Create synonym wizard

Create synonym wizard allows users to create a synonym. You can invoke the wizard by right click on the “Synonyms” node in the database explorer, and choose the “Create Synonym” menu option. The following shows the “Create Synonym” wizard.

Please enter the synonym name in this page, and then click the “Next” button to go to “Select database object” page.

Please select the database object for which the synonym is created, and then click the “Finish” button to create the synonym. The database explorer will be refreshed to display the newly created synonym.

 

5. Create sequence wizard

Create sequence wizard allows users to create a sequence. You can invoke the wizard by right click on the “Sequences” node in the database explorer, and choose the “Create Sequence” menu option. The following shows the “Create Sequence” wizard.

Please enter the sequence name in this page, and then click the “Next” button to go to the “Enter sequence properties” page.

Please enter the sequence properties, such as its start value, increment by value, minimum and maximum value, etc. Then, click the “Finish” button to create the sequence. The database explorer will be refreshed to display the newly created sequence.