Column Properties

Column Object Properties Methods Lists Collections

Property Description

AllowNulls
    Boolean
    Write: Before Add
Determines if the column allows NULL values. If True, the column allows NULL values. If False, NULL values are not allowed in the column.
Application
    Application
    Write: No
The Application object.
DataType
    Identifier
    Write: Before Add
The system or user-defined datatype of the column.
Default
    Identifier
    Write: Yes
The default bound to the column.
DRIDefault
    DRIDefault
    Write: No
The DRIDefault object for this column.
ID
    Long
    Write: No
The column ID and ordinal number in the table.
Identity
    Boolean
    Write: Before Add
Determines if this column has the identity property. If True, this is the single identity column for this table. If False, this column does not have the identity property.
IdentityIncrement
    Long
    Write: Before Add
The value added to the previous identity value to get the next identity value.
IdentitySeed
    Long
    Write: Before Add
The value automatically assigned to the identity column of the first row inserted into the table.
InPrimaryKey
    Boolean
    Write: Before Add
Indicates if this column is part of the primary key for this table. If True, this column is part of the primary key. If False, this column is not part of the primary key.
Length
    Long
    Write: Before Add
The number of bytes used to store a value in this column.
Name
    Identifier
    Write: Yes
The column name.
NumericPrecision
    Long
    Write: Before Add
The precision of an exact numeric datatype column.
NumericScale
    Long
    Write: Before Add
The scale of an exact numeric datatype column.
Parent
    Table
    Write: No
The Table object.
PhysicalDataType
    Identifier
    Write: No
The system datatype that the user-defined datatype is based on.
Rule
    Identifier
    Write: Yes
The rule bound to the column.
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.