DROP PROTOCOL
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
DROP PROTOCOL
Removes a 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.
Parameters
- 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
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.
Compatibility
DROP PROTOCOL is a Greenplum Database extension.