System functions

System functions return system information.

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

Discuss this page in DocCommentXchange.