information_schema.columns.numeric_scale

Note:

For numeric types, the scale (significant digits to the right of the decimal point). NULL if not a numeric field.

Note:

The numeric scale of a number-type column.

Note:

If data_type identifies an exact numeric type, this column contains the (declared or implicit) scale of the type for this column. The scale indicates the number of significant digits to the right of the decimal point. It can be expressed in decimal (base 10) or binary (base 2) terms, as specified in the column numeric_precision_radix. For all other data types, this column is null.

Note:

If data_type identifies an exact numeric type, this column contains the (declared or implicit) scale of the type for this column. The scale indicates the number of significant digits to the right of the decimal point. It can be expressed in decimal (base 10) or binary (base 2) terms, as specified in the column numeric_precision_radix. For all other data types, this column is null.

Note:

If data_type identifies an exact numeric type, this column contains the (declared or implicit) scale of the type for this column. The scale indicates the number of significant digits to the right of the decimal point. It may be expressed in decimal (base 10) or binary (base 2) terms, as specified in the column numeric_precision_radix. For all other data types, this column is null.

Note:

If data_type is an exact numeric type, the scale (i.e., number of digits to the right of the decimal point); otherwise NULL.

Note:

If DATA_TYPE is an exact numeric type, the scale (i.e., number of digits to the right of the decimal point); otherwise NULL.

Note:

Scale of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, NULL is returned.