SQL Language Guide
>
SQL Statements
Was this helpful?
SQL Statements
Statement Contexts (Valid in)
ALTER GROUP
ALTER PROFILE
ALTER ROLE
ALTER SEQUENCE
ALTER TABLE
ALTER USER
CLOSE
COMMENT ON
COMMIT
CONNECT
CONTINUE
COPY VWLOAD
CREATE DBEVENT
CREATE EXTERNAL TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE PROCEDURE
CREATE PROFILE
CREATE ROLE
CREATE SCHEMA
CREATE SECURITY_ALARM
CREATE SEQUENCE
CREATE STATISTICS
CREATE SYNONYM
CREATE TABLE
CREATE USER
CREATE VIEW
DECLARE
DECLARE CURSOR
DECLARE GLOBAL TEMPORARY TABLE
DECLARE TABLE
DELETE
DESCRIBE
DESCRIBE INPUT
DISCONNECT
DROP
DROP DBEVENT
DROP FUNCTION
DROP GROUP
DROP PROCEDURE
DROP PROFILE
DROP ROLE
DROP SCHEMA
DROP SECURITY_ALARM
DROP SEQUENCE
DROP STATISTICS
DROP SYNONYM
DROP USER
ENDLOOP
ENDSELECT
EXECUTE
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
FETCH
FOR - ENDFOR
GET DBEVENT
GRANT (privilege)
GRANT (role)
HELP
IF - THEN - ELSE
INCLUDE
INQUIRE_SQL
INSERT
INSERT INTO EXTERNAL CSV
MERGE
MESSAGE
MODIFY
OPEN
PREPARE
RAISE DBEVENT
RAISE ERROR
REGISTER DBEVENT
REMOVE DBEVENT
RENAME TABLE
REPEAT - ENDREPEAT
RETURN
RETURN ROW
REVOKE
ROLLBACK
SELECT (Interactive)
SELECT (Embedded)
SET
TRUNCATE TABLE
UPDATE
WHENEVER
WHILE - ENDWHILE
WITH (common_table_expression)
This section lists Actian Data Platform SQL statements in alphabetical order.
For an explanation of how SQL statement syntax is represented, see
SQL Syntax Conventions
.
For the list of contexts that specific SQL statements are valid in, see
Statement Contexts (Valid in)
.
Last modified date: 10/30/2024
This site works best with JavaScript enabled