You can delete a table from your personal database. Deleting a table deletes its data and the CA Datacom Datadictionary definitions and frees the disk storage space.
Action
Delete a table from either of two panels in the Personal Database Facility or by using the DROP command documented in the Panel and Command Reference.
Display the DIRECTORY OF TABLES (DQT10) panel and place the cursor on a table name. Or, display the DISPLAY TABLE (DQT20) panel for the table to be deleted.
Press <PF4> DROP.
CA Dataquery displays the DROP TABLE CONFIRMATION (DQTA0) panel.
Panel
Following is an example of the DROP TABLE CONFIRMATION (DQTA0) panel containing typical data.
=> Press PF3 to CONFIRM the DROP TABLE or PF4 to CANCEL --------------------------------------------------------------------------DQTA0 DATAQUERY: DROP TABLE CONFIRMATION ------------------------------------------------------------------------------- TABLE NAME: CA_CUST_TBL DATADICTIONARY BASE ID: ------------------------------------------------------------------------------- A DROP TABLE request was made for table CA_CUST_TBL . ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> CONFIRM <PF4> CANCEL
Operation
To confirm deletion of the table, press <PF3> CONFIRM. CA Dataquery displays a message saying the table has been dropped.
To cancel the impending deletion, press <PF4> CANCEL, <PF2> RETURN, or the Clear key.
|
Copyright © 2014 CA.
All rights reserved.
|
|