The SQL commands below are ordered alphabetically.
| CREATE INDEX | Creates an index on a base table |
| CREATE SYNONYM | Creates a PUBLIC synonym name for a database object |
| CREATE TABLE | Creates a new base table |
| CREATE VIEW | Defines a view |
| DELETE | Deletes rows from a table |
| DROP INDEX | Removes an index from a base table |
| DROP SYNONYM | Removes a PUBLIC synonym from the database |
| DROP TABLE | Removes a base table |
| DROP VIEW command | Removes a view |
| GRANT (Database Privileges) | Gives users database access rights |
| GRANT (Object Privileges) | Gives users database object privileges |
| INSERT | Inserts rows into a table |
| REVOKE (Database Privileges) | Removes the privilege to perform an action on a database |
| REVOKE (Object Privileges) | Removes the privilege to perform an action on a database object |
| SELECT | Used to formulate queries |
| SET OPTION | Enables and disables numerous administrative options |
| SET PASSWORD | Allows users to set passwords |
| UPDATE | Changes the data in a table |