You can obtain a list of option settings, or the values of individual options, in a variety of ways.
Current option settings for your connection are available as a subset of connection properties. You can list all connection properties using the sa_conn_properties system procedure.
To order this list alphabetically, you can execute the following statement:
SELECT * FROM sa_conn_properties() ORDER BY PropName;
If you want to filter the result or order by anything other than name, you could also use a SELECT statement. For example:
SELECT * FROM sa_conn_properties() WHERE PropDescription LIKE '%cache%' ORDER BY PropNum;
In Interactive SQL, the SET statement with no arguments lists the current setting of options.
In Sybase Central, select a database, and then choose File > Options.
Use the following query on the SYSOPTIONS system view:
SELECT * FROM SYSOPTIONS;
This displays all PUBLIC values, and those USER values that have been explicitly set.
You can obtain a single setting using the CONNECTION_PROPERTY system function. For example, the following statement reports the value of the ansi_integer_overflow option:
SELECT CONNECTION_PROPERTY ('ansi_integer_overflow');
See CONNECTION_PROPERTY function [System].