Small company logo:
   History
 
Advertising banner:
 
 Column.Scale
Home • Help • Customization Tools • FCAS • Language Reference • Column.Scale
 
Purpose
Returns the maximum number of digits to the right of the decimal point for the column.
This attribute is read only at runtime.


Data type
Notes on the value returned
approximate floating point number columns or parameters
The scale is undefined, because the number of digits to the right of the decimal point is not fixed.
datetime or interval data that contains a seconds component
The decimal digits are defined as the number of digits to the right of the decimal point in the seconds component of the data.
SQL_DECIMAL and SQL_NUMERIC
The maximum scale is generally the same as the maximum precision, although some data sources impose a separate limit on the maximum scale.

Syntax
Table.Column (ColumnID).Scale