DROP PROTOCOL
Removes an external table data access protocol from a database.
Synopsis
DROP PROTOCOL [IF EXISTS] <name>Description
DROP PROTOCOL removes the specified protocol from a database.
A protocol name can be specified in the CREATE EXTERNAL TABLE command to read data from or write data to an external data source.
You must be a superuser or the protocol owner to drop a protocol.
If you drop a data access protocol, external tables that have been defined with the protocol will no longer be able to access the external data source.
Parameters
| Parameter | Description |
|---|---|
IF EXISTS |
Do not throw an error if the protocol does not exist. A notice is issued in this case |
name |
The name of an existing data access protocol |
Notes
Dropping a data access protocol does not remove the call handlers defined in the database that are associated with that protocol. You must drop the call handler functions manually.
Shared libraries that were used by the protocol should also be removed from the Greengage DB hosts.
Compatibility
DROP PROTOCOL is a Greengage DB extension.