Search PostgreSQL documentation

DROP ACCESS METHODSQL CommandsReferenceDROP ACCESS METHOD Extensions & Access Methods 10 remove an access method DROP ACCESS METHOD [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP ACCESS METHOD removes an existing access method. O…SQL Commands · Extensions & Access Methods DROP AGGREGATESQL CommandsReferenceDROP AGGREGATE Functions & Procedures 10 remove an aggregate function DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [, ...] [ CASCADE | RESTRICT ] where aggregate_signature is: …SQL Commands · Functions & Procedures DROP CASTSQL CommandsReferenceDROP CAST Types & Operators 10 remove a cast DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ] DROP CAST removes a previously defined cast. To be able to drop a cas…SQL Commands · Types & Operators DROP COLLATIONSQL CommandsReferenceDROP COLLATION Types & Operators 10 remove a collation DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP COLLATION removes a previously defined collation. To be able to drop a co…SQL Commands · Types & Operators DROP CONVERSIONSQL CommandsReferenceDROP CONVERSION Types & Operators 10 remove a conversion DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP CONVERSION removes a previously defined conversion. To be able to drop…SQL Commands · Types & Operators DROP DATABASESQL CommandsReferenceDROP DATABASE Databases & Schemas 10 remove a database DROP DATABASE [ IF EXISTS ] name DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the direct…SQL Commands · Databases & Schemas DROP DOMAINSQL CommandsReferenceDROP DOMAIN Types & Operators 10 remove a domain DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP DOMAIN removes a domain. Only the owner of a domain can remove it. IF EXIS…SQL Commands · Types & Operators DROP EVENT TRIGGERSQL CommandsReferenceDROP EVENT TRIGGER Triggers & Rules 10 remove an event trigger DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP EVENT TRIGGER removes an existing event trigger. To execute t…SQL Commands · Triggers & Rules DROP EXTENSIONSQL CommandsReferenceDROP EXTENSION Extensions & Access Methods 10 remove an extension DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP EXTENSION removes extensions from the database. Droppi…SQL Commands · Extensions & Access Methods DROP FOREIGN DATA WRAPPERSQL CommandsReferenceDROP FOREIGN DATA WRAPPER Foreign Data 10 remove a foreign-data wrapper DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP FOREIGN DATA WRAPPER removes an exist…SQL Commands · Foreign Data DROP FOREIGN TABLESQL CommandsReferenceDROP FOREIGN TABLE Foreign Data 10 remove a foreign table DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP FOREIGN TABLE removes a foreign table. Only the owner of a…SQL Commands · Foreign Data DROP FUNCTIONSQL CommandsReferenceDROP FUNCTION Functions & Procedures 10 remove a function DROP FUNCTION [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ] DROP FUNCTION re…SQL Commands · Functions & Procedures DROP GROUPSQL CommandsReferenceDROP GROUP Roles & Privileges 10 remove a database role DROP GROUP [ IF EXISTS ] name [, ...] DROP GROUP is now an alias for DROP ROLE . There is no DROP GROUP statement in the SQL standard.…SQL Commands · Roles & Privileges DROP INDEXSQL CommandsReferenceDROP INDEX Indexes & Statistics 10 remove an index DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP INDEX drops an existing index from the database system. …SQL Commands · Indexes & Statistics DROP LANGUAGESQL CommandsReferenceDROP LANGUAGE Functions & Procedures 10 remove a procedural language DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP LANGUAGE removes the definition of a previous…SQL Commands · Functions & Procedures DROP MATERIALIZED VIEWSQL CommandsReferenceDROP MATERIALIZED VIEW Tables & Views 10 remove a materialized view DROP MATERIALIZED VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP MATERIALIZED VIEW drops an existing material…SQL Commands · Tables & Views DROP OPERATORSQL CommandsReferenceDROP OPERATOR Types & Operators 10 remove an operator DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , { right_type | NONE } ) [, ...] [ CASCADE | RESTRICT ] DROP OPERATOR drops an …SQL Commands · Types & Operators DROP OPERATOR CLASSSQL CommandsReferenceDROP OPERATOR CLASS Types & Operators 10 remove an operator class DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DROP OPERATOR CLASS drops an existing opera…SQL Commands · Types & Operators DROP OPERATOR FAMILYSQL CommandsReferenceDROP OPERATOR FAMILY Types & Operators 10 remove an operator family DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DROP OPERATOR FAMILY drops an existing o…SQL Commands · Types & Operators DROP OWNEDSQL CommandsReferenceDROP OWNED Roles & Privileges 10 remove database objects owned by a database role DROP OWNED BY { name | CURRENT_USER | SESSION_USER } [, ...] [ CASCADE | RESTRICT ] DROP OWNED drops all the…SQL Commands · Roles & Privileges DROP POLICYSQL CommandsReferenceDROP POLICY Roles & Privileges 10 remove a row level security policy from a table DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] DROP POLICY removes the specified policy…SQL Commands · Roles & Privileges DROP PROCEDURESQL CommandsReferenceDROP PROCEDURE Functions & Procedures 11 remove a procedure DROP PROCEDURE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ] DROP PROCEDUR…SQL Commands · Functions & Procedures DROP PROPERTY GRAPHSQL CommandsReferenceDROP PROPERTY GRAPH Other Objects 19 remove an SQL-property graph DROP PROPERTY GRAPH [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP PROPERTY GRAPH drops an existing property graph. …SQL Commands · Other Objects DROP PUBLICATIONSQL CommandsReferenceDROP PUBLICATION Logical Replication 10 remove a publication DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP PUBLICATION removes an existing publication from the data…SQL Commands · Logical Replication DROP ROLESQL CommandsReferenceDROP ROLE Roles & Privileges 10 remove a database role DROP ROLE [ IF EXISTS ] name [, ...] DROP ROLE removes the specified role(s). To drop a superuser role, you must be a superuser yoursel…SQL Commands · Roles & Privileges DROP ROUTINESQL CommandsReferenceDROP ROUTINE Functions & Procedures 11 remove a routine DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ] DROP ROUTINE remove…SQL Commands · Functions & Procedures DROP RULESQL CommandsReferenceDROP RULE Triggers & Rules 10 remove a rewrite rule DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] DROP RULE drops a rewrite rule. IF EXISTS Do not throw an error if the r…SQL Commands · Triggers & Rules DROP SCHEMASQL CommandsReferenceDROP SCHEMA Databases & Schemas 10 remove a schema DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP SCHEMA removes schemas from the database. A schema can only be dropped b…SQL Commands · Databases & Schemas DROP SEQUENCESQL CommandsReferenceDROP SEQUENCE Tables & Views 10 remove a sequence DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP SEQUENCE removes sequence number generators. A sequence can only be dro…SQL Commands · Tables & Views DROP SERVERSQL CommandsReferenceDROP SERVER Foreign Data 10 remove a foreign server descriptor DROP SERVER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP SERVER removes an existing foreign server descriptor. To exe…SQL Commands · Foreign Data DROP STATISTICSSQL CommandsReferenceDROP STATISTICS Indexes & Statistics 10 remove extended statistics DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP STATISTICS removes statistics object(s) from the dat…SQL Commands · Indexes & Statistics DROP SUBSCRIPTIONSQL CommandsReferenceDROP SUBSCRIPTION Logical Replication 10 remove a subscription DROP SUBSCRIPTION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP SUBSCRIPTION removes a subscription from the database cluster.…SQL Commands · Logical Replication DROP TABLESQL CommandsReferenceDROP TABLE Tables & Views 10 remove a table DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP TABLE removes tables from the database. Only the table owner, the schema owner, …SQL Commands · Tables & Views DROP TABLESPACESQL CommandsReferenceDROP TABLESPACE Databases & Schemas 10 remove a tablespace DROP TABLESPACE [ IF EXISTS ] name DROP TABLESPACE removes a tablespace from the system. A tablespace can only be dropped by its ow…SQL Commands · Databases & Schemas DROP TEXT SEARCH CONFIGURATIONSQL CommandsReferenceDROP TEXT SEARCH CONFIGURATION Text Search 10 remove a text search configuration DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH CONFIGURATION drops…SQL Commands · Text Search DROP TEXT SEARCH DICTIONARYSQL CommandsReferenceDROP TEXT SEARCH DICTIONARY Text Search 10 remove a text search dictionary DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH DICTIONARY drops an existing…SQL Commands · Text Search DROP TEXT SEARCH PARSERSQL CommandsReferenceDROP TEXT SEARCH PARSER Text Search 10 remove a text search parser DROP TEXT SEARCH PARSER [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH PARSER drops an existing text search par…SQL Commands · Text Search DROP TEXT SEARCH TEMPLATESQL CommandsReferenceDROP TEXT SEARCH TEMPLATE Text Search 10 remove a text search template DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH TEMPLATE drops an existing text se…SQL Commands · Text Search DROP TRANSFORMSQL CommandsReferenceDROP TRANSFORM Functions & Procedures 10 remove a transform DROP TRANSFORM [ IF EXISTS ] FOR type_name LANGUAGE lang_name [ CASCADE | RESTRICT ] DROP TRANSFORM removes a previously defined t…SQL Commands · Functions & Procedures DROP TRIGGERSQL CommandsReferenceDROP TRIGGER Triggers & Rules 10 remove a trigger DROP TRIGGER [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] DROP TRIGGER removes an existing trigger definition. To execute this co…SQL Commands · Triggers & Rules