Removes a external table data access protocol from a database.
DROP PROTOCOL [IF EXISTS] <name>
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.
Warning: If you drop a data access prococol, external tables that have been defined with the protocol will no longer be able to access the external data source.
If you drop a data access protocol, the call handlers that defined in the database that are associated with the protocol are not dropped. You must drop the functions manually.
Shared libraries that were used by the protocol should also be removed from the Greenplum Database hosts.
DROP PROTOCOL
is a Greenplum Database extension.
CREATE EXTERNAL TABLE, CREATE PROTOCOL
Parent topic: SQL Command Reference