System functions

The following system functions are available:

• CONNECTION_EXTENDED_PROPERTY function [String]
• 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]

• DB_PROPERTY function [System]
• ML_GET_SERVER_NOTIFICATION function [System]
• SYNC_PROFILE_OPTION_VALUE function [System]

• 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.