SQL Keywords and Descriptions

Code Description ABORT Aborts the current transaction ALTER TABLE Modifies table properties ALTER USER Modifies user account information BEGIN WORK Begins a transaction CLOSE Close a cursor CLUSTER Gives storage clustering advice to the backend COMMIT Commits the current transaction COPY Copies data between files and tables CREATE AGGREGATE Defines a new aggregate function CREATE DATABASE Creates a new database CREATE FUNCTION Defines a new function CREATE INDEX Constructs a secondary index CREATE LANGUAGE Defines a new language for functions CREATE OPERATOR Defines a new user operator CREATE RULE Defines a new rule CREATE SEQUENCE Creates a new sequence number generator CREATE TABLE Creates a new table CREATE TABLE AS Creates a new table CREATE TRIGGER Creates a new trigger CREATE TYPE Defines a new base data type CREATE USER Creates account information for a new user CREATE VIEW Constructs a virtual table DECLARE Defines a cursor for table access DELETE Deletes rows from a table DROP AGGREGATE Removes the definition of an aggregate function DROP DATABASE Destroys an existing database DROP FUNCTION Removes a user-defined C function DROP INDEX Removes an index from a database DROP LANGUAGE Removes a user-defined procedural language DROP OPERATOR Removes an operator from the database DROP RULE Removes an existing rule from the database DROP SEQUENCE Removes an existing sequence DROP TABLE Removes existing tables from a database DROP TRIGGER Removes the definition of a trigger DROP TYPE Removes a user-defined type from the system catalogs DROP USER Removes an user account information DROP VIEW Removes an existing view from a database EXPLAIN Shows statement execution details FETCH Gets rows using a cursor GRANT Grants access privilege to a user, a group or all users INSERT Inserts new rows into a table LISTEN Listen for notification on a notify condition LOAD Dynamically loads an object file LOCK Explicit lock of a table inside a transaction MOVE Moves cursor position NOTIFY Signals all frontends and backends listening on a notify condition RESET Restores run-time parameters for session to default values REVOKE Revokes access privilege from a user, a group or all users. ROLLBACK Aborts the current transaction SELECT Retrieve rows from a table or view SELECT INTO Create a new table from an existing table or view SET Set run-time parameters for session SHOW Shows run-time parameters for session UNLISTEN Stop listening for notification UPDATE Replaces values of columns in a table