Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements

Common elements in SQL syntax

Learn about language elements that are found in the syntax of many SQL statements.

  • column-name

    An identifier that represents the name of a column.

  • condition

    An expression that evaluates to TRUE, FALSE, or UNKNOWN.

  • connection-name

    A string representing the name of an active connection.

  • data-type

    A storage data type.

  • expression

    An expression. A common example of an expression in syntax is a column name.

  • filename

    A string containing a file name.

  • hostvar

    A C language variable, declared as a host variable preceded by a colon.

  • materialized-view-name

    An identifier that represents the name of a materialized view.

  • number

    Any sequence of digits followed by an optional decimal part and preceded by an optional negative sign. Optionally, the number can be followed by an E and then an exponent. For example:

  • owner

    An identifier representing the user ID who owns a database object.

  • query-block

    A query block is a simple query expression, or a query expression with an ORDER BY clause.

  • query-expression

    A query expression can be a SELECT, UNION, INTERSECT, or EXCEPT block (that is, a statement that does not contain an ORDER BY, WITH, FOR, FOR XML, or OPTION clause), or any combination of such blocks.

  • role-name

    An identifier representing the role name of a foreign key. In conceptual database modeling, a verb or phrase that describes a relationship from one point of view. You can describe each relationship with two roles. Examples of roles are "contains" and "is a member of."

  • savepoint-name

    An identifier that represents the name of a savepoint.

  • search-condition

    A condition that evaluates to TRUE, FALSE, or UNKNOWN.

  • special-value

    A special value.

  • statement-label

    An identifier that represents the label of a loop or compound statement.

  • statement-list

    A list of SQL statements, each ending with a semicolon.

  • string-expression

    An expression that resolves to a string.

  • table-list

    A list of table names, which may include correlation names.

  • table-name

    An identifier that represents the name of a table.

  • userid

    An identifier representing a user name.

  • variable-name

    An identifier that represents a variable name.

  • window-name

    An identifier that represents a window name. Used in syntax related to window definition (for example, the WINDOW clause, and window functions such as RANK).