AlterTableAddTableElementStatement Class

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

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

[System.Serializable]
public class AlterTableAddTableElementStatement : Microsoft.SqlServer.TransactSql.ScriptDom.AlterTableStatement

[<System.Serializable>]
type AlterTableAddTableElementStatement = class
    inherit AlterTableStatement

Public Class AlterTableAddTableElementStatement
Inherits AlterTableStatement

Inheritance: Object

TSqlFragment

TSqlStatement

AlterTableStatement
AlterTableAddTableElementStatement

Attributes: SerializableAttribute

Constructors

AlterTableAddTableElementStatement()

Fields

Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Properties

Definition	The table definition containing the column and constraint definitions.
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	Gets or sets the first index of the token. (Inherited from TSqlFragment)
FragmentLength	Defines the number of characters the fragment takes up in the script it was parsed. (Inherited from TSqlFragment)
LastTokenIndex	Gets or sets the last index of the token. (Inherited from TSqlFragment)
SchemaObjectName	The name of the type, this can be at most a two part name. (Inherited from AlterTableStatement)
ScriptTokenStream	Gets or sets the script token stream. (Inherited from TSqlFragment)
StartColumn	Gets the start column. (Inherited from TSqlFragment)
StartLine	Gets the start line. (Inherited from TSqlFragment)
StartOffset	Defines the character offset of fragments starting location in the script it was parsed. (Inherited from TSqlFragment)

Methods

Accept(TSqlFragmentVisitor)	Accepts visitor
AcceptChildren(TSqlFragmentVisitor)	Accepts visitor for Children

Applies to

共用方式為