The TABLE Menu

Home | Previous Page | Next Page The Table Option >

The TABLE Menu

When you press the T key or select the Table option from the main menu, the TABLE menu appears, as Figure 42 shows.

Figure 42. The TABLE Menu

TABLE:   Create   Alter  Info  Drop  Move  Exit
Create a new table.

-------------mydata@mydbserv--------------------Press CTRL-W for Help -----

If no current database exists when you select the Table option, the SELECT DATABASE screen appears. Select from a list of databases defined for the current database server or press the Interrupt key to display the main menu.

Important:

In the SELECT DATABASE screen, the names of databases are limited to 18 characters. If a database name is longer than 18 characters, you will see the first 17 characters of the name followed by a + sign. Enter the + sign to display the complete long name in vi. To exit from vi, press ESC ZZ.

Use the TABLE menu options as the following table shows.

Option	Purpose	Instructions
Create	Enables you to define the structure of a new table	Creating or Altering a Table
Alter	Enables you to alter the structure of an existing table	Creating or Altering a Table
Info	Displays information about the structure of a table	Displaying Table Information
Drop	Deletes a table from the database	Dropping a Table
Move	Moves a table from the current database to another database.	Moving a Table (XPS)
Exit	Returns to the DB-Access main menu	none