|
|
|
|
|
Displays the name that will be used to refer to the table within the application.
Displays the name that appears when the name of the table is displayed on the screen in an application.
Displays the name under which the table is stored by the operating system or database. The appropriate extension, if required, is added automatically.
If the table is a temporary table, it will have the physical name "temp".
Indicates the series for the table. It’s a good idea to assign any reports you create to the same series that contains the report’s main table.
Specifies the database manager that will be used to create and access the table. The current choices are c-tree Plus, Pervasive.SQL (P.SQL) and Microsoft SQL Server.
Displays the list of fields in the dictionary.
Displays the fields currently in this table.
Displays the size of each record in the data table, in bytes. A record is made up of two parts: a fixed-length part and a variable-length part.
The fixed-length portion of the record stores all fields with fixed lengths. For Pervasive.SQL tables, the fixed-length portion can be up to 4,088 bytes (approx. 4K). For c-tree tables, it can be up to 32,767 bytes (32K). For SQL tables, the fixed-length portion can be up to 8,060 bytes.
The variable-length portion of the record stores all variable-length fields such as pictures and big text fields. These fields share 32K of variable space. For example, if a table stored a 10K picture and a big text field, the text field could store up to 22K of text for a total of 32K.
Displays a list of the keys that have been created for this table. A key is a field or combination of fields within a table that is used to sort and locate specific records in the table. Typically, the value of the key field or fields is unique for each record in a table so a particular record can be located.
These options don’t apply to the Report Writer.