You can use the destroydb command to delete a distributed database, as you would for a local database.
The destroydb command removes the distributed database, the coordinator database, and all the Ingres Star objects that make up the distributed database. Data in underlying tables in non-coordinator local databases registered in the distributed database are not affected.
For more information on the destroydb command see the Command Reference Guide.
This command removes a distributed database named corporateddb: