Chapter 3. SQL Commands

Table of Contents

ALTER SCHEMA — change properties of a schema
ALTER TABLE — change the definition of a table
CREATE DATABASE — create a new database
CREATE SCHEMA — define a new schema
CREATE TABLE — define a new table
CREATE TABLE AS — define a new table from the results of a query
COPY — copy data between a file and a table
DEALLOCATE — deallocate a prepared statement
DELETE — delete rows of a table
DROP DATABASE — remove a database
DROP SCHEMA — remove a schema
DROP TABLE — remove a table
EXECUTE — execute a prepared statement
INSERT — create new rows in a table
PREPARE — prepare a statement for execution
SELECT — retrieve rows from a table or view
TRUNCATE — empty a table
UPDATE — update rows of a table