AlterTableAddTableElementStatement AlterTableAddTableElementStatement AlterTableAddTableElementStatement Class


Add table element specialization of Alter Table statement. Has column and constraint definitions.

public class AlterTableAddTableElementStatement : Microsoft.SqlServer.TransactSql.ScriptDom.AlterTableStatement
type AlterTableAddTableElementStatement = class
    inherit AlterTableStatement
Public Class AlterTableAddTableElementStatement
Inherits AlterTableStatement


AlterTableAddTableElementStatement() AlterTableAddTableElementStatement() AlterTableAddTableElementStatement()


Definition Definition Definition

The table definition containing the column and constraint definitions.

ExistingRowsCheckEnforcement ExistingRowsCheckEnforcement ExistingRowsCheckEnforcement

Specifies whether the data in the table is or is not validated against a newly added or re-enabled FOREIGN KEY or CHECK constraint. Defines which one of WITH CHECK or WITH NOCHECK were used. Check is the default for this class(if nothing was explicitly mentioned), since these are new constraints (Books online).

FirstTokenIndex FirstTokenIndex FirstTokenIndex

Gets or sets the first index of the token.

(Inherited from TSqlFragment)
FragmentLength FragmentLength FragmentLength

Defines the number of characters the fragment takes up in the script it was parsed.

(Inherited from TSqlFragment)
LastTokenIndex LastTokenIndex LastTokenIndex

Gets or sets the last index of the token.

(Inherited from TSqlFragment)
SchemaObjectName SchemaObjectName SchemaObjectName

The name of the type, this can be at most a two part name.

(Inherited from AlterTableStatement)
ScriptTokenStream ScriptTokenStream ScriptTokenStream

Gets or sets the script token stream.

(Inherited from TSqlFragment)
StartColumn StartColumn StartColumn

Gets the start column.

(Inherited from TSqlFragment)
StartLine StartLine StartLine

Gets the start line.

(Inherited from TSqlFragment)
StartOffset StartOffset StartOffset

Defines the character offset of fragments starting location in the script it was parsed.

(Inherited from TSqlFragment)


Accept(TSqlFragmentVisitor) Accept(TSqlFragmentVisitor) Accept(TSqlFragmentVisitor)

Accepts visitor

AcceptChildren(TSqlFragmentVisitor) AcceptChildren(TSqlFragmentVisitor) AcceptChildren(TSqlFragmentVisitor)

Accepts visitor for Children


Uninitialized Uninitialized Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Applies to