When the server receives the drop table command for a remote table, a check is made to determine whether the table to be dropped has been created with the existing option. If so, references to the object within the system tables are removed, and the operation is complete.
If the table was not created with the existing option, the command is passed to an appropriate access method, if the object on which the command is to operate has been associated with a remote or external storage location.
The drop table command is reconstructed using a syntax appropriate for the class and is passed to the remote server for execution.
This command is passed to remote servers as a language request.
In all cases, references to the object from within the system catalogs are removed.