SQL Commands

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