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. |