Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Statements

Using the SQL statement reference
ALLOCATE DESCRIPTOR statement [ESQL]
ALTER DATABASE statement
ALTER DBSPACE statement
ALTER DOMAIN statement
ALTER EVENT statement
ALTER FUNCTION statement
ALTER INDEX statement
ALTER MATERIALIZED VIEW statement
ALTER PROCEDURE statement
ALTER PUBLICATION statement [MobiLink] [SQL Remote]
ALTER REMOTE MESSAGE TYPE statement [SQL Remote]
ALTER SERVER statement
ALTER SERVICE statement
ALTER STATISTICS statement
ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
ALTER SYNCHRONIZATION USER statement [MobiLink]
ALTER TABLE statement
ALTER TRIGGER statement
ALTER VIEW statement
ATTACH TRACING statement
BACKUP statement
BEGIN statement
BEGIN TRANSACTION statement [T-SQL]
BREAK statement [T-SQL]
CALL statement
CASE statement
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 [T-SQL]
CREATE DATABASE statement
CREATE DBSPACE statement
CREATE DECRYPTED FILE statement
CREATE DOMAIN statement
CREATE ENCRYPTED FILE statement
CREATE EVENT statement
CREATE EXISTING TABLE statement
CREATE EXTERNLOGIN statement
CREATE FUNCTION statement
CREATE INDEX statement
CREATE LOCAL TEMPORARY TABLE statement
CREATE MATERIALIZED VIEW statement
CREATE MESSAGE statement [T-SQL]
CREATE PROCEDURE statement
CREATE PROCEDURE statement [T-SQL]
CREATE PUBLICATION statement [MobiLink] [SQL Remote]
CREATE REMOTE MESSAGE TYPE statement [SQL Remote]
CREATE SCHEMA statement
CREATE SERVER statement
CREATE SERVICE statement
CREATE STATISTICS statement
CREATE SUBSCRIPTION statement [SQL Remote]
CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
CREATE SYNCHRONIZATION USER statement [MobiLink]
CREATE TABLE statement
CREATE TRIGGER statement
CREATE TRIGGER statement [T-SQL]
CREATE VARIABLE statement
CREATE VIEW statement
DEALLOCATE statement
DEALLOCATE DESCRIPTOR statement [ESQL]
Declaration section [ESQL]
DECLARE statement
DECLARE CURSOR statement [ESQL] [SP]
DECLARE CURSOR statement [T-SQL]
DECLARE LOCAL TEMPORARY TABLE statement
DELETE statement
DELETE (positioned) statement [ESQL] [SP]
DESCRIBE statement [ESQL]
DESCRIBE statement [Interactive SQL]
DETACH TRACING statement
DISCONNECT statement [ESQL] [Interactive SQL]
DROP statement
DROP CONNECTION statement
DROP DATABASE statement
DROP EXTERNLOGIN statement
DROP PUBLICATION statement [MobiLink] [SQL Remote]
DROP REMOTE MESSAGE TYPE statement [SQL Remote]
DROP SERVER statement
DROP SERVICE statement
DROP STATEMENT statement [ESQL]
DROP STATISTICS statement
DROP SUBSCRIPTION statement [SQL Remote]
DROP SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
DROP SYNCHRONIZATION USER statement [MobiLink]
DROP VARIABLE statement
EXCEPT statement
EXECUTE statement [ESQL]
EXECUTE statement [T-SQL]
EXECUTE IMMEDIATE statement [SP]
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 statement
GRANT CONSOLIDATE statement [SQL Remote]
GRANT PUBLISH statement [SQL Remote]
GRANT REMOTE statement [SQL Remote]
GRANT REMOTE DBA statement [MobiLink] [SQL Remote]
GROUP BY clause
HELP statement [Interactive SQL]
IF statement
IF statement [T-SQL]
INCLUDE statement [ESQL]
INPUT statement [Interactive SQL]
INSERT statement
INSTALL JAVA statement
INTERSECT statement
LEAVE statement
LOAD STATISTICS statement
LOAD TABLE statement
LOCK TABLE statement
LOOP 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 [T-SQL]
READ statement [Interactive SQL]
READTEXT statement [T-SQL]
REFRESH MATERIALIZED VIEW statement
REFRESH TRACING LEVEL statement
RELEASE SAVEPOINT statement
REMOTE RESET statement [SQL Remote]
REMOVE JAVA statement
REORGANIZE TABLE statement
RESIGNAL statement
RESTORE DATABASE statement
RESUME statement
RETURN statement
REVOKE statement
REVOKE CONSOLIDATE statement [SQL Remote]
REVOKE PUBLISH statement [SQL Remote]
REVOKE REMOTE statement [SQL Remote]
REVOKE REMOTE DBA statement [SQL Remote]
ROLLBACK statement
ROLLBACK TO SAVEPOINT statement
ROLLBACK TRANSACTION statement [T-SQL]
ROLLBACK TRIGGER statement
SAVE TRANSACTION statement [T-SQL]
SAVEPOINT statement
SELECT statement
SET statement
SET statement [T-SQL]
SET CONNECTION statement [Interactive SQL] [ESQL]
SET DESCRIPTOR statement [ESQL]
SET OPTION statement
SET OPTION statement [Interactive SQL]
SET REMOTE OPTION statement [SQL Remote]
SET SQLCA statement [ESQL]
SETUSER statement
SIGNAL statement
START DATABASE statement
START ENGINE statement [Interactive SQL]
START JAVA statement
START LOGGING statement [Interactive SQL]
START SUBSCRIPTION statement [SQL Remote]
START SYNCHRONIZATION DELETE statement [MobiLink]
STOP DATABASE statement
STOP ENGINE statement
STOP JAVA statement
STOP LOGGING statement [Interactive SQL]
STOP SUBSCRIPTION statement [SQL Remote]
STOP SYNCHRONIZATION DELETE statement [MobiLink]
SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]
SYSTEM statement [Interactive SQL]
TRIGGER EVENT statement
TRUNCATE TABLE statement
UNION statement
UNLOAD statement
UNLOAD TABLE statement
UPDATE statement
UPDATE (positioned) statement [ESQL] [SP]
UPDATE statement [SQL Remote]
VALIDATE statement
WAITFOR statement
WHENEVER statement [ESQL]
WHILE statement [T-SQL]
WINDOW clause
WRITETEXT statement [T-SQL]