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
BEGIN DECLARE
CALL
CALL X100 (X100 Only)
CLOSE
COMMENT ON
COMMIT
CONNECT
COPY
COPY FROM | INTO PROGRAM
COPY VWLOAD (X100 Only)
CREATE DBEVENT
CREATE GROUP
CREATE INDEX
CREATE INTEGRITY
CREATE LOCATION
CREATE PROCEDURE
CREATE PROFILE
CREATE ROLE
CREATE RULE
CREATE SCHEMA
CREATE SECURITY_ALARM
CREATE SEQUENCE
CREATE SYNONYM
CREATE TABLE
CREATE USER
CREATE VIEW
DECLARE
DECLARE CURSOR
DECLARE GLOBAL TEMPORARY TABLE
DECLARE STATEMENT
DECLARE TABLE
DELETE
DESCRIBE
DESCRIBE INPUT
DISABLE SECURITY_AUDIT
DISCONNECT
DROP
DROP DBEVENT
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 SYNONYM
DROP USER
ENABLE SECURITY_AUDIT
ENDDATA
END DECLARE SECTION
ENDSELECT
EXECUTE
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
FETCH
FOR - ENDFOR
GET DATA
GET DBEVENT
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
UPDATE
WHENEVER
WHILE - ENDWHILE
WITH (common_table_expression)
This chapter lists Ingres SQL statements in alphabetical order.
Last modified date: 01/30/2023