Table Editor Graphical User Interface

Table Editor Graphical User Interface

The Table Editor graphical user interface (GUI) provides work areas (called pages) for the following:

•

•

•

Foreign Keys Page

•

The Columns page can be considered the primary page of Table Editor just as columns and rows are central to tables. The following image shows the Columns page of Table Editor. The table below the image describes the GUI objects. Click on an area of the image for which you want more information.

See also Columns Tasks for the tasks that you perform on the page.

Figure 24 Columns Page


GUI Object	Description	Related Information
Column Name	Specifies the alpha-numeric name for the column.	To specify a column name Relational Interface Limits in SQL Engine Reference Versions of Metadata in SQL Engine Reference Identifier Restrictions by Identifier Type in Advanced Operations Guide (Columns Page image)
Type	Specifies the data type of the column.	Pervasive PSQL Supported Data Types in SQL Engine Reference To set a column data type (Columns Page image)
Size	Specifies how many bytes are permitted for the data type. A shaded cell indicates that size does not apply.	To set a column size (Columns Page image)
Precision	Specifies the number of significant digits for floating point values. A shaded cell indicates that precision does not apply.	To set column precision (Columns Page image)
Scale	Specifies the number of significant digits that are to the right of the decimal point for floating point values. A shaded cell indicates that scale does not apply.	To set a column scale (Columns Page image)
Null	Specifies whether NULL values are allowed for the data type. A shaded square () indicates that nulls do not apply to the data type. A checked square () indicates that NULL values are allowed for the data type.	To set a column to allow or disallow nulls (Columns Page image)
Case	Specifies whether the database engine uses case-sensitive or case-insensitive comparisons when searching for character values in the database. A checked square () indicates that case-insensitive values are used. A shaded square () indicates that case sensitivity does not apply to the data type.	To set case sensitivity for a column (Columns Page image)
Collate	Specifies that an alternating collating sequence (ACS) is used for sorting. Contains the path and ACS file name.	To set a column collating sequence (Columns Page image)
Default	Specifies a default value for the column. The default value is used if you perform an SQL INSERT for a row but do not provide a value for the column.	To set a column default (Columns Page image)

The Indexes page allows you to add and delete indexes. The Indexes page is explained within the context of the tasks that you perform for indexes. See Indexes Tasks.

Foreign Keys Page

The Foreign Keys page allows you to add and delete foreign keys. The Foreign Keys page is explained within the context of the tasks that you perform for foreign keys. See Foreign Keys Tasks.

The SQL View page displays, and allows you to copy, the SQL statements used to create or alter the table. The CREATE TABLE panel displays the SQL with which you could create the same table. The ALTER TABLE panel reflects any editing changes to an existing table that you make with Table Editor. When you save the table changes, the ALTER TABLE panel is cleared and the ALTER statement(s) becomes part of the CREATE TABLE statement.

The SQL View page is further explained within the context of the tasks that you can perform. See SQL View Tasks.