Table Tab

The following buttons are available from the Table view of the Catalog Browser.

Create
*
The Create button displays the Create Table dialog box, allowing you to specify parameters for a new table in the current location.
Alter
*
The Alter button displays the Alter Table dialog box to let you change the currently selected table.
Drop
*
The Drop button displays the Drop Table dialog box for the currently selected table.
Open
*
The Open button displays the contents (data) of the selected table in a Result window. Clicking Open is the same as executing the SQL command: SELECT * FROM tablename FOR FETCH ONLY
Refresh
*
The Refresh button queries the system catalog to find out current details for all tables and related objects. Click this button after you or someone else has made changes to objects, such as inserting, altering, or dropping locations, tables, indexes, queries, etc.
Filter
*
The Filter button enables you to specify filters to control the databases, AuthIDs and table items that are displayed in the Catalog Browser for any particular location.
Detail
*
The Detail checkbox indicates whether comments on the tables, columns, or other objects should be shown to the right of the object name. If checked, comments are displayed. At the column level, the column definition, including data type, is also displayed. You may have to increase the width of the Catalog Browser to see all of the information for each object.