Search PostgreSQL documentation

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 FUNCTIONManual ChaptersPG18DROP FUNCTION DROP FUNCTION — remove a function Synopsis DROP FUNCTION [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ]DROP FUNCTION 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 GROUPManual ChaptersPG18DROP GROUP DROP GROUP — remove a database role Synopsis DROP GROUP [ IF EXISTS ] name [, ...]DROP GROUP 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 INDEXManual ChaptersPG18DROP INDEX DROP INDEX — remove an index Synopsis DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP INDEX 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 LANGUAGEManual ChaptersPG18DROP LANGUAGE DROP LANGUAGE — remove a procedural language Synopsis DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP LANGUAGE 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 VIEWManual ChaptersPG18DROP MATERIALIZED VIEW DROP MATERIALIZED VIEW — remove a materialized view Synopsis DROP MATERIALIZED VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP MATERIALIZED VIEW 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 OPERATORManual ChaptersPG18DROP OPERATOR DROP OPERATOR — remove an operator Synopsis DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , right_type ) [, ...] [ CASCADE | RESTRICT ]DROP OPERATOR 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 CLASSManual ChaptersPG18DROP OPERATOR CLASS DROP OPERATOR CLASS — remove an operator class Synopsis DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]DROP OPERATOR CLASS 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 FAMILYManual ChaptersPG18DROP OPERATOR FAMILY DROP OPERATOR FAMILY — remove an operator family Synopsis DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]DROP OPERATOR FAMILY 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 OWNEDManual ChaptersPG18DROP OWNED DROP OWNED — remove database objects owned by a database role Synopsis DROP OWNED BY { name | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] [ CASCADE | RESTRICT ]DROP OWNED 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 POLICYManual ChaptersPG18DROP POLICY DROP POLICY — remove a row-level security policy from a table Synopsis DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]DROP POLICY 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 PROCEDUREManual ChaptersPG18DROP PROCEDURE DROP PROCEDURE — remove a procedure Synopsis DROP PROCEDURE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ]DROP PROCEDURE 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 PUBLICATIONManual ChaptersPG18DROP PUBLICATION DROP PUBLICATION — remove a publication Synopsis DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP PUBLICATION 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 ROLEManual ChaptersPG18DROP ROLE DROP ROLE — remove a database role Synopsis DROP ROLE [ IF EXISTS ] name [, ...]DROP ROLE 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 ROUTINEManual ChaptersPG18DROP ROUTINE DROP ROUTINE — remove a routine Synopsis DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ]DROP ROUTINE 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 RULEManual ChaptersPG18DROP RULE DROP RULE — remove a rewrite rule Synopsis DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]DROP RULE 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 SCHEMAManual ChaptersPG18DROP SCHEMA DROP SCHEMA — remove a schema Synopsis DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP SCHEMA 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 SEQUENCEManual ChaptersPG18DROP SEQUENCE DROP SEQUENCE — remove a sequence Synopsis DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP SEQUENCE 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 SERVERManual ChaptersPG18DROP SERVER DROP SERVER — remove a foreign server descriptor Synopsis DROP SERVER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP SERVER 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 STATISTICSManual ChaptersPG18DROP STATISTICS DROP STATISTICS — remove extended statistics Synopsis DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP STATISTICS 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