SQL statement syntax#
Statement listing#
This chapter describes the SQL syntax used in SEP. A reference to the supported SQL data types is available. SEP also provides numerous SQL functions and operators.
Statements A-F#
- ALTER MATERIALIZED VIEW
- ALTER SCHEMA
- ALTER TABLE
- ALTER VIEW
- ANALYZE
- CALL
- COMMENT
- COMMIT
- CREATE MATERIALIZED VIEW
- CREATE ROLE
- CREATE SCHEMA
- CREATE TABLE
- CREATE TABLE AS
- CREATE VIEW
- DEALLOCATE PREPARE
- DELETE
- DENY
- DESCRIBE
- DESCRIBE INPUT
- DESCRIBE OUTPUT
- DROP MATERIALIZED VIEW
- DROP ROLE
- DROP SCHEMA
- DROP TABLE
- DROP VIEW
Statements G-R#
Statements S-Z#
- SELECT
- SET PATH
- SET ROLE
- SET SESSION
- SET TIME ZONE
- SHOW CATALOGS
- SHOW COLUMNS
- SHOW CREATE MATERIALIZED VIEW
- SHOW CREATE SCHEMA
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW FUNCTIONS
- SHOW GRANTS
- SHOW ROLE GRANTS
- SHOW ROLES
- SHOW SCHEMAS
- SHOW SESSION
- SHOW STATS
- SHOW TABLES
- START TRANSACTION
- TRUNCATE
- UPDATE
- USE
- VALUES