DEALLOCATE Deallocates a prepared statement. DEALLOCATE [PREPARE] name DECLARE Defines a cursor. DECLARE name [BINARY] [INSENSITIVE] [NO SCROLL] CURSOR [{WITH | WITHOUT} HOLD] FOR query [FOR READ ONLY] DELETE Deletes rows from a table. DELETE FROM [ONLY] table [[AS] alias] [USING usinglist] [WHERE condition] DROP AGGREGATE Removes an aggregate function. DROP AGGREGATE [IF EXISTS] name ( type [, ...] ) [CASCADE | RESTRICT] DROP CAST Removes a cast. DROP CAST [IF EXISTS] (sourcetype AS targettype) [CASCADE | RESTRICT] DROP CONVERSION Removes a conversion. DROP CONVERSION [IF EXISTS] name [CASCADE | RESTRICT] DROP DATABASE Removes a database. DROP DATABASE [IF EXISTS] name DROP DOMAIN Removes a domain. DROP DOMAIN [IF EXISTS] name [, ...] [CASCADE | RESTRICT] DROP EXTERNAL TABLE Removes an external table definition. DROP EXTERNAL [WEB] TABLE [IF EXISTS] name [CASCADE | RESTRICT] DROP FILESPACE Removes a filespace. DROP FILESPACE [IF EXISTS] filespacename DROP FUNCTION Removes a function. DROP FUNCTION [IF EXISTS] name ( [ [argmode] [argname] argtype [, ...] ] ) [CASCADE | RESTRICT] DROP GROUP Removes a database role. DROP GROUP [IF EXISTS] name [, ...] DROP INDEX Removes an index. DROP INDEX [IF EXISTS] name [, ...] [CASCADE | RESTRICT] DROP LANGUAGE Removes a procedural language. DROP [PROCEDURAL] LANGUAGE [IF EXISTS] name [CASCADE | RESTRICT] DROP OPERATOR Removes an operator. DROP OPERATOR [IF EXISTS] name ( {lefttype | NONE} , {righttype | NONE} ) [CASCADE | RESTRICT] DROP OPERATOR CLASS Removes an operator class. DROP OPERATOR CLASS [IF EXISTS] name USING index_method [CASCADE | RESTRICT] DROP OWNED Removes database objects owned by a database role. DROP OWNED BY name [, ...] [CASCADE | RESTRICT] DROP RESOURCE QUEUE Removes a resource queue. DROP RESOURCE QUEUE queue_name DROP ROLE Removes a database role. DROP ROLE [IF EXISTS] name [, ...] DROP RULE Removes a rewrite rule. DROP RULE [IF EXISTS] name ON relation [CASCADE | RESTRICT] DROP SCHEMA Removes a schema. DROP SCHEMA [IF EXISTS] name [, ...] [CASCADE | RESTRICT] DROP SEQUENCE Removes a sequence. DROP SEQUENCE [IF EXISTS] name [, ...] [CASCADE | RESTRICT] DROP TABLE Removes a table. DROP TABLE [IF EXISTS] name [, ...] [CASCADE | RESTRICT] DROP TABLESPACE Removes a tablespace. DROP TABLESPACE [IF EXISTS] tablespacename DROP TRIGGER Removes a trigger. DROP TRIGGER [IF EXISTS] name ON table [CASCADE | RESTRICT] DROP TYPE Removes a data type. DROP TYPE [IF EXISTS] name [, ...] [CASCADE | RESTRICT] DROP USER Removes a database role. DROP USER [IF EXISTS] name [, ...] DROP VIEW Removes a view. DROP VIEW [IF EXISTS] name [, ...] [CASCADE | RESTRICT] |
|
|