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

This section describes the syntax for SQL statements that can be executed in SEP.

Refer to the following sections for further details:

• SQL data types and other general aspects

• SQL functions and operators

• ALTER CATALOG
• ALTER MATERIALIZED VIEW
• ALTER SCHEMA
• ALTER TABLE
• ALTER VIEW
• ANALYZE
• CALL
• COMMENT
• COMMIT
• CREATE CATALOG
• 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 CATALOG
• DROP FUNCTION
• DROP MATERIALIZED VIEW
• DROP ROLE
• DROP SCHEMA
• DROP TABLE
• DROP VIEW
• EXECUTE
• EXECUTE IMMEDIATE
• EXPLAIN
• EXPLAIN ANALYZE
• GRANT privilege
• GRANT role
• INSERT
• MATCH_RECOGNIZE
• MERGE
• PREPARE
• REFRESH MATERIALIZED VIEW
• RESET SESSION
• RESET SESSION AUTHORIZATION
• REVOKE privilege
• REVOKE role
• ROLLBACK
• SELECT
• SET PATH
• SET ROLE
• SET SESSION
• SET SESSION AUTHORIZATION
• SET TIME ZONE
• SHOW CATALOGS
• SHOW COLUMNS
• SHOW CREATE FUNCTION
• 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