The Table option
Use the Table option to work with tables.
Use the Table option to perform any of the following table management
tasks without SQL programming:
- Create a new table
- Define fragmentation strategy for a new or existing table
- Alter, delete, or display information about an existing table
Use the TABLE menu options as the following table shows.
| Option | Purpose |
|---|---|
| Create | Enables you to define the structure of a new table. The CREATE TABLE menu provides data type options for built-in data types. To define a column with one of the extended data types, such as smart large objects, user-defined (opaque) data types, or a collection data type, use the SQL menu to enter and run a CREATE TABLE statement. DB-Access can construct only a nonclustered, ascending B-tree column index. If you want hash or hybrid fragmentation, use the SQL menu to enter and run the CREATE TABLE or ALTER TABLE statement. |
| Alter | Enables you to alter the structure of an existing table, including columns,
fragmentation, and constraints. You must have the Alter privilege to successfully alter a table. Note: If you use the UI to build the SQL statements to Alter a table without the Alter privilege,
the table will be locked and the operation will fail. Further, the lock will be held until you exit
the alter menu.
|
| Info | Displays information about the structure of a table |
| Drop | Deletes a table from the database |
| Move | Moves a table from the current database to another database. |
| Exit | Returns to the DB-Access main menu |
Both the CREATE TABLE and ALTER TABLE menus have the same options,
which are described in the following table.
| Option | Purpose |
|---|---|
| Add | Displays the Schema Editor, from which you can add a new column to the table |
| Modify | Displays the columns that you defined with the Add option so that you can modify the column structure before building the table |
| Drop | Drops an existing column from the table |
| Screen | Displays the next screen of column definitions in the Schema Editor |
| Table_options | Enables you to display and select storage spaces for a new table. Displays choices from which to set a fragmentation strategy for a new table. Enables you to set extent sizes and lock mode for a new table. Adds or deletes rowids for an existing fragmented table. |
| Constraints | Enables you to define primary-key, foreign-key, check, and unique constraints, and to set default column values |
| Exit | Builds, rebuilds, or discards the schema and structure that you specified with the other options, and then returns to the TABLE menu |
Important: You must use the SPACEBAR to
move between menu options, because the arrow keys control cursor movement
in the Schema Editor.