System functions return system information.
List of functionsThe following system functions are available:
NotesSome 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.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |