SQL statements (A-D)

The following sections define the syntax information for SQL statements A-D.

See also

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 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 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 statement
BEGIN SNAPSHOT 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 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
CREATE FUNCTION statement (external procedures)
CREATE FUNCTION statement (web services)
CREATE INDEX statement
CREATE LOCAL TEMPORARY TABLE statement
CREATE LOGIN POLICY statement
CREATE MATERIALIZED VIEW statement
CREATE MESSAGE statement [T-SQL]
CREATE PROCEDURE statement
CREATE PROCEDURE statement [T-SQL]
CREATE PROCEDURE statement (external procedures)
CREATE PROCEDURE statement (web services)
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 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 VARIABLE statement
CREATE USER 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 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 PROCEDURE 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 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