SQL Statements

SQL statements can be divided into these groups: definition statements, manipulation statements, transaction statements and control statements.

Definition statements:

CREATE SCHEMA
DROP SCHEMA
CREATE USER
DROP USER
CREATE GROUP
DROP GROUP
CREATE ROLE
DROP ROLE
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
DROP INDEX
CREATE DOMAIN
ALTER DOMAIN
DROP DOMAIN
CREATE VIEW
DROP VIEW
GRANT
REVOKE
RENAME

Statements for creating, modifying and deleting routines (see Routines stored on the server).

CREATE PROCEDURE
CREATE FUNCTION
ALTER PROCEDURE
ALTER FUNCTION
DROP PROCEDURE
DROP FUNCTION

Statements for creating, modifying and deleting triggers (see Triggers).

CREATE TRIGGER
ALTER TRIGGER
DROP TRIGGER

Statements for creating, modifying and deleting sequences (see Sequences).

CREATE SEQUENCE
ALTER SEQUENCE
DROP SEQUENCE

Statements for creating, modifying and deleting full-text systems.

CREATE FULLTEXT
DROP FULLTEXT
ALTER FULLTEXT

Manipulation statements:

SELECT INTO
UPDATE
INSERT
DELETE

Statements for working with cursors (see Cursors in SQL).

OPEN
FETCH
UPDATE CURRENT OF
DELETE CURRENT OF
CLOSE

Transaction statements:

Transaction statements are described in a separate chapter (see Transactions and savepoints).

START TRANSACTION
COMMIT
ROLLBACK
SET TRANSACTION
SAVEPOINT
RELEASE SAVEPOINT

Control statements:

Control statements are described in a separate chapter (see Control statements).

block statement
assign statement SET
RETURN
IF
CASE
LOOP
WHILE
REPEAT
LEAVE
FOR
CALL
SIGNAL
RESIGNAL

List of topics:

Queries in SQL

SQL Language in 602SQL

Object Declaration in SQL