Progress/400
Product Guide
Deleting a Table
The Progress/400 Data Dictionary allows you to delete a table in the server schema. It also gives you the option of deleting the associated DB2/400 physical file. If you choose to delete the table only from the server schema, you can still access the associated database file through non-Progress AS/400 applications. However, if you choose to delete the physical file, no application can access it. When you delete a physical file, any logical files associated with it are deleted, regardless of whether other physical files refer to the logical files. For example, if a join logical file refers to the Customer and Order tables, and you delete the Order table and do not preserve the DB2/400 physical file, the join logical file is deleted also.
Virtual files are an exception. The Progress/400 Data Dictionary allows you to delete these from the server schema. However, it does not allow you to delete the associated DB2/400 logical files.
Follow these steps to delete a table:
- Choose the Table mode button in the Progress/400 Data Dictionary main window.
- Choose Modify schema.
- Select a table from the Tables list.
- Choose the Delete Table button. The following message appears:
![]()
- Choose Yes.
- A message appears asking you whether you want to delete the DB2/400 physical file.
- Choose Yes to delete the physical file, or choose No to delete the definition from the server schema only and preserve the DB2/400 physical file.
You modified the data definitions in the server schema on the AS/400. Your server schema now has changes that are not reflected in the client schema holder until you synchronize it.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |