SYSUNITOFMEASURE system view

Each row of the SYSUNITOFMEASURE system view describes a unit of measure defined in the database. The underlying table for the SYSUNITOFMEASURE system view is the ISYSUNITOFMEASURE system table.

Column name	Data type	Description
object_id	UNSIGNED BIGINT	For system use only.
owner	UNSIGNED INT	The owner of the unit of measure.
unit_name	CHAR(128)	The name of the unit of measure.
unit_type	CHAR(7)	Angular or linear.
conversion_factor	DOUBLE	The conversion factor for the unit of measure.

Constraints on underlying system table

PRIMARY KEY (object_id)

FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id)

FOREIGN KEY (owner) references SYS.ISYSUSER (user_id)

UNIQUE constraint (unit_name)

Discuss this page in DocCommentXchange.