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 functions » Function types

System functions

System functions return system information.

List of functions

The following system functions are available:

  • CONNECTION_PROPERTY function [System]
  • DATALENGTH function [System]
  • DB_ID function [System]
  • DB_NAME function [System]
  • DB_EXTENDED_PROPERTY function [System]
  • DB_PROPERTY function [System]
  • EVENT_CONDITION function [System]
  • EVENT_CONDITION_NAME function [System]
  • EVENT_PARAMETER function [System]
  • NEXT_CONNECTION function [System]
  • NEXT_DATABASE function [System]
  • PROPERTY function [System]
  • PROPERTY_DESCRIPTION function [System]
  • PROPERTY_NAME function [System]
  • PROPERTY_NUMBER function [System]
  • SUSER_ID function [System]
  • SUSER_NAME function [System]
  • TSEQUAL function [System] (deprecated)
  • USER_ID function [System]
  • USER_NAME function [System]
  • DB_PROPERTY function [System]
UltraLite functions
  • DB_PROPERTY function [System]
  • ML_GET_SERVER_NOTIFICATION function [System]
  • SYNC_PROFILE_OPTION_VALUE function [System]
SQL Anywhere notes
  • The db_id, db_name, and datalength functions are implemented as built-in functions.

  • Some system functions are implemented as stored procedures.

System functions that are not described elsewhere are noted in the following table. These functions are implemented as stored procedures.

  • Syntax: COL_LENGTH
    COL_LENGTH( @object_name, @column_name )

    Returns the INTEGER defined length of the specified column. @object_name can contain the owner, for example, 'GROUPO.Customers'.

  • Syntax: COL_TERM
    COL_NAME( @object_id, @column_id [, @database_id ] )

    Returns the CHAR(128) column name.

  • Syntax: INDEX_COL
    INDEX_COL ( @table_name, @index_id, @key_# [, @user_id ] )

    Returns the CHAR(128) name of the indexed column. @table_name can contain the owner, for example, 'GROUPO.Customers'.

  • Syntax: OBJECT_ID
    OBJECT_ID( @object_name )

    Returns the INTEGER object ID. @object_name can contain the owner, for example, 'GROUPO.Customers'.

  • Syntax: OBJECT_NAME
    OBJECT_NAME ( @object_id [, @database_id ] )

    Returns the CHAR(128) object name.