Structured Query Language (SQL) has a set of commands that can be used to manipulate relational database. The commands can be categorized into data definition function, data manipulation function and data control function. SQL Commands usually appear in the form of action verb. It is a basic convention that all SQL statements begin with a command. The following table list the core SQL commands.
SQL Command
|
ALTER DOMAIN |
DECLARE CURSOR |
FETCH |
|
ALTER TABLE |
DECLARE TABLE |
FREE LOCATOR |
|
CALL |
DELETE |
GET DIAGNOSTICS |
|
CLOSE |
DISCONNECT |
GRANT |
|
COMMIT |
DROP ASSERTION |
HOLD LOCATOR |
|
CONNECT |
DROP CHARACTER SET |
INSERT |
|
CREATE ASSERTION |
DROP COLLATION |
OPEN |
|
CREATE CHARACTER SET |
DROP DOMAIN |
RELEASE SAVEPOINT |
|
CREATE COLLATION |
DROP ORDERING |
RETURN |
|
CREATE DOMAIN |
DROP FOLE |
REVOKE |
|
CREATE FUNCTION |
DROP SCHEMA |
ROLLBACK |
|
CREATE METHOD |
DROP SPECIFIC FUNCTION |
SAVEPOINT |
|
CREATE ORDERING |
DROP SPECIFIC PROCEDURE |
SELECT |
|
CREATE PROCEDURE |
DROP SPECIFIC ROUTINE |
SET CONNECTION |
|
CREATE ROLE |
DROP TABLE |
SET CONSTRAINTS |
|
CREATE SCHEMA |
DROP TRANSFORM |
SET ROLE |
|
CREATE TABLE |
DROP TRANSLATION |
SET SESSION AUTHORIZATION |
|
CREATE TRANSFORM |
DROP TRIGGER |
SET CHARACTERISTICS |
|
CREATE TRANSLATION |
DROP TYPE |
SET TIME ZONE |
|
CREATE TRIGGER |
DROP VIEW |
SET TRANSACTION |
|
CREATE TYPE |
|
START TRANSACTION |
|
CREATE VIEW |
|
UPDATE |