Data Type Metadata

SYS.DataTypes

This table supplies information on data types.

Column Name	Type	Description
`Name`	string	CData Virtuality Server design-time type name
`IsStandard`	boolean	Always `FALSE`
`IsPhysical`	boolean	Always `FALSE`
`TypeName`	string	Design-time type name (same as `Name`)
`JavaClass`	string	Java class returned for this type
`Scale`	integer	Maximum scale of this type
`TypeLength`	integer	Maximum length of this type
`NullType`	string	Nullability: "`Nullable`", "`No Nulls`", "`Unknown`"
`IsSigned`	boolean	Whether it Is signed numeric
`IsAutoIncremented`	boolean	Whether it is auto-incremented
`IsCaseSensitive`	boolean	Whether it is case-sensitive
`Precision`	integer	Maximum precision of this type
`Radix`	integer	Radix of this type
`SearchType`	string	Searchability: "`Searchable`", "`All Except Like`", "`Like Only`", "`Unsearchable`"
`UID`	string	Data type unique ID
`RuntimeType`	string	CData Virtuality Server runtime data type name
`BaseType`	string	Base type
`Description`	string	Description of type
`OID`	integer	Unique ID*

* The OID column is guaranteed to be unique/consistent unsafe-only for the given version running instance of a VDB. If a different version of the VDB is deployed, these IDs are not guaranteed to be the same or unique across both versions of the VDB. Dynamic VDB OIDs are not cluster-safe.