UserDefinedDatatype Properties

UserDefinedDatatype Object Properties Methods Lists Collections

Property Description

AllowIdentity
    Boolean
    Write: No
Indicates if the system datatype can be used as an identity column. If True, a column of this datatype can have the identity property. If False, a column of this datatype cannot have the identity property.
AllowNulls
    Boolean
    Write: Before Add
Determines if the user defined datatype accepts NULL values. If True, the user defined datatype allows NULL values. If False, NULL values are not allowed.
Application
    Application
    Write: No
The Application object.
BaseType
    Identifier
    Write: Before Add
The system datatype this user defined datatype is based on. To set this property to a new default, the default must exist.
Default
    Identifier
    Write: Yes
The default that is currently bound to this datatype.
ID
    Long
    Write: No
The type ID from sysobjects.usertype.
Length
    Long
    Write: Before Add
The number of bytes used to store a value of this datadatatype.
Name
    Identifier
    Write: Yes
The name of the user defined datatype.
NumericPrecision
    Long
    Write: Before Add
The precision of an exact numeric datatype.
NumericScale
    Long
    Write: Before Add
The scale of an exact numeric datatype.
Owner
    Identifier
    Write: NO
The user who created this user defined datatype.
Parent
    Database
    Write: No
The Database object.
Rule
    Identifier
    Write: Yes
The rule currently bound to this user defined datatype. To set this property to a new rule, the rule must exist.
TypeOf
    SQLOLE_OBJECT_TYPE
    Write: No
The type of object.
UserData
    Long
    Write: Yes
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property.