Show Table of Contents
8.7. Data Type Metadata
- SYS.DataTypes
- This table supplies information on data types. See Section 3.1, “Supported Types”.Column NameTypeDescriptionNamestringJBoss Data Virtualization design-time type nameIsStandardbooleanAlways falseIsPhysicalbooleanAlways falseTypeNamestringDesign-time type name (same as Name)JavaClassstringJava class returned for this typeScaleintegerMax scale of this typeTypeLengthintegerMax length of this typeNullTypestringNullability: "Nullable", "No Nulls", "Unknown"IsSignedbooleanIs signed numeric?IsAutoIncrementedbooleanIs auto-incremented?IsCaseSensitivebooleanIs case-sensitive?PrecisionintegerMax precision of this typeRadixintegerRadix of this typeSearchTypestringSearchability: "Searchable", "All Except Like", "Like Only", "Unsearchable"UIDstringData type unique IDOIDintegerUnique IDRuntimeTypestringJBoss Data Virtualization runtime data type nameBaseTypestringBase typeDescriptionstringDescription of type
Warning
The OID column is no longer used on system tables. Use UID instead.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.