Export (0) Print
Expand All
Expand Minimize

TSqlTokenType Enumeration

Specifies the token type.

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

public enum TSqlTokenType

Member nameDescription
AddThe token type is Add.
AddEqualsThe token type is AddEquals.
AllThe token type is All.
AlterThe token type is Alter.
AmpersandThe token type is Ampersand.
AndThe token type is And.
AnyThe token type is Any.
AsThe token type is As.
AscThe token type is Asc.
AsciiStringLiteralThe token type is AsciiStringLiteral.
AsciiStringOrQuotedIdentifierThe token type is AsciiStringOrQuotedIdentifier.
AuthorizationThe token type is Authorization.
BackupThe token type is Backup.
BangThe token type is Bang.
BeginThe token type is Begin.
BetweenThe token type is Between.
BitwiseAndEqualsThe token type is BitwiseAndEquals.
BitwiseOrEqualsThe token type is BitwiseOrEquals.
BitwiseXorEqualsThe token type is BitwiseXorEquals.
BreakThe token type is Break.
BrowseThe token type is Browse.
BulkThe token type is Bulk.
ByThe token type is By.
CascadeThe token type is Cascade.
CaseThe token type is Case.
CheckThe token type is Check.
CheckpointThe token type is Checkpoint.
CircumflexThe token type is Circumflex.
CloseThe token type is Close.
ClusteredThe token type is Clustered.
CoalesceThe token type is Coalesce.
CollateThe token type is Collate.
ColonThe token type is Colon.
ColumnThe token type is Column.
CommaThe token type is Comma.
CommitThe token type is Commit.
ComputeThe token type is Compute.
ConstraintThe token type is Constraint.
ContainsThe token type is Contains.
ContainsTableThe token type is ContainsTable.
ContinueThe token type is Continue.
ConvertThe token type is Convert.
CreateThe token type is Create.
CrossThe token type is Cross.
CurrentThe token type is Current.
CurrentDateThe token type is CurrentDate.
CurrentTimeThe token type is CurrentTime.
CurrentTimestampThe token type is CurrentTimestamp.
CurrentUserThe token type is CurrentUser.
CursorThe token type is Cursor.
DatabaseThe token type is Database.
DbccThe token type is Dbcc.
DeallocateThe token type is Deallocate.
DeclareThe token type is Declare.
DefaultThe token type is Default.
DeleteThe token type is Delete.
DenyThe token type is Deny.
DescThe token type is Desc.
DiskThe token type is Disk.
DistinctThe token type is Distinct.
DistributedThe token type is Distributed.
DivideThe token type is Divide.
DivideEqualsThe token type is DivideEquals.
DollarPartitionThe token type is DollarPartition.
DotThe token type is Dot.
DoubleThe token type is Double.
DoubleColonThe token type is DoubleColon.
DropThe token type is Drop.
DumpThe token type is Dump.
ElseThe token type is Else.
EndThe token type is End.
EndOfFileThe token type is EndOfFile.
EqualsSignThe token type is EqualsSign.
ErrlvlThe token type is Errlvl.
EscapeThe token type is Escape.
ExceptThe token type is Except.
ExecThe token type is Exec.
ExecuteThe token type is Execute.
ExistsThe token type is Exists.
ExitThe token type is Exit.
ExternalThe token type is External.
FetchThe token type is Fetch.
FileThe token type is File.
FillFactorThe token type is FillFactor.
ForThe token type is For.
ForeignThe token type is Foreign.
FreeTextThe token type is FreeText.
FreeTextTableThe token type is FreeTextTable.
FromThe token type is From.
FullThe token type is Full.
FunctionThe token type is Function.
GoThe token type is Go.
GoToThe token type is GoTo.
GrantThe token type is Grant.
GreaterThanThe token type is GreaterThan.
GroupThe token type is Group.
HavingThe token type is Having.
HexLiteralThe token type is HexLiteral.
HoldLockThe token type is HoldLock.
IdentifierThe token type is Identifier.
IdentityThe token type is Identity.
IdentityColumnThe token type is IdentityColumn.
IdentityInsertThe token type is IdentityInsert.
IfThe token type is If.
InThe token type is In.
IndexThe token type is Index.
InnerThe token type is Inner.
InsertThe token type is Insert.
IntegerThe token type is Integer.
IntersectThe token type is Intersect.
IntoThe token type is Into.
IsThe token type is Is.
JoinThe token type is Join.
KeyThe token type is Key.
KillThe token type is Kill.
LabelThe token type is Label.
LeftThe token type is Left.
LeftCurlyThe token type is LeftCurly.
LeftParenthesisThe token type is LeftParenthesis.
LessThanThe token type is LessThan.
LikeThe token type is Like.
LineNoThe token type is LineNo.
LoadThe token type is Load.
MergeThe token type is Merge.
MinusThe token type is Minus.
ModEqualsThe token type is ModEquals.
MoneyThe token type is Money.
MultilineCommentThe token type is MultilineComment.
MultiplyEqualsThe token type is MultiplyEquals.
NationalThe token type is National.
NoCheckThe token type is NoCheck.
NonClusteredThe token type is NonClustered.
NoneThe token type is None.
NotThe token type is Not.
NullThe token type is Null.
NullIfThe token type is NullIf.
NumericThe token type is Numeric.
OdbcInitiatorThe token type is OdbcInitiator.
OfThe token type is Of.
OffThe token type is Off.
OffsetsThe token type is Offsets.
OnThe token type is On.
OpenThe token type is Open.
OpenDataSourceThe token type is OpenDataSource.
OpenQueryThe token type is OpenQuery.
OpenRowSetThe token type is OpenRowSet.
OpenXmlThe token type is OpenXml.
OptionThe token type is Option.
OrThe token type is Or.
OrderThe token type is Order.
OuterThe token type is Outer.
OverThe token type is Over.
PercentThe token type is Percent.
PercentSignThe token type is PercentSign.
PivotThe token type is Pivot.
PlanThe token type is Plan.
PlusThe token type is Plus.
PrecisionThe token type is Precision.
PrimaryThe token type is Primary.
PrintThe token type is Print.
ProcThe token type is Proc.
ProcedureThe token type is Procedure.
ProcNameSemicolonThe token type is ProcNameSemicolon.
PseudoColumnThe token type is PseudoColumn.
PublicThe token type is Public.
QuotedIdentifierThe token type is QuotedIdentifier.
RaiserrorThe token type is Raiserror.
ReadThe token type is Read.
ReadTextThe token type is ReadText.
RealThe token type is Real.
ReconfigureThe token type is Reconfigure.
ReferencesThe token type is References.
ReplicationThe token type is Replication.
RestoreThe token type is Restore.
RestrictThe token type is Restrict.
ReturnThe token type is Return.
RevertThe token type is Revert.
RevokeThe token type is Revoke.
RightThe token type is Right.
RightCurlyThe token type is RightCurly.
RightOuterJoinThe token type is RightOuterJoin.
RightParenthesisThe token type is RightParenthesis.
RollbackThe token type is Rollback.
RowCountThe token type is RowCount.
RowGuidColumnThe token type is RowGuidColumn.
RuleThe token type is Rule.
SaveThe token type is Save.
SchemaThe token type is Schema.
SelectThe token type is Select.
SemanticKeyPhraseTableThe token type is SemanticKeyPhraseTable.
SemanticSimilarityDetailsTableThe token type is SemanticSimilarityDetailsTable.
SemanticSimilarityTableThe token type is SemanticSimilarityTable.
SemicolonThe token type is Semicolon.
SessionUserThe token type is SessionUser.
SetThe token type is Set.
SetUserThe token type is SetUser.
ShutdownThe token type is Shutdown.
SingleLineCommentThe token type is SingleLineComment.
SomeThe token type is Some.
SqlCommandIdentifierThe token type is SqlCommandIdentifier.
StarThe token type is Star.
StatisticsThe token type is Statistics.
StopListThe token type is StopList.
SubtractEqualsThe token type is SubtractEquals.
SystemUserThe token type is SystemUser.
TableThe token type is Table.
TableSampleThe token type is TableSample.
TextSizeThe token type is TextSize.
ThenThe token type is Then.
TildeThe token type is Tilde.
ToThe token type is To.
TopThe token type is Top.
TranThe token type is Tran.
TransactionThe token type is Transaction.
TriggerThe token type is Trigger.
TruncateThe token type is Truncate.
TryConvertThe token type is TryConvert.
TSEqualThe token type is TSEqual.
UnicodeStringLiteralThe token type is UnicodeStringLiteral.
UnionThe token type is Union.
UniqueThe token type is Unique.
UnpivotThe token type is Unpivot.
UpdateThe token type is Update.
UpdateTextThe token type is UpdateText.
UseThe token type is Use.
UserThe token type is User.
ValuesThe token type is Values.
VariableThe token type is Variable.
VaryingThe token type is Varying.
VerticalLineThe token type is VerticalLine.
ViewThe token type is View.
WaitForThe token type is WaitFor.
WhenThe token type is When.
WhereThe token type is Where.
WhileThe token type is While.
WhiteSpaceThe token type is WhiteSpace.
WithThe token type is With.
WriteTextThe token type is WriteText.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft