To list all current system-defined option settings, call the sa_conn_options system procedure.

CALL sa_conn_options;

To order this list alphabetically, execute the following statement:

SELECT * 
FROM sa_conn_options( )
ORDER BY OptionName;

To filter the result or order by anything other than name, use a WHERE clause. For example:

SELECT * 
FROM sa_conn_options( )
WHERE OptionDescription LIKE '%date%'
ORDER BY PropNum;

See sa_conn_options system procedure.

Current system-defined option settings for your connection are also available as a subset of connection properties. You can list all connection properties using the sa_conn_properties system procedure.

CALL sa_conn_properties;

To order this list alphabetically, you can execute the following statement:

SELECT * 
FROM sa_conn_properties( )
ORDER BY PropName;

See sa_conn_properties system procedure.

The results of the sa_conn_options and sa_conn_properties system procedures include connection-level settings for system-defined options which override user or PUBLIC settings.

For user-defined options, their values are not returned by either the sa_conn_options or sa_conn_properties system procedures. You can instead query the SYSOPTION or SYSOPTIONS catalog views directly in order to determine the value of a specific user-defined option. The following query on the SYSOPTIONS system view displays all public-level and user-level settings for all system- and user-defined options that have been permanently set:

SELECT *
FROM SYSOPTIONS;

Temporarily setting a server-defined option for a specific connection using the SET TEMPORARY OPTION statement does not cause the SYSOPTION (or SYSOPTIONS) system view to be updated. Temporary changes to option settings at the connection level are held only in server memory. To determine the current setting for a system-defined option, you should use the sa_conn_options or sa_conn_properties system procedures, the CONNECTION_PROPERTY function, or (in embedded SQL) the GET OPTION statement.

In Interactive SQL, the SET statement with no arguments lists the current setting of system-defined connection, database, and Interactive SQL options.

SET;

In Sybase Central, select a database, and then click File » Options.