Copyright: Copyright © 1999-2001 Pervasive Software Inc. All Rights Reserved


Select to delete both table definitions and files containing actual data. For example, the database definition and the actual data file.


Enter the new table name.


Access Combo
Select the owner access mode to apply to the newly created table.


Adds all the tables to the testing list.


Adds the table to the testing list.


HIDD_TBL_ADVANCED


Select this check box to specify the new file name to use, or to specify an existing data file. If you select an existing file, the auto detection tool will assist you in creating data definitions for your database, based on the Btrieve table.


Shows columns defined on the table.


Enter your password confirmation.


Select the table import definition.


Select to perform a consistency test.


Decompress Check
Select to compress data in the newly created table.


Indicates "DELETE" query type.


Disables security for the database. This requires the login to be set as 'Master'.


HIDD_DROP_TABLE


Enter the Data Source Name.


Enter the data file path.


Enable security for the database. This requires the login to be set as 'Master'.


Select the data file path by browsing directory tree.


Enter the user password.


index grid
Displays index properties and segments defined on the table.


Indicates "INSERT" query type.


Lists the constraints currently applied to the database.

This window displays the following constraint information:

Foreign key

Parent table

Dependent table

Delete rule

Update rule

FK#

F. Key columns:

P.K.

P.Key columns


HIDD_LOGIN_DIALOG


Select the server name for this connection.


Choose one or more tables to be dropped.


Owner Name
Enter the owner name.


Page Prealloc
Specify number of pages to preallocate for the newly created table.


Select to specify a custom number of pages to preallocate. Otherwise, the default value (1 page) will be used.


Page Size Check
Select to specify a custom page size. Otherwise, the default value (4096 bytes) will be used.


Specify the custom page size for the newly created table.


Enter your login password.


HIDD_QB_ADDTABLE


Constraints list: lists constraints currently applied to the database.

Foreign key:

Parent table:

Dependent table:

Delete rule:

Update rule:

FK#:

F. Key columns:

P.K.:

P.Key columns:


Select to perform a referential integrity test.


Excludes all tables from the test list.


Removes the selected table from the test list.


Enables secure access to the database.


Indicates "SELECT" query type.


HIDD_QB_QUERY_TYPE


HIDC_LIST2


Enter the server name.


HIDD_DB_SECURITY


SQL Data Manager Overview
SQL Data Manager

SQL Data Manager is a Win32 utility that replaces SQLScope and DDF Ease, utilities that shipped with Pervasive.SQL v7. Its functionality is tightly integrated into the Pervasive Control Center.

Features in SQL Data Manager include:

 Creating and running SQL statements

 Results display in grid or text format

 Query building capability includes selection of tables, columns, and SQL syntax templates from lists

 Referential Integrity List/Check Constraints functionality

 SQL Data Manager Display Tab removes the current limit of displaying a maximum of 100 rows of data and allows in-place editing of data

 Creation, modification, and deletion of database tables

 SQL Query Editor and Executor


HIDD_SELECT_LIST


HIDD_NEW_TABLE2_ND


Select foreign keys for testing.


HIDD_TABLE_CHECK_PROGRESS


Displays the referential integrity test results.  You may view the report in this window, save it to a file, or print the results.


Displays statistics and results of the referential integrity test.


Lists the available tables.


Threshold Check
Specifies a custom value for free space threshold value. Otherwise, the default value (5%) will be used. This element is enabled only if the table comprises records of variable length.


Select custom free space threshold value.


Indicates "UPDATE" query type.


User Name
Enter the user name.


Select the database name for this connection.


Create Empty Datafile
Creates an empty data file for the selected table. Select the table name and specify a data file name for that table.


Enter table name
Enter a new table name. Specify data file location, if necessary.


Create Table
To create a table

1  Add columns to your table using the Add Column icon in the upper right hand corner of the dialog box.

2  Define each column you add to the table.

Column Name - Enter the name for the column are are adding.

Data Type - Select the Data Type for the column you are adding from the drop-down combo box.

When you select a Data Type, all associated information for that Data Type is completed in the column definition.  Note that for some Data Types the Precision and Scale may be adjusted.

Size - The Size associated with the Data Type you select is automatically entered in this field.

Precision - The maximum number of digits used by the Data Type of the column.

Scale - The number of digits in a number that are to the right of the decimal point.

Case - Check this box if the column is case insensitive.

NULL - Check this box to indicate this column is Nullable.

ACS - The Alternate Collating Sequence file name.

After you have defined all the columns for your table, you can now define an index.


SQL Data Manager Properties
Displays the SQL Data Manager properties.


Btrieve Grid Window
Displays the Btrieve column information for the table selected.


Column Grid Window
Displays the ODBC SQL column information for the table selected.


Index Grid
Displays the index information for the table selected.


Statistics Grid
Displays the table statistics for the table selected.


Check Database (2)
Select tables for consistency test.


Consistency Test Results
Displays the consistency test results.


Check Database (Intro)
Select to perform a Consistency Test or a Referential Integrity Test.

A Consistency Test checks logical and physical consistency of the selected database, including table and indexes.

A Referential Integrity Test checks referential integrity constraints applied to the selected database.


Check Database (Wizard)

Select the type of referential integrity details you want included in the database test.

Report file - the name of file containing the report details.

Orphan rows - select whether to write orphan rows to the exception table or to delete them.

Inconsistencies - Select if you want to have inconsistencies repaired.


Referential Integrity Test
Select tables for referential integrity test.


Referential Integrity Test Results
Displays Referential Integrity test results.


Set Database Security Dialog box
Set Database Security

Select Enable Database Security.  Enter the password and then reenter the password to confirm. This option requires the user to be logged in as 'Master'.


Drop Table (Wizard)

Select table to drop: Select the table to be dropped.

Delete Data File: Select to drop the data files.


Contraints list
Lists the constraints currently applied to the database.

This window displays the following constraint information:

Foreign key

Parent table

Dependent table

Delete rule

Update rule

FK#

F. Key columns:

P.K.

P. Key columns


HIDC_SQL_EDIT_HELP