Table Designer GUI Visual Reference

---

This section describes the objects on the Table Designer graphical user interface (GUI).

• Main Window
• Columns Tab
• Indexes Tab
• Statistics Tab
• Btrieve Tab

Main Window

The following image shows the main window of the GUI. (The image shows all icons that may appear on the window; not all icons appear for each tabbed work area.) The table below the image describes the GUI objects. Click on an area of the image for which you want more information.

 
Figure 5-3 Table Designer Main Window

GUI Object	Description	Related Information
Title Bar	Shows the following information: name of the utility name of the computer on which the database resides (if Table Designer started from PCC) name of the open database name of the open table (For example, in Figure 5-3, table Billing in database DEMODATA on machine DOCLAB2)	(Main Window image)
File menu	Provides the following commands: Save Reset Exit	(Main Window image)
Save command or icon	Saves the Table Designer information to catalog files.	To save changes (Main Window image)
Reset	Restores the information from the last saved state. All changes that have not been saved are discarded.	To discard all changes (Reset) (Main Window image)
Open Table	Opens a table. This command appears only if Table Designer is running as a stand-alone application.	"To start Table Designer as a stand-alone application" on page 5-30 "To open a table" on page 5-35 (Main Window image)
Open Database	Opens a database. This command appears only if Table Designer is running as a stand-alone application.	"To start Table Designer as a stand-alone application" on page 5-30 "To open a database" on page 5-33 (Main Window image)
Create Table	Creates a new table in your database and opens that table for you. This command appears only if Table Designer is running as a stand-alone application.	"To start Table Designer as a stand-alone application" on page 5-30 "To create a table" on page 5-36 (Main Window image)
Create Database	Creates a new database, which then becomes the one open in Table Designer. This command appears only if Table Designer is running as a stand-alone application.	"To start Table Designer as a stand-alone application" on page 5-30 "To create a database" on page 5-34 (Main Window image)
Delete Table	Deletes a table from physical storage. This command appears only if Table Designer is running as a stand-alone application.	"To start Table Designer as a stand-alone application" on page 5-30 "To delete a table" on page 5-36 (Main Window image)
Delete Database	Deletes a database from physical storage. This command appears only if Table Designer is running as a stand-alone application.	"To start Table Designer as a stand-alone application" on page 5-30 "To delete a database" on page 5-35 (Main Window image)
Exit	Terminates the execution of Table Designer. Prompts the user to save any changed information that has not been saved.	(Main Window image)
Edit menu	Provides the following commands: Insert Column Delete Column Move Up Move Down Insert Index Delete Index Insert Segment Delete Segment Reset Copy Paste	(Main Window image)
Insert Column command or icon	Inserts a column above the cursor location. This command and icon appear only on the Columns tab and Btrieve tab. This command and icon are disabled on the Columns tab when Table Designer is in unlinked mode.	Modes To change Table Designer mode To insert a column at end of column definitions To insert a column between columns (Main Window image)
Delete Column command or icon	Deletes the column currently selected. This command and icon appear only on the Columns tab and Btrieve tab. This command and icon are disabled on the Columns tab when Table Designer is in unlinked mode.	Modes To change Table Designer mode To delete a column (Main Window image)
Move Up command or icon	Moves the selected column up. Note that changing column position on the Columns tab affects the physical database. This command and icon are enabled only on the Columns tab and Btrieve tab. This command and icon are disabled on the Columns tab when Table Designer is in unlinked mode.	Modes To change Table Designer mode To change column order (Main Window image)
Move Down command or icon	Moves the selected column down. Note that changing column position on the Columns tab affects the physical database. This command and icon enabled only on the Columns tab and Btrieve tab. This command and icon are disabled on the Columns tab when Table Designer is in unlinked mode.	Modes To change Table Designer mode To change column order (Main Window image)
Insert Index command or icon	Inserts an index at the cursor location. This command and icon appear only on the Indexes tab.	To insert an index (Main Window image)
Delete Index command or icon	Deletes the index currently selected. This command and icon appear only on the Indexes tab.	To delete an index (Main Window image)
Insert Segment command or icon	Inserts a segment for the currently selected index. This command and icon appear only on the Indexes tab.	To insert an index segment (Main Window image)
Delete Segment command or icon	Deletes the index segment currently selected. This command and icon appear only on the Indexes tab.	To delete an index (Main Window image)
Reset	Restores the information from the last-saved state. All changes that have not been saved are discarded.	To discard all changes (Reset) (Main Window image)
Copy command or icon	Copies the information in a grid cell to the clipboard.	To copy data from a grid cell (Main Window image)
Paste command or icon	Pastes the clipboard data into the grid cell where the cursor is located.	To paste data into a grid cell (Main Window image)
View menu	Provides the following commands: Columns Indexes Table Statistics Btrieve Data Reset	(Main Window image)
Columns	Displays the Columns tab.	Columns Tab To work with columns (Main Window image)
Indexes	Displays the Indexes tab.	Indexes Tab To work with indexes (Main Window image)
Table Statistics	Displays the Statistics tab.	Statistics Tab To display table statistics (Main Window image)
Btrieve Data	Displays the Btrieve tab. This command is enabled only if Table Designer is in unlinked mode.	Btrieve Tab To change Table Designer mode To work with Btrieve data (Main Window image)
Reset command or icon	Restores the information from the last-saved state. All changes that have not been saved are discarded.	To discard all changes (Reset) (Main Window image)
Tools menu	Provides the following commands: View Data Options	(Main Window image)
View Data command or icon	Views the data in the table. This icon starts the SQL Data Manager utility.	To view table data (Main Window image)
Options	Changes Table Designer mode.	Modes To change Table Designer mode (Main Window image)
Help menu	Provides the following commands: How Do I? Topics Search Documentation What's This? Glossary Online Manuals (Web) Knowledge Base (Web) Developer Center (Web) About	(Main Window image)
How Do I?	Lists the tasks that you can perform with Table Designer.	To display help (Main Window image)
Topics	Lists the documentation topics for Table Designer.	Table Designer Tasks To display help (Main Window image)
Search Documentation	Searches for a string throughout the installed set of Pervasive.SQL documentation.	To display help (Main Window image)
What's This?	Identifies objects in the Table Designer GUI.	Table Designer GUI Visual Reference To display help (Main Window image)
Glossary	Defines terms used in the Pervasive.SQL documentation and products.	To display help (Main Window image)
Online Manuals (Web)	Directs your browser to www.pervasive.com where you can reference the online manuals.	To display help (Main Window image)
Knowledge Base (Web)	Directs your browser to www.pervasive.com where you can query the Pervasive.SQL Knowledge Base for additional information about Pervasive.SQL.	To display help (Main Window image)
Developer Center (Web)	Directs your browser to www.pervasive.com where you can research information specifically for application developers using Pervasive.SQL.	To display help (Main Window image)
About	Displays the name and version of Table Designer and the Pervasive.SQL copyright information.	To display help (Main Window image)
Columns tab	Displays the Columns tab. This tab is read-only if Table Designer is in unlinked mode.	Modes Columns Tab To work with columns (Main Window image)
Indexes tab	Displays the Indexes tab.	Modes Indexes Tab To work with indexes (Main Window image)
Statistics tab	Displays the Statistics tab.	Modes Statistics Tab To display table statistics (Main Window image)
Btrieve tab	Displays the Btrieve tab. This tab appears only if Table Designer is in unlinked mode.	Modes Btrieve Tab To change Table Designer mode To work with Btrieve data (Main Window image)
Record length indicator	Shows the number of byes in the current record.	To determine the length of a record (Main Window image)
Mode indicator	Shows the current mode of Table Designer (linked or unlinked). The mode determines which of the four tabbed dialogs appears.	Modes To change Table Designer mode (Main Window image)

Columns Tab

The following image shows the Columns tab of the GUI. The table below the image describes the GUI objects. Click on an area of the image for which you want more information. (The menu items and icons are explained in Main Window .)

 
Figure 5-4 Columns Tab

GUI Object	Description	Related Information
Column Name	Specifies the alpha-numeric name for the column. The limit is 20 characters.	To set a column name
Type	Specifies the data type of the column.	Pervasive.SQL Supported Data Types in SQL Engine Reference. To set a column data type (Columns Tab image)
Size	Specifies how many bytes are permitted for the data type.	To set a column size (Columns Tab image)
Precision	Specifies the number of significant digits for floating point values.	To set column precision (Columns Tab image)
Scale	Specifies the number of significant digits that are to the right of the decimal point for floating point values.	To set a column scale (Columns Tab 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 Tab 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 Tab 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 Tab 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 Tab image)

Indexes Tab

The following image shows the Indexes tab of the GUI. The table below the image describes the GUI objects. Click on an area of the image for which you want more information. (The menu items and icons are explained in Main Window .)

 
Figure 5-5 Indexes Tab

GUI Object	Description	Related Information
Index Name	Specifies the name of the index.	To insert an index (Indexes Tab image)
Column	Specifies the column used to create the index for sorting.	To specify index sort column (Indexes Tab image)
Duplicate	Specifies that the index can have duplicate values.	To allow duplicates in index (Indexes Tab image)
Modifiable	Specifies that the key value can be modified after creation. Allowing modification of key values does not affect performance. Key pages are only updated if the actual key value changes, not if non-key fields in a particular record are changed.	To specify index as modifiable (Indexes Tab image)
Sort	Specifies the type of sorting to use for the key (ascending or descending).	To specify index sort sequence (Indexes Tab image)

Statistics Tab

The following image shows the Statistics tab of the GUI. The table below the image describes the GUI objects.Click on an area of the image for which you want more information. (The menu items and icons are explained in Main Window .)

 
Figure 5-6 Statistics Tab

GUI Object	Description	Related Information
Parameter	Labels the statistical information shown on the tabbed area. See the next 18 rows in this table for the labels.	To display table information (Statistics Tab image)
Table Name	Shows the name of the table as it appears in the database definition.	Naming Conventions in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Table Location	Shows the physical location of the data file associated with the table. You may edit this parameter to change the location of a table's data file.	To change the location of a table's data file (Statistics Tab image)
Dictionary Path	Shows where the database's DDF files are located.	(Statistics Tab image)
File Version	Shows the earliest Btrieve engine version that can read the file format.	(Statistics Tab image)
Record Length	Shows the length of the data file's records.	Record Length in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Page Size	Shows the page size (in bytes) of the data file. The page size determines the maximum number of index segments that can be defined in a table.	Choosing a Page Size in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Number or Records	Shows the number of records currently contained in the data file.	(Statistics Tab image)
Number of Indexes	Shows the number of indexes defined for the table.	Creating Indexes in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Number of Duplicate Pointers (Ptrs)	Shows the number of linked duplicate indexes that can be added.	File Attributes in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Number of Unused Pages	Shows the number of pre-allocated pages available. If pre-allocation is enabled, the MicroKernel pre-allocates a specified number of pages when it creates the data file. Pre-allocation guarantees that disk space for the data file is available when the MicroKernel needs it.	(Statistics Tab image)
Variable Records	Shows whether the data file contains variable-length records.	Record Length in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Variable Record Blank Truncation	Shows whether blank truncation is enabled. If it is, the MicroKernel truncates the blanks in variable-length records. Blank truncation is applicable only if the Variable Records statistic is Yes and Data Compression is set to No.	Blank Truncation in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Data Compression	Shows whether data compression is enabled. If it is, the MicroKernel compresses each record it inserts into the data file.	Data Compression in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Key Only File	Shows the name of the key-only file for the table, if any. A key-only file contains no data records but serves as an index to other Btrieve files.	Key-Only Files in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Index Balancing	Shows whether balanced indexing is enabled.	Index Balancing in Pervasive.SQL Programmer's Guide (Statistics Tab image)
FreesSpace Threshold	Shows a percentage (5%, 10%, 20% or 30%) if the data file has a free space threshold. The MicroKernel stores the variable-length portions of records on their own pages (called variable pages), separate from the fixed-length portions (which are stored on data pages). The MicroKernel uses the threshold to determine whether to add data to an existing variable page or to create a new one. A higher free space threshold reduces fragmentation of variable-length records across several pages but uses more disk space.	File Attributes in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Uses Alternate Collating Sequence	Shows whether the table uses an alternate collating sequence for sorting.	Alternate Collating Sequences in Pervasive.SQL Programmer's Guide (Statistics Tab image)
System Data Key	Shows whether the data file has system data keys enabled.	System Data in Pervasive.SQL Programmer's Guide (Statistics Tab image)
Value	Shows the value for each parameter.	To display table information (Statistics Tab image)

Btrieve Tab

The following image shows the Btrieve tab of the GUI. The table below the image describes the GUI objects. Click on an area of the image for which you want more information. (The menu items and icons are explained in Main Window .)

Note that this tab appears only when Table Designer is in unlinked mode.

 
Figure 5-7 Btrieve Tab

GUI Object	Description	Related Information
Column Name	Specifies the alpha-numeric name for the column. The limit is 20 characters.	To set a Btrieve column name (Btrieve Tab image)
Type	Specifies the data type of the column.	Pervasive.SQL Supported Data Types in SQL Engine Reference. To set a Btrieve column type (Btrieve Tab image)
Size	Specifies how many bytes are permitted for the data type.	To set a Btrieve column size (Btrieve Tab image)
Position	Shows the byte location within the physical file where the column begins.Position is automatically determined by the location of the column and the size of the data type(s) in the preceding column(s).	(Btrieve Tab image)
Decimal	Specifies the number of significant digits that are to the right of the decimal point for floating point values.	To set decimal places for a Btrieve column (Btrieve Tab 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 Btrieve column to allow nulls (Btrieve Tab 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 Btrieve column (Btrieve Tab image)