October 2001
Beginner to intermediate
400 pages
7h 45m
English
The following table organizes the supported SQL commands by task.
| Creation | Destruction | Use/Modify | |
|---|---|---|---|
| Database | CREATE DATABASE | DROP DATABASE |
COMMENT
LOAD VACUUM |
| Table/Index |
CREATE TABLE
CREATE INDEX CREATE VIEW |
DROP TABLE
DROP INDEX DROP VIEW TRUNCATE |
COMMENT
SELECT EXPLAIN ALTER TABLE ALTER INDEX COPY UPDATE INSERT DELETE SELECT INTO VACUUM CLUSTER |
| Constraints |
CREATE TRIGGER
CREATE CONSTRAINT CREATE RULE CREATE SEQUENCE |
DROP TRIGGER
DROP CONSTRAINT DROP RULE DROP SEQUENCE | COMMENT |
| User | CREATE USER CREATE GROUP | DROP USER DROP GROUP |
ALTER USER
ALTER GROUP GRANT REVOKE |
| Session/Transaction |
SET
DECLARE BEGIN |
CLOSE
ABORT COMMIT ROLLBACK END |
SHOW
RESET FETCH MOVE LISTEN UNLISTEN NOTIFY LOCK UNLOCK |
| Misc |
CREATE AGGREGATE
CREATE ... |
Read now
Unlock full access