Dropping an SQL Statement

Your current database directory stores files that contain SQL statements. You might have installed some of these files with the demonstration database. You might have created other files and put them in the directory with the Save option on the SQL menu. Additional files might have become available when you installed a language supplement with DB–Access.

To remove command files from the current database directory, select the Drop option on the SQL menu. The DROP COMMAND FILE screen appears with an alphabetical list of command files in the current database, as Figure 21 shows.

Figure 21. The DROP COMMAND FILE Screen with Sample Files

DROP COMMAND FILE >> 
Enter the name of the sql command file you wish to drop from the database.

------------- stores_demo@dbserver1 ----------- Press CTRL-W for Help -----

 alt_cat              c_state            d_trig             sel_ojoin1

c_calls             c_stock            d_view             sel_ojoin2

c_cat               c_stores           del_stock          sel_ojoin3

c_custom            c_table            ins_table          sel_ojoin4

c_index             c_trig             opt_disk           sel_order

c_items             c_type             sel_agg            sel_sub

c_manuf             c_view1            sel_all            sel_union

c_orders            c_view2            sel_group          upd_table

c_proc              d_proc             sel_join

If GLS is enabled, the order in which DB–Access lists the names of command files might vary, depending on the locale you use.

Type the name of the command file that you want to drop or highlight it with the arrow keys and press RETURN. A special menu appears that asks for confirmation before it drops the command file as Figure 22 shows.

Figure 22. The DROP COMMAND FILE Confirmation Menu

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

----------------- stores_demo@dbserver1 ----------- Press CTRL-W for Help -----

 alt_cat              c_state            d_trig             sel_ojoin1

c_calls             c_stock            d_view             sel_ojoin2

c_cat               c_stores           del_stock          sel_ojoin3

c_custom            c_table            ins_table          sel_ojoin4

c_index             c_trig             opt_disk           sel_order

c_items             c_type             sel_agg            sel_sub

c_manuf             c_view1            sel_all            sel_union

c_orders            c_view2            sel_group          upd_table

c_proc              d_proc             sel_join

The default is No to help prevent you from deleting a command file by mistake. To drop the highlighted command file, press the Y key or use the right arrow key to highlight Yes and press RETURN. DB–Access drops the command file and returns you to the SQL menu.

To leave the DROP COMMAND FILE screen without dropping a command file, press the N key, RETURN, or the Interrupt key. You then return to the SQL menu.