Release 2.7
Splice Machine SQL Manual
Identifiers
Data Types
- Introduction
- BIGINT
- BLOB
- BOOLEAN
- CHAR
- CLOB
- DATE
- DECIMAL
- DOUBLE
- DOUBLE PRECISION
- FLOAT
- INTEGER
- LONG VARCHAR
- NUMERIC
- REAL
- SMALLINT
- TEXT
- TIME
- TIMESTAMP
- VARCHAR
Statements
Clauses
- Introduction
- CONSTRAINT
- EXCEPT
- FROM
- GROUP BY
- HAVING
- LIMIT n
- ORDER BY
- OVER
- RESULT OFFSET and FETCH FIRST
- TOP n
- UNION
- USING
- WHERE
- WITH
Expressions
Join Operations
Queries
SQL Built-in Functions
- Introduction
- ABS
- ACOS
- ADD_MONTHS
- ASIN
- ATAN
- ATAN2
- AVG
- BIGINT
- CAST
- CEIL
- CHAR
- COALESCE
- Concatenation Operator
- COS
- COSH
- COT
- COUNT
- CURRENT SCHEMA
- CURRENT_DATE
- CURRENT_ROLE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURRENT_USER
- DATE
- DAY
- DEGREES
- DENSE_RANK
- DOUBLE
- EXP
- EXTRACT
- FIRST_VALUE
- FLOOR
- HOUR
- INITCAP
- INSTR
- INTEGER
- LAG
- LAST_DAY
- LAST_VALUE
- LCASE
- LEAD
- LENGTH
- LN (or LOG)
- LOCATE
- LOG10
- LTRIM
- MAX
- MIN
- MINUTE
- MOD
- MONTH
- MONTHNAME
- MONTH_BETWEEN
- NEXT_DAY
- NOW
- NULLIF
- NVL
- PI
- QUARTER
- RADIANS
- RAND
- RANDOM
- RANK
- REGEXP_LIKE
- REPLACE
- ROUND
- ROWID
- ROW_NUMBER
- RTRIM
- SECOND
- SESSION_USER
- SIGN
- SIN
- SINH
- SMALLINT
- SQRT
- STDDEV_POP
- STDDEV_SAMP
- SUBSTR
- SUM
- TAN
- TANH
- TIME
- TIMESTAMP
- TIMESTAMPADD
- TIMESTAMPDIFF
- TO_CHAR
- TO_DATE
- TRIM
- TRUNCATE
- UCASE or UPPER
- USER
- VARCHAR
- WEEK
- YEAR
System Procedures
System Tables
Error Codes

Database Statistics System Procedures and Functions

These are the system procedures and functions for managing database statistics:

Procedure / Function Name	Description
SYSCS_UTIL.COLLECT_SCHEMA_STATISTICS	Collects statistics on a specific schema in your database.
SYSCS_UTIL.DISABLE_COLUMN_STATISTICS	Disables collection of statistics on a specific column in a table.
SYSCS_UTIL.DROP_SCHEMA_STATISTICS	Drops statistics for a specific schema in your database.
SYSCS_UTIL.ENABLE_COLUMN_STATISTICS	Enables collection of statistics on a specific column in a table.