| Property | Description |
|---|
| AllocatedWidth | This property returns Returns the allocated width of a column. DATATYPE: Integer. |
| AttributeName | Logical attribute name. DATATYPE: String. |
| AverageWidth | Average width of a column. This property applies only to physical models. DATATYPE: Integer. |
| Cache | Cache property for the column. DATATYPE: Integer. |
| CharacterSet | Interbase 2007 and later and Teradata V2R5 and later only. Specifies the character set for a CHAR, VARCHAR, and BLOB (Interbase) / CLOB (Teradata) column. DATATYPE: String. |
| CharUsed | CharUsed property for the column. DATATYPE: Boolean. |
| CheckConstraint | Check constraint of the attribute, if any. DATATYPE: String. |
| CheckConstraintName | Name of the Attribute's Check Constraint. DATATYPE: String. |
| Collate | Collate property for the column. DATATYPE: String. |
| Color | Color of the Attribute object. It takes a 4-byte integer, where the first byte represents red value (0-255), the second byte represents green value (0-255), and the third byte represents blue value (0-255). |
| ColumnName | Physical column name. DATATYPE: String. |
| Compact | Compact property for the column. DATATYPE: Boolean. |
| CompositeDatatype | Attribute's full datatype, including nullability. DATATYPE: String. |
| Compress | Teradata models only. Compress property for the column. DATATYPE: String. |
| Computation | Interbase 2007 and later and SQL server 7.x and later only. Computation property for columns that are computed. DATATYPE: String. |
| Cycle | Cycle property for the column. DATATYPE: Boolean. |
| DataLength | Data length of the datatype, if any. DATATYPE: Integer. |
| DataScale | Data scale of the datatype, if any. DATATYPE: Integer. |
| Datatype | Datatype. Note that you can assign user-defined datatypes in the UserDatatypeId property. DATATYPE: String. |
| DeclaredDefault | Default constraint for the attribute, if any. DATATYPE: String. |
| DefaultId | ID of the bounded default object, if any. A user can bind a default object to the attribute by assigning a particular default ID to this property. DATATYPE: Integer. |
| DefaultName | Name of the Attribute's default constraint. DATATYPE: String. |
| Definition | Definition of the attribute. DATATYPE: String. |
| DomainId | ID of the bounded, domain object, if any. This ID is used by ER/Studio. A user can bind a domain object to the attribute by assigning a particular domain ID to this property. DATATYPE: Integer. |
| Encrypted | Oracle 10.2 and later and Sybase ASE 12.5.3 and later only. Indicates whether a column is encrypted. DATATYPE: Boolean. |
| EncryptionAlgorithm | Oracle 10.2 and later only. Specifies the algorithm used for the column encryption. DATATYPE: String. |
| EncryptionKey | Sybase ASE 12.5.3 and later only. Specifies the encryption keys used to encrypt the column. DATATYPE: String. |
| EncryptionSALT | Oracle 10.2 and later only. Indicates whether a column is encrypted with SALT. DATATYPE: Boolean. |
| EnumOrSetValues | EnumOrSetValues property for columns that have either Enum or Ser as column data type. DATATYPE: String. |
| Font | Font for the attribute. Although this property is read only, the user can modify the font by setting the properties in the ERSFont object which is returned to the caller. |
| ForBitData | ForBitData property for the column. DATATYPE: Boolean. |
| ForeignKey | Indicates whether the attribute is a foreign key. DATATYPE: Boolean. |
| Format | Teradata models only. Format property for the column. DATATYPE: String. |
| FreezeName | True if this attribute is not affected by naming standards name updates. DATATYPE: Boolean. |
| GenerateByDefault | GenerateByDefault property for the column. DATATYPE: Boolean. |
| GenerationExpression | DB2 UDB version 8 and later only. Specifies how to generate the column. DATATYPE: String. |
| GUID | GUID of the attribute as assigned by ER/Studio. Each attribute has a unique GUID. DATATYPE: String. |
| HasLogicalRoleName | Indicates whether the foreign key column has a logical rolename. DATATYPE: Boolean. |
| HasRoleName | Indicates whether the foreign key column is rolenamed. DATATYPE: Boolean. |
| Heading | DB2 AS/400 Heading for the column. DATATYPE: String. |
| Hidden | Indicating that an Attribute is hidden in the Diagram display. Only applies to PK and FK attributes/columns. DATATYPE: Boolean. |
| HiveColumnPartition | Specifies whether the column is a Hive Partitioning Column. DATATYPE: Boolean |
| HiveComplexType | Specifies the Hive column's Complex datatype. DATATYPE: String |
| ID | ID of the attribute as assigned by ER/Studio. Each attribute in a diagram has a unique ID. DATATYPE: Integer. |
| Identity | Identity property of the attribute. DATATYPE: Boolean. |
| IdentityIncrement | Identity increment value of the attribute. DATATYPE: Integer. |
| IdentitySeed | Identity seed value of the attribute. DATATYPE: Integer. |
| InterModelID | InterModelID of the object as assigned by ER/Studio. DATATYPE: Integer. |
| IntervalYearToMonth | IntervalYearToMonth property for the column. DATATYPE: Boolean. |
| IsCaseSpecific | Teradata V2R5 and later only. True if this column is case specific. It applies only to CHAR and VARCHAR data types. DATATYPE: Boolean. |
| IsComputed | Interbase 2007 and later and SQL server 7.x and later only. Returns true if the column is computed (if there is a value specified for the Computation property), false otherwise. DATATYPE: Boolean. |
| IsFileStream | SQL Server 2008 and later only. True if this column has FILESTREAM property set. It applies only to VARBINARY(MAX) data type. DATATYPE: Boolean. |
| IsGenerated | DB2 UDB 8 and later only. True if the column is generated with an expression. DATATYPE: Boolean. |
| IsSparse | True if this is a sparse column. DATATYPE: Boolean. |
| IsVirtual | True if this column is an Oracle (11g or higher) virtual column, i.e. a computed column. A column is virtual if it has a VirtualColumnExpression set. Read-Only. DATATYPE: Boolean |
| IsWithTimeZone | True if this column has WITH TIME ZONE property set. It applies only to TIME and TIMESTAMP data types in Teradata all versions. DATATYPE: Boolean. |
| IsXMLDocument | SQL server 2005 and later only. Returns true if the column has datatype XML and is flagged as document. DATATYPE: Boolean. |
| LOBUnit | Unit used for the LOB size. The value can be empty, "K", "M", or "G". DATATYPE: String. |
| LocalTimeZone | LocalTimeZone property for the column. DATATYPE: Boolean. |
| LogicalRoleName | Logical Rolename. DATATYPE: String. |
| LogOrPhysOnly | Controls the logical | attribute name/physical only Attribute Property. DATATYPE: Boolean. |
| MaxValue | MaxValue property for the column. DATATYPE: Integer. |
| MinValue | MinValue property for the column. DATATYPE: Integer. |
| MongoDBArray | Indicates whether the Column is a MongoDB array. DATATYPE: Boolean |
| NamingStandardsTemplateId | ID of the NamingStandardsTemplate object bound to the attribute (if any). A user can bind a NamingStandardsTemplate to the attribute by assigning a particular NamingStandardsTemplateId to this property. DATATYPE: Integer. |
| Notes | Notes property of the attribute. DATATYPE: String. |
| NotForReplication | SQL Server 2000 and later only. Specifies whether an identity column constraint is for replication. DATATYPE: Boolean. |
| NotLogged | NotLogged property for the column. DATATYPE: Boolean. |
| NullOption | Nullability of the attribute. The possible values are: 'NULL' or 'NOT NULL'. DATATYPE: String. |
| OracleNotNullConstraintName | Oracle 8 and later only. Specifies the Not Null constraint of the column. DATATYPE: String |
| PercentNull | Percentage of nulls of a column in a table. This property applies only to physical models. DATATYPE: Integer. |
| Persisted | SQL Server 2005 and later only. Specifies whether a computed column is persisted. DATATYPE: Boolean. |
| PhysicalDatatype | Physical datatype of the attribute. DATATYPE: String. |
| PrimaryKey | Indicates whether the attribute is a primary key. DATATYPE: Boolean. |
| ReferenceValueId | ID of the ReferenceValue object bound to the attribute, if any. A user can bind a ReferenceValue to the attribute by assigning a particular ReferenceValueId to this property. DATATYPE: Integer. |
| RoleName | Role name of the attribute. DATATYPE: String. |
| RowGuidColumn | RowGuidColumn property for the column. DATATYPE: Boolean. |
| RuleId | ID of the bounded rule object, if any. A user can bind a rule object to the attribute by assigning a particular rule ID to this property. DATATYPE: Integer. |
| SequenceNumber | Sequence number of the attribute. DATATYPE: Integer. |
| ShowLength | Indicates whether the datatype length is used (true) or not (false). DATATYPE: Boolean. |
| ShowScale | Indicates whether the datatype scale is used (true) or not (false). DATATYPE: Boolean. |
| ShowVirtualColumnDatatype | Oracle 11g and later only. Specifies whether the data type of an Oracle virtual column is manually set (true) or automatically determined by the database (false). DATATYPE: Boolean. |
| SourceDirectTransformationDescription | Source direct transformation description property for the column. This property applies only to physical models. DATATYPE: String. |
| SourceDirectTransformationLogic | Source direct transformation logic property for the column. This property applies only to physical models. DATATYPE: String. |
| SourceSecondaryTransformationDescription | Source secondary transformation description property for the column. This property applies only to physical models. DATATYPE: String. |
| SourceSecondaryTransformationLogic | Source secondary transformation logic property for the column. This property applies only to physical models. DATATYPE: String. |
| SystemName | DB2 AS/400 SystemName for the column. DATATYPE: String. |
| TargetDirectTransformationDescription | Target direct transformation description property for the column. This property applies only to physical models. DATATYPE: String. |
| TargetDirectTransformationLogic | Target direct transformation logic property for the column. This property applies only to physical models. DATATYPE: String. |
| TargetSecondaryTransformationDescription | Target secondary transformation description property for the column. | AverageWidth | This is the average width of a column. This property applies only to physical models. DATATYPE: String. |
| TargetSecondaryTransformationLogic | Target secondary transformation logic property for the column. This property applies only to physical models. DATATYPE: String. |
| TeradataCollectStatistics | Teradata V12 and later only. Specifies whether the collect statistics option of the column is on. DATATYPE: Boolean. |
| TeradataIntervalStr | Teradata V13 and later only. Specifies the interval string for a column with INTERVAL datatype. DATATYPE: String. |
| TeradataPeriod | Teradata V13 and later only. Specifies whether the column has PERIOD datatype. It only applies to columns that have datatype as TIME, TIMESTAMP and DATE. DATATYPE: Boolean |
| TeradataUsingSample | Teradata V12 and later only. Specifies whether the using sample option of the column is on. The collect statistics option must be on before this option can be set. DATATYPE: Boolean. |
| TextLabel | DB2 AS/400 TextLabel for the column. DATATYPE: String. |
| TimeZone | TimeZone property for the column. DATATYPE: Boolean. |
| Title | Teradata models only. Title property for the column. DATATYPE: String. |
| Unsigned | MySQL only. Specifies whether the column data type is unsigned. DATATYPE: Boolean. |
| UserDatatypeId | ID of the bounded user datatype object, if any. A user can bind a user datatype object to the attribute by assigning a particular user datatype ID to this property. DATATYPE: Integer. |
| VirtualColumnExpression | Oracle 11g and later only. Holds the expression used to compute a virtual column. DATATYPE: String |
| XMLCollection | SQL Server 2005 and later only. Column's Collection property, which applies to Columns with datatype XML. DATATYPE: String. |