Table/New Table Dialog Box

Use this dialog box to specify the properties of tables or fields that have been added to a project.

Existing database tables or fields can be included in a project one by one (rather than having them extracted automatically). For example, use this command when adding a table to a database structure.

Options

Primary Key Icon

Specify that the field is part of the primary key for the table. Right-click the field to change the primary key.

Field Name

Display the name of the field you want to add. You can change the field name by typing a new one.

Data Type

Specify the type of data the field contains. If you do not know what kind of data the field contains, select Unknown.

The following describes the English Query data types and their equivalent Microsoft® SQL Server™ data types:

Integer—int, smallint, tinyint Float—real, decimal, numeric, money, small money
Date—datetime, smalldatetime
String—char, varchar
Bit—bit
Text—text
Binary—binary, varbinary, image
Other—timestamp (anything not listed above)
GUID—a globally unique identifier

Caption

Optional. Specify the label for this field, if one exists.

For example, the LastName field may have a caption of Last Name, which is used on forms.

Basic Tab

Use this tab to define the fields in your project.

Advanced Tab

Use this tab to further define the fields in your project.

See Also

Advanced Tab (Table/New Table Dialog Box)

Basic Tab (Table/New Table Dialog Box)

Icons and Cursors Used in English Query