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.