<<enumeration>> PrimitiveType {Analysis}

Documentation
4.1 Data types

A data type is a set of representable values. Every representable value belongs to at least one data type and some belong to several data types. [...]

Every predefined data type is a subtype of itself and of no other data types. It follows that every predefined data type is a supertype of itself and of no other data types. The predefined data types are individually described in each of Subclause 4.2, "Character strings", through Subclause 4.6, "Datetimes and intervals". Row types, reference types and collection types are described in Subclause 4.8, "Row types", Subclause 4.9, "Reference types", Subclause 4.10, "Collection types", respectively.

SQL defines predefined data types named by the following <key word> s: CHARACTER , CHARACTER VARYING , CHARACTER LARGE OBJECT , BINARY LARGE OBJECT , NUMERIC , DECIMAL , SMALLINT , INTEGER , BIGINT , FLOAT , REAL , DOUBLE PRECISION , BOOLEAN , DATE , TIME , TIMESTAMP , and INTERVAL . These names are used in the type designators that constitute the type precedence lists specified in Subclause 9.5, "Type precedence list determination".


Parent PackageDataTypesAbstractNo
Export ControlPublicAccessLink Class forNone
Class KindNormalClassCardinalityn
Space ConcurrencySequential
PersistenceNo  


Attributes
NameClassTypeInitial Value
CHARACTERPrimitiveTypeint 
CHARACTER_VARYINGPrimitiveTypeint 
CHARACTER_LARGE_OBJECTPrimitiveTypeint 
NATIONAL_CHARACTERPrimitiveTypeint 
NATIONAL_CHARACTER_VARYINGPrimitiveTypeint 
NATIONAL_CHARACTER_LARGE_OBJECTPrimitiveTypeint 
BINARY_LARGE_OBJECTPrimitiveTypeint 
NUMERICPrimitiveTypeint 
DECIMALPrimitiveTypeint 
SMALLINTPrimitiveTypeint 
INTEGERPrimitiveTypeint 
FLOATPrimitiveTypeint 
REALPrimitiveTypeint 
DOUBLE_PRECISIONPrimitiveTypeint 
BOOLEANPrimitiveTypeint 
DATEPrimitiveTypeint 
TIMEPrimitiveTypeint 
TIMESTAMPPrimitiveTypeint 
INTERVALPrimitiveTypeint 
DATALINKPrimitiveTypeint 



Property Settings

Data Modeler
dmItemFalseDMName 
IsTableFalseIsViewFalse
IsDomainFalseIsSPPackageFalse
Synonymns TableSpaceID 
SourceId SourceType 
CorrelationName SelectClause 
IsUpdateableTrueCheckOptionNone
IsSnapShotFalseIsDistinctFalse
PersistToServer IsPackageFalse