SQL statement syntax

You’ve come to the right place if you are looking for reference material on specific SQL statement syntax! If you want in-depth training on using advanced SQL statements and more, check out our advanced SQL video training. It covers topics such as: advanced aggregations window functions using JSON array and map functions

View the training

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 FUNCTION
• CREATE MATERIALIZED VIEW
• CREATE ROLE
• CREATE SCHEMA
• CREATE TABLE
• CREATE TABLE AS
• CREATE VIEW
• DEALLOCATE PREPARE
• DELETE
• DENY
• DESCRIBE
• DESCRIBE INPUT
• DESCRIBE OUTPUT
• DROP FUNCTION
• DROP MATERIALIZED VIEW
• DROP ROLE
• DROP SCHEMA
• DROP TABLE
• DROP VIEW
• EXECUTE
• EXECUTE IMMEDIATE
• EXPLAIN
• EXPLAIN ANALYZE

Statements G-R

• GRANT privilege
• GRANT role
• INSERT
• MATCH_RECOGNIZE
• MERGE
• Row pattern recognition in window structures
• PREPARE
• REFRESH MATERIALIZED VIEW
• RESET SESSION
• RESET SESSION AUTHORIZATION
• REVOKE privilege
• REVOKE role
• ROLLBACK

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
• SET SESSION AUTHORIZATION
• SHOW STATS
• SHOW TABLES
• START TRANSACTION
• TRUNCATE
• UPDATE
• USE
• VALUES