Enum AlterTableType

Indicates the type of alteration to be done in a table column

[Flags]
public enum AlterTableType

Extension Methods: TypeExtensions.InheritsFrom(object, Type)

BitFields.Add<T>(T, T)

BitFields.HasAny<T>(T, T)

BitFields.HasNone<T>(T, T)

BitFields.Has<T>(T, T)

BitFields.In<T>(T, T)

BitFields.IsExactly<T>(T, T)

BitFields.IsZero<T>(T)

BitFields.Remove<T>(T, T)

BitFields.Set<T>(T, T, bool)

BitFields.Toggle<T>(T, T)

Fields

All = 268435455

All

ColumnAddOrDrop = 1

Add Column

ColumnLength = 4

Set Column Length

ColumnRename = 2

Rename Column

ColumnSetOrDropDefault = 16

Set Column default value

ColumnSetOrDropNotNull = 8

Set Column to not null

None = 0

None

TableForeignKeyConstraint = 64

Add or drop a foreign key constraint, e.g.

alter table {TableName} add constraint {ConstraintName} foreign key ({ColumnName}) references {ForeignTableName} ({ForeignColumnName})

CAUTION: For use with a ALTER TABLE statement only.

NOTE: All databases support foreign key constraint in the CREATE TABLE statement.

TableUniqueConstraint = 32

Add or drop a unique constraint, e.g

alter table {TableName} add constraint {ConstraintName} unique ({ColumnName})

CAUTION: For use with a ALTER TABLE statement only.

NOTE: All databases support unique constraint in the CREATE TABLE statement.