Section 7: overview, conventions, and miscellany
DROP TEXT SEARCH DICTIONARY – remove a text search dictionary Synopsis DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP TEXT SEARCH DICTIONARY drops an existing text search dictionary. To execute this command you must be the owner of the dictionary. Parameters IF EXISTS Do not throw an…
DROP TEXT SEARCH CONFIGURATION – remove a text search configuration Synopsis DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP TEXT SEARCH CONFIGURATION drops an existing text search configuration. To execute this command you must be the owner of the configuration. Parameters IF EXISTS Do not throw an…
DROP TABLESPACE – remove a tablespace Synopsis DROP TABLESPACE [ IF EXISTS ] tablespacename Description DROP TABLESPACE removes a tablespace from the system. A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it can be dropped. It is possible that objects in…
DROP TABLE – remove a table Synopsis DROP TABLE [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP TABLE removes tables from the database. Only its owner can drop a table. To empty a table of rows without destroying the table, use DELETE [delete(7)] or TRUNCATE [truncate(7)]. DROP TABLE always…
DROP SERVER – remove a foreign server descriptor Synopsis DROP SERVER [ IF EXISTS ] servername [ CASCADE | RESTRICT ] Description DROP SERVER removes an existing foreign server descriptor. To execute this command, the current user must be the owner of the server. Parameters IF EXISTS Do not throw an error if the server…
DROP SEQUENCE – remove a sequence Synopsis DROP SEQUENCE [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP SEQUENCE removes sequence number generators. A sequence can only be dropped by its owner or a superuser. Parameters IF EXISTS Do not throw an error if the sequence does not exist. A…
DROP SCHEMA – remove a schema Synopsis DROP SCHEMA [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP SCHEMA removes schemas from the database. A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained objects) even…
DROP RULE – remove a rewrite rule Synopsis DROP RULE [ IF EXISTS ] name ON relation [ CASCADE | RESTRICT ] Description DROP RULE drops a rewrite rule. Parameters IF EXISTS Do not throw an error if the rule does not exist. A notice is issued in this case. name The name of the…
DROP ROLE – remove a database role Synopsis DROP ROLE [ IF EXISTS ] name [, …] Description DROP ROLE removes the specified role(s). To drop a superuser role, you must be a superuser yourself; to drop non-superuser roles, you must have CREATEROLE privilege. A role cannot be removed if it is still referenced in…
DROP OWNED – remove database objects owned by a database role Synopsis DROP OWNED BY name [, …] [ CASCADE | RESTRICT ] Description DROP OWNED drops all the objects in the current database that are owned by one of the specified roles. Any privileges granted to the given roles on objects in the current…
DROP OPERATOR FAMILY – remove an operator family Synopsis DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] Description DROP OPERATOR FAMILY drops an existing operator family. To execute this command you must be the owner of the operator family. DROP OPERATOR FAMILY includes dropping any operator classes contained…
DROP OPERATOR CLASS – remove an operator class Synopsis DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] Description DROP OPERATOR CLASS drops an existing operator class. To execute this command you must be the owner of the operator class. DROP OPERATOR CLASS does not drop any of the…
DROP OPERATOR – remove an operator Synopsis DROP OPERATOR [ IF EXISTS ] name ( { lefttype | NONE } , { righttype | NONE } ) [ CASCADE | RESTRICT ] Description DROP OPERATOR drops an existing operator from the database system. To execute this command you must be the owner of the operator….
DROP LANGUAGE – remove a procedural language Synopsis DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP LANGUAGE removes the definition of a previously registered procedural language. You must be a superuser or the owner of the language to use DROP LANGUAGE. Parameters IF EXISTS Do not…
DROP INDEX – remove an index Synopsis DROP INDEX [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index. Parameters IF EXISTS Do not throw an error if the index…
DROP_GROUP – remove a database role Synopsis DROP GROUP [ IF EXISTS ] name [, …] Description DROP GROUP is now an alias for DROP ROLE (DROP_ROLE(7)). Compatibility There is no DROP GROUP statement in the SQL standard. See Also DROP ROLE (DROP_ROLE(7))
DROP FUNCTION – remove a function Synopsis DROP FUNCTION [ IF EXISTS ] name ( [ [ argmode ] [ argname ] argtype [, …] ] ) [ CASCADE | RESTRICT ] Description DROP FUNCTION removes the definition of an existing function. To execute this command the user must be the owner of the function….
DROP_FOREIGN_TABLE – remove a foreign table Synopsis DROP FOREIGN TABLE [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP FOREIGN TABLE removes a foreign table. Only the owner of a foreign table can remove it. Parameters IF EXISTS Do not throw an error if the foreign table does not exist….
DROP FOREIGN DATA WRAPPER – remove a foreign-data wrapper Synopsis DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. To execute this command, the current user must be the owner of the foreign-data wrapper. Parameters IF EXISTS Do not throw…
DROP_EXTENSION – remove an extension Synopsis DROP EXTENSION [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP EXTENSION removes extensions from the database. Dropping an extension causes its component objects to be dropped as well. You must own the extension to use DROP EXTENSION. Parameters IF EXISTS Do not throw…