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
CLOSE
COMMENT ON
COMMIT
CONNECT
CONTINUE
COPY
COPY FROM | INTO PROGRAM
CREATE DBEVENT
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 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 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
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 Option
SET_SQL
TRUNCATE TABLE
UPDATE
WHENEVER
WHILE - ENDWHILE
WITH (common_table_expression)
This chapter lists Ingres SQL statements in alphabetical order.
Last modified date: 08/28/2024
This site works best with JavaScript enabled