Types of SQL statements

 

There are several basic types of SQL statements. They are listed here according to their functions.

• SQL schema statements, also known as data definition language (DDL) statements

• SQL data and data change statements, also known as data manipulation language (DML) statements

• Dynamic SQL statements

• Embedded SQL host language statements

SQL schema statements

SQL data statements

ALTER SEQUENCE ALTER TABLE COMMENT ON CREATE ALIAS CREATE DISTINCT TYPE CREATE FUNCTION CREATE INDEX CREATE PROCEDURE CREATE SCHEMA CREATE SEQUENCE CREATE TABLE CREATE TRIGGER CREATE VIEW DROP ALIAS DROP DISTINCT TYPE DROP FUNCTION DROP INDEX DROP PACKAGE DROP PROCEDURE DROP SEQUENCE DROP SCHEMA DROP TABLE DROP TRIGGER DROP VIEW GRANT DISTINCT TYPE GRANT FUNCTION GRANT PACKAGE GRANT PROCEDURE GRANT SEQUENCE GRANT TABLE LABEL ON RENAME REVOKE DISTINCT TYPE REVOKE FUNCTION REVOKE PACKAGE REVOKE PROCEDURE REVOKE SEQUENCE REVOKE TABLE

CLOSE DECLARE CURSOR DELETE FETCH FREE LOCATOR HOLD LOCATOR INSERT LOCK TABLE OPEN REFRESH TABLE SELECT INTO SET variable UPDATE VALUES INTO

SQL data change statements	SQL connection statements
DELETE INSERT UPDATE	CONNECT DISCONNECT RELEASE SET CONNECTION

SQL transaction statements	SQL session statements
COMMIT RELEASE SAVEPOINT ROLLBACK SAVEPOINT SET TRANSACTION	DECLARE GLOBAL TEMPORARY TABLE SET CURRENT DEGREE SET ENCRYPTION PASSWORD SET PATH SET SCHEMA SET SESSION AUTHORIZATION

Dynamic SQL statements	Embedded SQL host language statements
ALLOCATE DESCRIPTOR DEALLOCATE DESCRIPTOR DESCRIBE DESCRIBE INPUT DESCRIBE TABLE EXECUTE EXECUTE IMMEDIATE GET DESCRIPTOR PREPARE SET DESCRIPTOR	BEGIN DECLARE SECTION DECLARE PROCEDURE DECLARE STATEMENT DECLARE VARIABLE END DECLARE SECTION GET DIAGNOSTICS INCLUDE SET OPTION SET RESULT SETS SIGNAL WHENEVER

SQL control statements
CALL

SQL statements can operate on objects that are created by SQL as well as externally described physical files and single-format logical files. They do not refer to the interactive data definition utility (IDDU) dictionary definition for program-described files. Program-described files appear as a table with only a single column.

 

Parent topic:

SQL concepts

 

Related concepts

Data definition language
Data manipulation language

 

Related reference

SQL reference