Dropping a Table

Use the Drop option on the TABLE menu to delete an existing table schema from the database. Press the D key, or highlight Drop and press RETURN. The DROP TABLE screen appears, as Figure 108 shows.

DROP TABLE >> 
Enter the table name you wish to drop from the database.

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

  clients 

 customer

 orders

This screen lists the names of tables that exist in the current database. You can delete a table in one of the following ways:

• Type the table name and press RETURN. You must use this method and include the full pathname if you want to delete a table that is not in the current database.
• Use the arrow keys to highlight the name of the table that you want to delete from the database and press RETURN.

To leave the DROP TABLE screen without deleting a table, press the Interrupt key. You return to the TABLE menu.

After you select a table to delete, DB–Access displays the CONFIRM menu, which asks for confirmation before it deletes the table, as Figure 109 shows.

CONFIRM:  No  Yes
No, I do not want to drop it.

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

 clients 

customer

orders

The default is No to prevent you from deleting a table. You must explicitly delete a table. Thus, if you want to delete the highlighted table, press the Y key or use the right arrow key to highlight Yes and press RETURN. DB–Access deletes the table.