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
HasDefaultValue#
Declaration
public bool HasDefaultValue { get; }
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
IsComputed#
Declaration
public bool IsComputed { get; }
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
ETLBox