DETACH <SHARE>

Attached shares are sticky, and will continue to appear in your catalog unless you explicitly detach them with:

Syntax

DETACH <shared database name>;

Example usage

DETACH ducks;