SQL statements

The following sections define the syntax information for all supported SQL statements.


ALLOCATE DESCRIPTOR statement [ESQL]
ALTER DATABASE statement
ALTER DBSPACE statement
ALTER DOMAIN statement
ALTER EVENT statement
ALTER EXTERNAL ENVIRONMENT statement
ALTER FUNCTION statement
ALTER INDEX statement
ALTER LOGIN POLICY statement
ALTER MATERIALIZED VIEW statement
ALTER MIRROR SERVER statement
ALTER PROCEDURE statement
ALTER PUBLICATION statement [MobiLink] [SQL Remote]
ALTER REMOTE MESSAGE TYPE statement [SQL Remote]
ALTER SEQUENCE statement
ALTER SERVER statement
ALTER SERVICE statement [HTTP web service]
ALTER SERVICE statement [SOAP web service]
ALTER SPATIAL REFERENCE SYSTEM statement
ALTER STATISTICS statement
ALTER SYNCHRONIZATION PROFILE statement [MobiLink]
ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
ALTER SYNCHRONIZATION USER statement [MobiLink]
ALTER TABLE statement
ALTER TEXT CONFIGURATION statement
ALTER TEXT INDEX statement
ALTER TRIGGER statement
ALTER USER statement
ALTER VIEW statement
ATTACH TRACING statement
BACKUP statement
BEGIN SNAPSHOT statement
BEGIN statement
BEGIN statement [TSQL]
BEGIN TRANSACTION statement [T-SQL]
BREAK statement [T-SQL]
CALL statement
CASE statement
CASE statement [T-SQL]
CHECKPOINT statement
CLEAR statement [Interactive SQL]
CLOSE statement [ESQL] [SP]
COMMENT statement
COMMIT statement
CONFIGURE statement [Interactive SQL]
CONNECT statement [ESQL] [Interactive SQL]
CONTINUE statement
CREATE DATABASE statement
CREATE DBSPACE statement
CREATE DECRYPTED DATABASE statement
CREATE DECRYPTED FILE statement
CREATE DOMAIN statement
CREATE ENCRYPTED DATABASE statement
CREATE ENCRYPTED FILE statement
CREATE EVENT statement
CREATE EXISTING TABLE statement
CREATE EXTERNLOGIN statement
CREATE FUNCTION statement [External call]
CREATE FUNCTION statement [Web service]
CREATE FUNCTION statement
CREATE INDEX statement
CREATE LOCAL TEMPORARY TABLE statement
CREATE LOGIN POLICY statement
CREATE MATERIALIZED VIEW statement
CREATE MESSAGE statement [T-SQL]
CREATE MIRROR SERVER statement
CREATE PROCEDURE statement [External call]
CREATE PROCEDURE statement [Web service]
CREATE PROCEDURE statement [T-SQL]
CREATE PROCEDURE statement
CREATE PUBLICATION statement [MobiLink] [SQL Remote]
CREATE REMOTE MESSAGE TYPE statement [SQL Remote]
CREATE SCHEMA statement
CREATE SEQUENCE statement
CREATE SERVER statement
CREATE SERVICE statement [HTTP web service]
CREATE SERVICE statement [SOAP web service]
CREATE SPATIAL REFERENCE SYSTEM statement
CREATE SPATIAL UNIT OF MEASURE statement
CREATE STATISTICS statement
CREATE SUBSCRIPTION statement [SQL Remote]
CREATE SYNCHRONIZATION PROFILE statement [MobiLink]
CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
CREATE SYNCHRONIZATION USER statement [MobiLink]
CREATE TABLE statement
CREATE TEXT CONFIGURATION statement
CREATE TEXT INDEX statement
CREATE TRIGGER statement
CREATE TRIGGER statement [T-SQL]
CREATE USER statement
CREATE VARIABLE statement
CREATE VIEW statement
DEALLOCATE DESCRIPTOR statement [ESQL]
DEALLOCATE statement
Declaration section [ESQL]
DECLARE CURSOR statement [ESQL] [SP]
DECLARE LOCAL TEMPORARY TABLE statement
DECLARE statement
DELETE statement (positioned) [ESQL] [SP]
DELETE statement
DESCRIBE statement [ESQL]
DESCRIBE statement [Interactive SQL]
DETACH TRACING statement
DISCONNECT statement [ESQL] [Interactive SQL]
DROP CONNECTION statement
DROP DATABASE statement
DROP DATATYPE statement
DROP DBSPACE statement
DROP DOMAIN statement
DROP EVENT statement
DROP EXTERNLOGIN statement
DROP FUNCTION statement
DROP INDEX statement
DROP LOGIN POLICY statement
DROP MATERIALIZED VIEW statement
DROP MESSAGE statement
DROP MIRROR SERVER statement
DROP PROCEDURE statement
DROP PUBLICATION statement [MobiLink] [SQL Remote]
DROP REMOTE MESSAGE TYPE statement [SQL Remote]
DROP SEQUENCE statement
DROP SERVER statement
DROP SERVICE statement
DROP SPATIAL REFERENCE SYSTEM statement
DROP SPATIAL UNIT OF MEASURE statement
DROP STATEMENT statement [ESQL]
DROP STATISTICS statement
DROP SUBSCRIPTION statement [SQL Remote]
DROP SYNCHRONIZATION PROFILE statement [MobiLink]
DROP SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
DROP SYNCHRONIZATION USER statement [MobiLink]
DROP TABLE statement
DROP TEXT CONFIGURATION statement
DROP TEXT INDEX statement
DROP TRIGGER statement
DROP USER statement
DROP VARIABLE statement
DROP VIEW statement
EXCEPT statement
EXECUTE IMMEDIATE statement [SP]
EXECUTE statement [ESQL]
EXECUTE statement [T-SQL]
EXIT statement [Interactive SQL]
EXPLAIN statement [ESQL]
FETCH statement [ESQL] [SP]
FOR statement
FORWARD TO statement
FROM clause
GET DATA statement [ESQL]
GET DESCRIPTOR statement [ESQL]
GET OPTION statement [ESQL]
GOTO statement [T-SQL]
GRANT CONSOLIDATE statement [SQL Remote]
GRANT PUBLISH statement [SQL Remote]
GRANT REMOTE DBA statement [MobiLink] [SQL Remote]
GRANT REMOTE statement [SQL Remote]
GRANT statement
GROUP BY clause
HELP statement [Interactive SQL]
IF statement
IF statement [T-SQL]
INCLUDE statement [ESQL]
INPUT statement [Interactive SQL]
INSERT statement
INSTALL EXTERNAL OBJECT statement
INSTALL JAVA statement
INTERSECT statement
LEAVE statement
LOAD STATISTICS statement
LOAD TABLE statement
LOCK FEATURE statement
LOCK TABLE statement
LOOP statement
MERGE statement
MESSAGE statement
OPEN statement [ESQL] [SP]
OUTPUT statement [Interactive SQL]
PARAMETERS statement [Interactive SQL]
PASSTHROUGH statement [SQL Remote]
PREPARE statement [ESQL]
PREPARE TO COMMIT statement
PRINT statement [T-SQL]
PUT statement [ESQL]
RAISERROR statement
READ statement [Interactive SQL]
READTEXT statement [T-SQL]
REFRESH MATERIALIZED VIEW statement
REFRESH TEXT INDEX statement
REFRESH TRACING LEVEL statement
RELEASE SAVEPOINT statement
REMOTE RESET statement [SQL Remote]
REMOVE EXTERNAL OBJECT statement
REMOVE JAVA statement
REORGANIZE TABLE statement
RESIGNAL statement [SP]
RESTORE DATABASE statement
RESUME statement
RETURN statement
REVOKE CONSOLIDATE statement [SQL Remote]
REVOKE PUBLISH statement [SQL Remote]
REVOKE REMOTE DBA statement [SQL Remote]
REVOKE REMOTE statement [SQL Remote]
REVOKE statement
ROLLBACK statement
ROLLBACK TO SAVEPOINT statement
ROLLBACK TRANSACTION statement [T-SQL]
ROLLBACK TRIGGER statement
SAVE TRANSACTION statement [T-SQL]
SAVEPOINT statement
SELECT statement
SET CONNECTION statement [Interactive SQL] [ESQL]
SET DESCRIPTOR statement [ESQL]
SET MIRROR OPTION statement
SET OPTION statement
SET OPTION statement [Interactive SQL]
SET REMOTE OPTION statement [SQL Remote]
SET SQLCA statement [ESQL]
SET statement
SET statement [T-SQL]
SETUSER statement
SIGNAL statement [SP]
START DATABASE statement
START SERVER statement [Interactive SQL]
START EXTERNAL ENVIRONMENT statement
START JAVA statement
START LOGGING statement [Interactive SQL]
START SUBSCRIPTION statement [SQL Remote]
START SYNCHRONIZATION DELETE statement [MobiLink]
START SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]
STOP DATABASE statement
STOP EXTERNAL ENVIRONMENT statement
STOP JAVA statement
STOP LOGGING statement [Interactive SQL]
STOP SERVER statement
STOP SUBSCRIPTION statement [SQL Remote]
STOP SYNCHRONIZATION DELETE statement [MobiLink]
SYNCHRONIZE statement [MobiLink]
STOP SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]
SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]
SYSTEM statement [Interactive SQL]
TRIGGER EVENT statement
TRUNCATE statement
TRUNCATE TEXT INDEX statement
UNION statement
UNLOAD statement
UPDATE (positioned) statement [ESQL] [SP]
UPDATE statement [SQL Remote]
UPDATE statement
VALIDATE statement
WAITFOR statement
WHENEVER statement [ESQL]
WHILE statement [T-SQL]
WINDOW clause
WRITETEXT statement [T-SQL]