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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Function types


System functions

System functions return system information.

List of functions

The following system functions are available:

  • Some of the system functions are implemented in SQL Anywhere as stored procedures.
  • The db_id, db_name, and datalength functions are implemented as built-in functions.

The implemented system functions are described in the following table.

System function Description
col_length( table-name, column-name ) Returns the defined length of column
col_name( table-id, column-id [, database-id ] ) Returns the column name
index_col ( table-name, index-id, key_# [, userid ] ) Returns the name of the indexed column
object_id ( object-name ) Returns the object ID
object_name ( object-id [, database-id ] ) Returns the object name