SQL Reference Guide > SQL Reference Guide > SQL Statements
Was this helpful?
SQL Statements
 
Context for SQL Statements
Statements for Ingres Star
ALTER GROUP
ALTER LOCATION
ALTER PROFILE
ALTER ROLE
ALTER SECURITY_AUDIT
ALTER SEQUENCE
ALTER TABLE
ALTER USER
ALTER WLM
BEGIN DECLARE
CALL
CALL X100 (X100 Only)
CLOSE
COMMENT ON
COMMIT
CONNECT
CONTINUE
COPY
COPY FROM | INTO PROGRAM
COPY STATISTICS
COPY VWLOAD (X100 Only)
CREATE DBEVENT
CREATE EXTERNAL TABLE (X100 Only)
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE INTEGRITY
CREATE LOCATION
CREATE PROCEDURE
CREATE PROFILE
CREATE ROLE
CREATE RULE
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 STATEMENT
DECLARE TABLE
DELETE
DESCRIBE
DESCRIBE INPUT
DISABLE PASSPHRASE (X100 Only)
DISABLE SECURITY_AUDIT
DISCONNECT
DROP
DROP DBEVENT
DROP FUNCTION
DROP GROUP
DROP INTEGRITY
DROP LOCATION
DROP PERMIT ON SEQUENCE
DROP PROCEDURE
DROP PROFILE
DROP ROLE
DROP RULE
DROP SCHEMA
DROP SECURITY_ALARM
DROP SEQUENCE
DROP STATISTICS
DROP SYNONYM
DROP USER
ENABLE PASSPHRASE (X100 Only)
ENABLE SECURITY_AUDIT
ENDDATA
END DECLARE SECTION
ENDLOOP
ENDSELECT
EXECUTE
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
FETCH
FOR - ENDFOR
GET DATA
GET DBEVENT
GOTO
GRANT (privilege)
GRANT (role)
HELP
IF - THEN - ELSE
INCLUDE
INQUIRE_SQL
INSERT
INSERT INTO EXTERNAL CSV (X100 Only)
MERGE
MESSAGE
MODIFY
OPEN
PREPARE
PREPARE TO COMMIT
PUT DATA
RAISE DBEVENT
RAISE ERROR
REGISTER DBEVENT
REGISTER TABLE
REMOVE DBEVENT
REMOVE TABLE
RENAME TABLE
REPEAT - ENDREPEAT
RETURN
RETURN ROW
REVOKE
ROLLBACK
SAVE
SAVEPOINT
SELECT (interactive)
SELECT (embedded)
SET
SET_SQL
TRUNCATE TABLE
UPDATE
WHENEVER
WHILE - ENDWHILE
WITH (common_table_expression)
This chapter lists Actian X SQL statements in alphabetical order.
Last modified date: 08/14/2024