Deleting Access Paths › Deleting an Access Path

Deleting an Access Path

Access paths can be deleted only if they are not referenced by any other function or access path. A cross-reference panel, Display Access Path Reference, is available to show you where a given access path is used.

To delete an access path

1. Zoom into the file. At the Edit Database Relations panel, type Z next to any relation for the selected file and press Enter. Alternatively, you can use selection option 2 from the Edit Model Object List panel.

   The Edit File Details panel displays with a list of the access paths for the file.

2. Delete the access path. Type D next to the access path you want to delete and press Enter.

   The Delete Access Path panel displays:

   

3. Validate your actions. Press Enter to validate the deletion.

   An additional confirmation prompt displays before the access path is deleted. This prompt allows you to specify that the source and object are to be deleted.

   CA 2E does not allow you to delete the access path if it is referenced by any other function or access path.

   You must eliminate the references before you can delete the access path. You can do so by determining the usage of an access path.

4. Confirm the deletion. At prompt, press Enter to confirm the deletion.