Offline Schema Column Element
X-Ref:
- Ast Offline Schema Column Node
- Ast Table Column Base Node
- Ast Securable Node
- Ast Scope Boundary Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
| CodePage | Int32 | 0 | This value specifies the integer index for the codepage of the dataflow column. This property applies only to dataflow column types that support code pages, such as strings. Codepages supported by Windows are listed at: http://msdn.microsoft.com/en-us/goglobal/bb964654.aspx. |
| Computed | String | This value specifies a computed value for the column using Transact-SQL expression syntax. Computed column specifications conform to all SQL Server computed column rules as described at http://msdn.microsoft.com/en-us/library/ms191250.aspx | |
| CustomType | String | This value specifies the type of a column when the main column type has been set to Custom. This permits the specification of less commonly used SQL Server column types. A complete list of allowed types is available at http://msdn.microsoft.com/en-us/library/ms127023%28SQL.90%29.aspx | |
| DataType | DbType | Int32 | This value specifies the type of the data stored in this column using the unified type system. The type values include all of those types commonly used in Microsoft SQL Server table definitions. |
| Default | String | This value specifies a default value for the column using Transact-SQL constant expression syntax. | |
| DefaultConstraintName | String | This value specifies the name that should be used for the default value constraint for this column in the database. If the Default property has not been specified, the value of this property will be ignored. | |
| DoNotEmitOutputColumn | Boolean | False | Specifies whether or not this column should be included in the output path for the referencing SSIS dataflow component. This is normally set to true for columns with a data type that is not supported by SSIS data flows. |
| DotNetTypeName | String | Specifies the namespace qualified name of the .NET type that should be used for this column when its data values are manipulated with .NET code. | |
| FriendlyName | String | Provides a convenience property for storing an alternative name for this column. | |
| IdentityIncrement | Int32 | 0 | Set IdentityIncrement to a non-zero value to enable this column as an IDENTITY. This value specifies the amount by which the Identity value is incremented when a row is inserted. Removing this property or setting the value to 0 will remove the IDENTITY specification for this column. |
| IdentitySeed | Int32 | 1 | This value specifies the starting value for an identity column. When the first row is inserted into the table, this value is used. Both seed and increment must be specified if either is explicitly specified. The default value is 1. |
| IsKey | Boolean | False | Specifies whether or not this column participates in a relational database key when it is used by a referencing SSIS dataflow component. |
| IsLong | Boolean | False | Specifies whether or not this column uses a version of the underlying relational database type that should be treated as long. |
| IsNullable | Boolean | False | This value specifies whether null values are accepted for the column. |
| IsReadOnly | Boolean | False | Specifies whether or not this column is marked as read only in the relational database. |
| IsRowVersion | Boolean | False | Specifies whether or not this column uses a database-specific rowversion data type when it is used by a referencing SSIS dataflow component. |
| IsUnique | Boolean | False | Specifies whether or not this column participates in a relational database unique constraint when it is used by a referencing SSIS dataflow component. |
| Length | Int32 | 0 | (Set to -1 to indicate MAX length). This value specifies the length parameter for the column type associated with this column. This property applies only to column types that support a length specification, such as String and Binary types. |
| Ordinal | Int32 | 0 | Specifies the ordinal position of this column in the relational database table or query result set. |
| Precision | Int32 | -1 | This value specifies the precision parameter for the column type associated with this column. Precision is the number of digits stored for a numeric value. This property applies only to column types that support precision, such as Decimal. |
| ProviderType | Int32 | 0 | Specifies the database specific code assigned to the data type for this column. |
| RawDataType | String | Specifies the data type that is reported by the database provider for this column using the preferred text representation for the provider. | |
| RawDataTypeId | Int32 | 0 | Specifies the data type id that is reported by the database provider for this column using the preferred type code for the provider. |
| RawLength | Int32 | 0 | Specifies the length that is reported by the database provider for this column. |
| RawPrecision | Int32 | 0 | Specifies the precision that is reported by the database provider for this column. |
| RawScale | Int32 | 0 | Specifies the scale that is reported by the database provider for this column. |
| ReadOnly | Boolean | False | Advanced Feature: Use at your own risk. Specifies that the column should be treated as a read-only column. This will automatically remove the column from assignment from Merge statements and other auto-generated code paths. Computed columns and rowversion columns are two examples of data types which are read-only. |
| Scale | Int32 | -1 | This value specifies the scale parameter for the column type associated with this column. Scale is the number of digits to the right of the decimal point in a numeric value. This property applies only to column types that support precision, such as Decimal. |
| ScdType | ScdType | Update | This value specifies the slowly changing dimension type for the column. The value determines the behavior of the table when a row with a matching unique key value is added to the table. This behavior is enforced in the various Task and Dataflow transformations that interact with this table. |
| SizeInBytes | Int32 | 0 | Specifies the size of the data type of this column as measured in bytes by the underlying relational database. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <CheckConstraint /> | AstCheckConstraintNode | Defines a Check constraint, which can be used to enforce that data in a table or column meets specific criteria. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |