AlterTableAlterColumnOption Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:
Microsoft.SqlServer.TransactSql.ScriptDom.dll
Package:
Microsoft.SqlServer.DacFx.x64 v140.3881.1
Package:
Microsoft.SqlServer.DacFx v150.5282.3
Package:
Microsoft.SqlServer.DacFx v160.6161.0
Package:
Microsoft.Data.Tools.Msbuild v10.0.61804.210
Package:
Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

The options for alter column version of alter table statement. AddRowguidcol, DropRowguidcol can only happen if there is no DataType.

public enum AlterTableAlterColumnOption
type AlterTableAlterColumnOption = 
Public Enum AlterTableAlterColumnOption
Inheritance
Enum
AlterTableAlterColumnOption

Fields

Name Value Description
NoOptionDefined 0

No option defined
AddRowGuidCol 1

Add Rowguidcol for the column.
DropRowGuidCol 2

Drop Rowguidcol for the column.
Null 3

Null was defined.
NotNull 4

Not null was defined.
AddPersisted 5

Add persisted for the column.
DropPersisted 6

Drop persisted for the column.
AddNotForReplication 7

Add not for replication for the column.
DropNotForReplication 8

Drop not for replication for the column.
AddSparse 9

Add Sparse for the column.
DropSparse 10

Drop Sparse for the column.
AddMaskingFunction 11

Add Masking Function for the column.
DropMaskingFunction 12

Drop Masking Function for the column.
AddHidden 13

Add hidden flag to temporal generated always column
DropHidden 14

Drops hidden flag to temporal generated always column
Encryption 15

Add Always Encryption details for column

Applies to