SQL Commands

Command NameDescription

The SELECT statement is used to select data from a database. Spice supports querying using standard SELECT statements.

The USE command enables you to specify the context to be used for the current query session.

The SHOW command can query for the existence of SQL tables with certain pattern matching.

The DESCRIBE TABLE command is used to provide high-level information regarding the overall column properties of an existing dataset.

The WITH clause defines a common table expression (CTE), which is a temporary named result set. The definition of a CTE includes its name, an optional list of column names, and a query expression (that is, a SELECT statement).

Last updated