SQL Anywhere® Server - Database Administration  > Database Options  > Introduction to database options

Finding option settings

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.

  CALL sa_conn_properties;

  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;

  See sa_conn_properties system procedure.

• In Interactive SQL, the SET statement with no arguments lists the current setting of options.

  SET;

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