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 |
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 |