ARRAY_MAX_CARDINALITY( array-expression )

INTEGER

The cardinality of the collection is the number of elements in the collection.

For an unbounded array, ARRAY_MAX_CARDINALITY returns the maximum size limit of an array supported by SQL Anywhere. For a bounded array or an array composed via a constructor, ARRAY_MAX_CARDINALITY returns the maximum explicitly or implicitly declared size of the array.

• ARRAY_AGG function [Aggregate]
• CARDINALITY function [Composite]
• TRIM_ARRAY function [Composite]