Home | Previous Page | Next Page   The Table Option > Creating or Altering a Table >

Deleting Columns (Drop Option)

To delete a column from a table schema, perform the following steps:

  1. Position the highlight anywhere on the column that you want to delete.
  2. Select the Drop option on the CREATE TABLE (or ALTER TABLE) menu.

    The column line is then partially or completely highlighted on the screen.

DB–Access displays the DROP menu that prompts you to verify your decision, as Figure 54 shows.

Figure 54. The DROP Menu 
DROP clients :   Yes   No
Deletes the highlighted column from the table.

--- Page 1 of 1 ---- mydata@mydbserv --------- Press CONTROL-W for Help ---

 Column Name                     Type            Length   Index Nulls

  customer_num                    Serial            101 
  Unique No  
 fname                           Char               15           Yes
 lname                           Char               15           Yes
 company                         Char               20           Yes

Select Yes from the DROP menu to delete the line currently highlighted in the Schema Editor; select No to keep the line.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]