information_schema.attributes.numeric_scale

mysql

mariadb

tidb

postgres

type: CARDINAL_NUMBER NULL
Note:
If data_type identifies an exact numeric type, this column contains the (declared or implicit) scale of the type for this attribute. 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.
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CARDINAL_NUMBER
Note:
If data_type identifies an exact numeric type, this column contains the (declared or implicit) scale of the type for this attribute. 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.
© 1996-2022 The PostgreSQL Global Development Group
8.3-9.6
Note:
If data_type identifies an exact numeric type, this column contains the (declared or implicit) scale of the type for this attribute. 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.
© 1996-2022 The PostgreSQL Global Development Group
8.2

cockroachdb

mssql