Class TableColumn
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
Constructors
TableColumn()
Declaration
TableColumn(string)
Declaration
public TableColumn(string name)
Parameters
TableColumn(string, string)
Declaration
public TableColumn(string name, string dataType)
Parameters
TableColumn(string, string, bool)
Declaration
public TableColumn(string name, string dataType, bool allowNulls)
Parameters
TableColumn(string, string, bool, bool)
Declaration
public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey)
Parameters
TableColumn(string, string, bool, bool, bool)
Declaration
public TableColumn(string name, string dataType, bool allowNulls, bool isPrimaryKey, bool isIdentity)
Parameters
Properties
AllowNulls
True, if the column is nullable. By default a column is not nullable.
Declaration
public bool AllowNulls { get; set; }
Property Value
Collation
The collation used for the column. Leave empty if you want to use the default collation.
Declaration
public string Collation { get; set; }
Property Value
A comment for the column (not supported by every database)
Declaration
public string Comment { get; set; }
Property Value
ComputedColumn
The calculation if the column should be computed.
Not all databases may support this.
Declaration
public string ComputedColumn { get; set; }
Property Value
DataType
The sql data type of the column (e.g. "INT" or "VARCHAR(30)")
Declaration
public string DataType { get; set; }
Property Value
DefaultValue
Define a default value for the column.
Not all databases may support this.
Declaration
public string DefaultValue { get; set; }
Property Value
IdentityIncrement
Only SqlServer: The increment value for an identity column
Declaration
public long? IdentityIncrement { get; set; }
Property Value
IdentitySeed
Only SqlServer: The seed for and identity column
Declaration
public long? IdentitySeed { get; set; }
Property Value
IsIdentity
True, if the column is used as an Identity column (auto increment in MySql or serial in Postgres)
Not every database supports this.
Declaration
public bool IsIdentity { get; set; }
Property Value
IsPrimaryKey
True if the column is part of the primary key
Declaration
public bool IsPrimaryKey { get; set; }
Property Value
NETDataType
The corresponding .NET data type retrieved from the sql DataType.
Declaration
public Type NETDataType { get; }
Property Value
Name
Declaration
public string Name { get; set; }
Property Value