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.
To use the LOAD statement to insert data into a table, you must have both Insert and Select privileges for the table.
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.

Copyright© 2019 HCL Technologies Limited