Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Alphabetical list of functions


PROPERTY_NUMBER function [System]

Returns the property number of the property with the supplied property-name.

PROPERTY_NUMBER( property-name )
  • property-name   A property name.


Each property has both a number and a name, but the number is subject to change between releases, and should not be used as a reliable identifier for a given property. In cases where either property number or property name can be used, it is preferable to use the property name. Always use the PROPERTY_NUMBER function to ensure that the property number is current for the server being used.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.


The following statement returns an integer value. The actual value changes from release to release.