TechNet

Products
Products
IT Resources
Resources
Solutions
Downloads
Updates
Trials
Related Sites
Training
Training
Certifications
Other resources
Support
Support options
More support
Not an IT pro?
- Microsoft Customer Support
- Microsoft Community Forums

Sign in

Microsoft TechNet

TSqlStatement Class

TSqlStatement Class

Represents a single T-SQL statement.

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Inheritance Hierarchy

System.Object
Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterAsymmetricKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterAuthorizationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterCreateEndpointStatementBase
Microsoft.SqlServer.TransactSql.ScriptDom.AlterCreateServiceStatementBase
Microsoft.SqlServer.TransactSql.ScriptDom.AlterCryptographicProviderStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterDatabaseStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterFederationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterFullTextIndexStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterFullTextStopListStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterLoginStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterPartitionFunctionStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterPartitionSchemeStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterResourceGovernorStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterSchemaStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterSearchPropertyListStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterServerConfigurationSetBufferPoolExtensionStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterServerConfigurationSetDiagnosticsLogStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterServerConfigurationSetFailoverClusterPropertyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterServerConfigurationSetHadrClusterStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterServerConfigurationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterServiceMasterKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterTableStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AlterXmlSchemaCollectionStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ApplicationRoleStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AssemblyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AuditSpecificationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.AvailabilityGroupStatement
Microsoft.SqlServer.TransactSql.ScriptDom.BackupRestoreMasterKeyStatementBase
Microsoft.SqlServer.TransactSql.ScriptDom.BackupStatement
Microsoft.SqlServer.TransactSql.ScriptDom.BeginConversationTimerStatement
Microsoft.SqlServer.TransactSql.ScriptDom.BeginDialogStatement
Microsoft.SqlServer.TransactSql.ScriptDom.BeginEndBlockStatement
Microsoft.SqlServer.TransactSql.ScriptDom.BreakStatement
Microsoft.SqlServer.TransactSql.ScriptDom.BrokerPriorityStatement
Microsoft.SqlServer.TransactSql.ScriptDom.BulkInsertBase
Microsoft.SqlServer.TransactSql.ScriptDom.CertificateStatementBase
Microsoft.SqlServer.TransactSql.ScriptDom.CheckpointStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CloseMasterKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CloseSymmetricKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ContinueStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateAggregateStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateAsymmetricKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateColumnStoreIndexStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateContractStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateCryptographicProviderStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateDatabaseStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateDefaultStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateEventNotificationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateFederationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateFullTextIndexStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateFullTextStopListStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateLoginStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreatePartitionFunctionStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreatePartitionSchemeStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateRuleStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateSchemaStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateSearchPropertyListStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateSpatialIndexStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateStatisticsStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateSynonymStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateTableStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateTypeStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CreateXmlSchemaCollectionStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CredentialStatement
Microsoft.SqlServer.TransactSql.ScriptDom.CursorStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DatabaseEncryptionKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DbccStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DeclareCursorStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DeclareTableVariableStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DeclareVariableStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DiskStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropChildObjectsStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropDatabaseEncryptionKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropDatabaseStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropEventNotificationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropFullTextIndexStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropIndexStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropMasterKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropObjectsStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropQueueStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropSchemaStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropTypeStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropUnownedObjectStatement
Microsoft.SqlServer.TransactSql.ScriptDom.DropXmlSchemaCollectionStatement
Microsoft.SqlServer.TransactSql.ScriptDom.EnableDisableTriggerStatement
Microsoft.SqlServer.TransactSql.ScriptDom.EndConversationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.EventSessionStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ExecuteAsStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ExecuteStatement
Microsoft.SqlServer.TransactSql.ScriptDom.FullTextCatalogStatement
Microsoft.SqlServer.TransactSql.ScriptDom.GoToStatement
Microsoft.SqlServer.TransactSql.ScriptDom.IfStatement
Microsoft.SqlServer.TransactSql.ScriptDom.IndexDefinition
Microsoft.SqlServer.TransactSql.ScriptDom.IndexStatement
Microsoft.SqlServer.TransactSql.ScriptDom.KillQueryNotificationSubscriptionStatement
Microsoft.SqlServer.TransactSql.ScriptDom.KillStatement
Microsoft.SqlServer.TransactSql.ScriptDom.KillStatsJobStatement
Microsoft.SqlServer.TransactSql.ScriptDom.LabelStatement
Microsoft.SqlServer.TransactSql.ScriptDom.LineNoStatement
Microsoft.SqlServer.TransactSql.ScriptDom.MasterKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.MessageTypeStatementBase
Microsoft.SqlServer.TransactSql.ScriptDom.MoveConversationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.OpenMasterKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.OpenSymmetricKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.PrintStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ProcedureStatementBodyBase
Microsoft.SqlServer.TransactSql.ScriptDom.QueueStatement
Microsoft.SqlServer.TransactSql.ScriptDom.RaiseErrorLegacyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.RaiseErrorStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ReadTextStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ReconfigureStatement
Microsoft.SqlServer.TransactSql.ScriptDom.RemoteServiceBindingStatementBase
Microsoft.SqlServer.TransactSql.ScriptDom.ResourcePoolStatement
Microsoft.SqlServer.TransactSql.ScriptDom.RestoreStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ReturnStatement
Microsoft.SqlServer.TransactSql.ScriptDom.RevertStatement
Microsoft.SqlServer.TransactSql.ScriptDom.RoleStatement
Microsoft.SqlServer.TransactSql.ScriptDom.RouteStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SecurityStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SecurityStatementBody80
Microsoft.SqlServer.TransactSql.ScriptDom.SendStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SequenceStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ServerAuditStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SetCommandStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SetErrorLevelStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SetOnOffStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SetRowCountStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SetTextSizeStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SetTransactionIsolationLevelStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SetUserStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SetVariableStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ShutdownStatement
Microsoft.SqlServer.TransactSql.ScriptDom.SignatureStatementBase
Microsoft.SqlServer.TransactSql.ScriptDom.StatementWithCtesAndXmlNamespaces
Microsoft.SqlServer.TransactSql.ScriptDom.SymmetricKeyStatement
Microsoft.SqlServer.TransactSql.ScriptDom.TextModificationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ThrowStatement
Microsoft.SqlServer.TransactSql.ScriptDom.TransactionStatement
Microsoft.SqlServer.TransactSql.ScriptDom.TriggerStatementBody
Microsoft.SqlServer.TransactSql.ScriptDom.TruncateTableStatement
Microsoft.SqlServer.TransactSql.ScriptDom.TryCatchStatement
Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatementSnippet
Microsoft.SqlServer.TransactSql.ScriptDom.UpdateStatisticsStatement
Microsoft.SqlServer.TransactSql.ScriptDom.UseFederationStatement
Microsoft.SqlServer.TransactSql.ScriptDom.UserStatement
Microsoft.SqlServer.TransactSql.ScriptDom.UseStatement
Microsoft.SqlServer.TransactSql.ScriptDom.ViewStatementBody
Microsoft.SqlServer.TransactSql.ScriptDom.WaitForStatement
Microsoft.SqlServer.TransactSql.ScriptDom.WaitForSupportedStatement
Microsoft.SqlServer.TransactSql.ScriptDom.WhileStatement
Microsoft.SqlServer.TransactSql.ScriptDom.WorkloadGroupStatement

Syntax

<SerializableAttribute>
Public MustInherit Class TSqlStatement
	Inherits TSqlFragment

Constructors

	Name	Description
	TSqlStatement()	Initializes a new instance of the T:Microsoft.SqlServer.TransactSql.ScriptDom.TsqlStatement class.

Properties

	Name	Description
	FirstTokenIndex	Gets or sets the first token index.(Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length.(Inherited from TSqlFragment.)
	LastTokenIndex	Gets or sets the last token index.(Inherited from TSqlFragment.)
	ScriptTokenStream	Gets or sets a list of token streams.(Inherited from TSqlFragment.)
	StartColumn	Gets the starting column.(Inherited from TSqlFragment.)
	StartLine	Gets the starting line.(Inherited from TSqlFragment.)
	StartOffset	Gets the fragment start offset value.(Inherited from TSqlFragment.)

Methods

	Name	Description
	Accept(TSqlFragmentVisitor)	Indicates the entry point for a given visitor.(Inherited from TSqlFragment.)
	AcceptChildren(TSqlFragmentVisitor)	Accepts visitor for Children.(Overrides TSqlFragment.AcceptChildren(TSqlFragmentVisitor).)
	Equals(Object)	(Inherited from Object.)
	Finalize()	(Inherited from Object.)
	GetHashCode()	(Inherited from Object.)
	GetType()	(Inherited from Object.)
	MemberwiseClone()	(Inherited from Object.)
	ToString()	(Inherited from Object.)

Thread Safety

Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Print Export (0)

Print Share

Is this page helpful?

© 2017 Microsoft