Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Classes

AddAlterFullTextIndexAction

Represents ADD action for ALTER FULLTEXT INDEX statement.

AddFileSpec

Represents single file in ADD FILE FROM clause in ALTER ASSEMBLY statement

AddMemberAlterRoleAction

Represents the add member alter role action.

AddSearchPropertyListAction

The ADD search property list action.

AddSignatureStatement

Represents ADD SIGNATURE statements.

AdHocDataSource

Represents ad hoc datasource.

AdHocTableReference

OPENDATASOURCE (ad-hoc) table reference.

AlgorithmKeyOption

Represents ALGORITHM option.

AlterApplicationRoleStatement

Represents the alter application role statement.

AlterAssemblyStatement

Represents the ALTER ASSEMBLY statement.

AlterAsymmetricKeyStatement

Represents ALTER ASYMMETRIC KEY statement

AlterAuthorizationStatement

Represents alter authorization statement.

AlterAvailabilityGroupAction

Action to take for alter availability group.

AlterAvailabilityGroupFailoverAction

Represents the failover action to take for alter availability group.

AlterAvailabilityGroupFailoverOption

Represents a failover option.

AlterAvailabilityGroupStatement

Represents the ALTER AVAILABILITY GROUP statement

AlterBrokerPriorityStatement

Represents the Alter Broker Priority statement.

AlterCertificateStatement

Represents ALTER CERTIFICATE statement

AlterColumnAlterFullTextIndexAction

Represents ALTER COLUMN action for ALTER FULLTEXT INDEX statement.

AlterColumnEncryptionKeyStatement

Represents an ALTER COLUMN ENCRYPTION KEY statement

AlterCreateEndpointStatementBase

Represents common part of CREATE and ALTER ENDPOINT statements

AlterCreateServiceStatementBase

Represents CREATE SERVICE statement

AlterCredentialStatement

Represents ALTER CREDENTIAL statement

AlterCryptographicProviderStatement

Represents the Alter Cryptographic Provider statement.

AlterDatabaseAddFileGroupStatement

Add and remove filegroup cases from ALTER DATABASE

AlterDatabaseAddFileStatement

Add file case from ALTER DATABASE

AlterDatabaseAuditSpecificationStatement

Alters database audit specification.

AlterDatabaseCollateStatement

Alter COLLATE case from ALTER DATABASE

AlterDatabaseEncryptionKeyStatement

Alters database encryption key

AlterDatabaseModifyFileGroupStatement

Modify filegroup case from ALTER DATABASE

AlterDatabaseModifyFileStatement

Modify file case from ALTER DATABASE

AlterDatabaseModifyNameStatement

Modify name case from ALTER DATABASE

AlterDatabaseRebuildLogStatement

Rebuild log case from ALTER DATABASE (undocumented)

AlterDatabaseRemoveFileGroupStatement

Add and remove filegroup cases from ALTER DATABASE

AlterDatabaseRemoveFileStatement

Remove file case from ALTER DATABASE

AlterDatabaseScopedConfigurationClearStatement

Represents ALTER DATABASE SCOPED CONFIGURATION CLEAR statement

AlterDatabaseScopedConfigurationSetStatement

Represents ALTER DATABASE SCOPED CONFIGURATION SET statement

AlterDatabaseScopedConfigurationStatement

Represents ALTER DATABASE SCOPED CONFIGURATION statement

AlterDatabaseSetStatement

Represents SET case in ALTER DATABASE statement

AlterDatabaseStatement

Represents ALTER DATABASE statement

AlterDatabaseTermination

Contains termination information

AlterEndpointStatement

Represents ALTER ENDPOINT statement

AlterEventSessionStatement

Represents the Alter Event Session statement.

AlterExternalDataSourceStatement

Represents an ALTER EXTERNAL DATA SOURCE statement.

AlterExternalResourcePoolStatement

Represents the Alter External Resource Pool statement.

AlterFederationStatement

Represents the ALTER FEDERATION statement

AlterFullTextCatalogStatement

Represents ALTER FULLTEXT CATALOG statement

AlterFullTextIndexAction

Represents altering action for ALTER FULLTEXT INDEX statement.

AlterFullTextIndexStatement

Represents ALTER FULLTEXT INDEX statement.

AlterFullTextStopListStatement

Represents the Alter Fulltext Stoplist statement.

AlterFunctionStatement

Represents the Alter Function statement.

AlterIndexStatement

Represents the alter index statement.

AlterLoginAddDropCredentialStatement

Represents ALTER LOGIN which adds or drops credential name.

AlterLoginEnableDisableStatement

Represents ALTER LOGIN which enables or disables login.

AlterLoginOptionsStatement

Represents ALTER LOGIN which alters options.

AlterLoginStatement

Represents ALTER LOGIN statement.

AlterMasterKeyStatement

Represents the master key statement.

AlterMessageTypeStatement

Represents ALTER MESSAGE TYPE statement

AlterPartitionFunctionStatement

Represents ALTER PARTITION FUNCTION statement.

AlterPartitionSchemeStatement

Represents ALTER PARTITION SCHEME statement.

AlterProcedureStatement

The alter procedure statement.

AlterQueueStatement

Represents alter queue statement.

AlterRemoteServiceBindingStatement

Represents ALTER REMOTE SERVICE BINDING statement

AlterResourceGovernorStatement

Represents the Alter Resource Governor Statement.

AlterResourcePoolStatement

Represents the Alter Resource Pool statement.

AlterRoleAction

Represents an action in ALTER ROLE.

AlterRoleStatement

Represents the alter role statement.

AlterRouteStatement

Represents alter route statement.

AlterSchemaStatement

Represents ALTER SCHEMA statement

AlterSearchPropertyListStatement

Represents ALTER SEARCH PROPERTY LIST statement

AlterSecurityPolicyStatement

Represents an ALTER SECURITY POLICY statement

AlterSequenceStatement

Represents ALTER SEQUENCE statement

AlterServerAuditSpecificationStatement

Alters server audit specification.

AlterServerAuditStatement

Alters server audit.

AlterServerConfigurationBufferPoolExtensionContainerOption

Represents a single ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION top level setting that can have a list of suboptions.

AlterServerConfigurationBufferPoolExtensionOption

Represents a single ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION option.

AlterServerConfigurationBufferPoolExtensionSizeOption

Represents the SIZE option for the BUFFER POOL EXTENSION.

AlterServerConfigurationDiagnosticsLogMaxSizeOption

Represents a single ALTER SERVER CONFIGURATION SET DIAGNOSTICS LOG MAX_SIZE option.

AlterServerConfigurationDiagnosticsLogOption

Represents a single ALTER SERVER CONFIGURATION SET DIAGNOSTICS LOG option.

AlterServerConfigurationFailoverClusterPropertyOption

Represents a single ALTER SERVER CONFIGURATION SET FAILOVER CLUSTER PROPERTY option.

AlterServerConfigurationHadrClusterOption

Represents a single ALTER SERVER CONFIGURATION SET HADR CLUSTER option.

AlterServerConfigurationSetBufferPoolExtensionStatement

Represents ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION statement.

AlterServerConfigurationSetDiagnosticsLogStatement

Represents ALTER SERVER CONFIGURATION SET DIAGNOSTICS LOG statement.

AlterServerConfigurationSetFailoverClusterPropertyStatement

Represents ALTER SERVER CONFIGURATION SET FAILOVER CLUSTER PROPERTY statement.

AlterServerConfigurationSetHadrClusterStatement

Represents ALTER SERVER CONFIGURATION SET HADR CLUSTER statement.

AlterServerConfigurationSetSoftNumaStatement

Represents ALTER SERVER CONFIGURATION SET SOFTNUMA statement.

AlterServerConfigurationSoftNumaOption

Represents a single ALTER SERVER CONFIGURATION SET SOFTNUMA option.

AlterServerConfigurationStatement

Represents ALTER SERVER CONFIGURATION statement.

AlterServerRoleStatement

Represents the ALTER SERVER ROLE statement.

AlterServiceMasterKeyStatement

Represents ALTER SERVICE MASTER KEY statement

AlterServiceStatement

Represents ALTER SERVICE statement

AlterSymmetricKeyStatement

Represents ALTER SYMMETRIC KEY statement

AlterTableAddTableElementStatement

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

AlterTableAlterColumnStatement

Alter column specialization of Alter Table statement.

AlterTableAlterIndexStatement

Alter index rebuild specialization of Alter Table statement.

AlterTableAlterPartitionStatement

Split/Merge the partitions of a SQL DW table.

AlterTableChangeTrackingModificationStatement

Modifies change tracking for a table.

AlterTableConstraintModificationStatement

Defines modifications to a table constraint.

AlterTableDropTableElement

Represents an individual element that can be used in alter table drop statement.

AlterTableDropTableElementStatement

Drop table element specialization of Alter Table statement. Has names of columns and constraints to be dropped.

AlterTableFileTableNamespaceStatement

Enables or disable filetable namespace on a table.

AlterTableRebuildStatement

Rebuilds indicies on a table.

AlterTableSetStatement

Changes table options for a table.

AlterTableStatement

Represents the alter table statement base class.

AlterTableSwitchStatement

Switch specialization of Alter Table statement.

AlterTableTriggerModificationStatement

Defines the modifications to a Trigger on a table. Triggers can be enabled or disabled.

AlterTriggerStatement

The ALTER TRIGGER statement.

AlterUserStatement

Represents the alter user statement.

AlterViewStatement

The ALTER VIEW statement.

AlterWorkloadGroupStatement

Represents the Alter Workload Group statement.

AlterXmlSchemaCollectionStatement

Represents the alter xml schema collection statement.

ApplicationRoleOption

Represents the application role option.

ApplicationRoleStatement

Represents the application role statement base.

AssemblyEncryptionSource

Represents reference to an assembly containing key or certificate

AssemblyName

Represents CLR assembly names.

AssemblyOption

Represents an assembly option.

AssemblyStatement

Represents common parts in create and alter assembly statements.

AssignmentSetClause

Represents SET clause for assignment.

AsymmetricKeyCreateLoginSource

Certificate case in CREATE LOGIN statement

AtomicBlockOption

Represents single atomic block option.

AtTimeZoneCall

Represents the AT TIME ZONE call.

AuditActionGroupReference

Represents audit group reference.

AuditActionSpecification

Represents audit action specification.

AuditGuidAuditOption

AUDIT_GUID option in CREATE SERVER AUDIT statement.

AuditOption

Single option in CREATE/ALTER SERVER AUDIT statement.

AuditSpecificationDetail

Base class for audit action specification and audit action group name.

AuditSpecificationPart

Represents one ADD/DROP clause in audit specification statement.

AuditSpecificationStatement

Represents audit specification statement.

AuditTarget

Audit target in CREATE/ALTER SERVER AUDIT statements.

AuditTargetOption

Single option for audit target.

AuthenticationEndpointProtocolOption

Represents AUTHENTICATION HTTP endpoint protocol option

AuthenticationPayloadOption

Represents AUTHENTICATION payload option

AutoCleanupChangeTrackingOptionDetail

AUTO_CLEANUP part of CHANGE_TRACKING option in ALTER DATABASE SET statement.

AutoCreateStatisticsDatabaseOption

Database option with parentheses-wrapped suboptions.

AutomaticTuningCreateIndexOption

Create Index part of Automatic Tuning Options

AutomaticTuningDatabaseOption

Automatic tuning option in ALTER DATABASE statement, SET case

AutomaticTuningDropIndexOption

Drop Index part of Automatic Tuning Options

AutomaticTuningForceLastGoodPlanOption

Force Last Good Plan part of Automatic Tuning Options

AutomaticTuningMaintainIndexOption

Maintain Index part of Automatic Tuning Options

AutomaticTuningOption

A single Automatic Tuning option.

AvailabilityGroupOption

Base for availability group options.

AvailabilityGroupStatement

Base for availability group statements

AvailabilityModeReplicaOption

Represents the replica option for availability mode.

AvailabilityReplica

The declaration of an availability replica.

AvailabilityReplicaOption

Represents an availability replica option.

BackupCertificateStatement

Represents BACKUP CERTIFICATE statement

BackupDatabaseStatement

Represents BACKUP DATABASE statement

BackupEncryptionOption

Represents the encryption option in a backup statement.

BackupMasterKeyStatement

Represents BACKUP MASTER KEY statement

BackupOption

Represents a single option in BACKUP statement

BackupRestoreFileInfo

Information about files/filegroups being backed up/restored (READ_WRITE_FILEGROUPS - 2005 only)

BackupRestoreMasterKeyStatementBase

Represents common part of BACKUP and RESTORE (SERVICE) MASTER KEY statements

BackupServiceMasterKeyStatement

Represents BACKUP SERVICE MASTER KEY statement

BackupStatement

Represents BACKUP/DUMP statement

BackupTransactionLogStatement

Represents BACKUP TRANSACTION statement

BackwardsCompatibleDropIndexClause

Represents old-style clause in DROP INDEX statement

BeginConversationTimerStatement

Represents BEGIN CONVERSATION TIMER statement

BeginDialogStatement

Represents BEGIN DIALOG statement

BeginEndAtomicBlockStatement

Represents a group of statements that start with a BEGIN and end with an END keyword in a ATOMIC block.

BeginEndBlockStatement

Represents a group of statements that start with a BEGIN and end with an END keyword.

BeginTransactionStatement

Represents the begin transaction and begin distributed transaction statements.

BinaryExpression

An expression that has two expressions as children.

BinaryLiteral

Represents a Binary literal.

BinaryQueryExpression

This class represents the union that is used in a select statement.

BooleanBinaryExpression

A boolean expression that has two boolean expressions as children

BooleanComparisonExpression

A boolean expression that does a comparison between two scalar expressions

BooleanExpression

The abstract base class that represents boolean expressions

BooleanExpressionSnippet

Placeholder for an arbitrary boolean expression.

BooleanIsNullExpression

A boolean expression for IS [NOT] NULL

BooleanNotExpression

Represents a NOT boolean expression

BooleanParenthesisExpression

Represents a boolean expression enclosed in parentheses.

BooleanTernaryExpression

A boolean expression that has three expressions as children.

BoundingBoxParameter

Represents the spatial index structured parameter by name.

BoundingBoxSpatialIndexOption

Represents the BOUNDING_BOX spatial index option.

BreakStatement

Represents the break statement.

BrokerPriorityParameter

Represents the broker prioriry statement parameters.

BrokerPriorityStatement

Represents Create and Alter Broker Priority Statement.

BrowseForClause

Represents FOR BROWSE case

BuiltInFunctionTableReference

This class represents the built in functions as a simple table reference.

BulkInsertBase

Represents BULK INSERT statement

BulkInsertOption

Represents single option in BULK INSERT statement

BulkInsertStatement

Represents BULK INSERT statement

BulkOpenRowset

Represents OPENROWSET (BULK ...) table reference.

CallTarget

Represents a target of a function call.

CaseExpression

Represents the case expression.

CastCall

Represents the cast call.

CatalogCollationOption

Sets the database's CATALOG_COLLATION

CellsPerObjectSpatialIndexOption

Represents the CELLS_PER_OBJECT spatial index option.

CertificateCreateLoginSource

Certificate case in CREATE LOGIN statement

CertificateOption

Represents single SUBJECT or START_DATE or EXPIRE_DATE options in CREATE CERTIFICATE statement

CertificateStatementBase

Represents CREATE CERTIFICATE statement

ChangeRetentionChangeTrackingOptionDetail

CHANGE_RETENTION part of CHANGE_TRACKING option in ALTER DATABASE SET statement.

ChangeTableChangesTableReference

CHANGETABLE clause with CHANGES option.

ChangeTableVersionTableReference

CHANGETABLE clause with VERSION option.

ChangeTrackingDatabaseOption

CHANGE_TRACKING option in ALTER DATABASE statement, SET case

ChangeTrackingFullTextIndexOption

Represents CHANGE_TRACKING option in FULLTEXT INDEX statement.

ChangeTrackingOptionDetail

One detail for ChangeTrackingDatabaseOption

CharacterSetPayloadOption

Represents CHARACTER_SET payload option

CheckConstraintDefinition

Represents the check constraint.

CheckpointStatement

Represents the checkpoint statement.

ChildObjectName

Represents the name of a schema object child.

CloseCursorStatement

Close cursor statement

CloseMasterKeyStatement

Close master key statement.

CloseSymmetricKeyStatement

Close symmetric key statement.

CoalesceExpression

Represents the coalesce expression.

ColumnDefinition

This fragment represents a column definition

ColumnDefinitionBase

Represents most basic column definition

ColumnEncryptionAlgorithmNameParameter

Parameter representing the encryption algorithm used to encrypt the column encryption key

ColumnEncryptionAlgorithmParameter

Single parameter in column definition for column encryption algorithm used to encrypt the column

ColumnEncryptionDefinition

Class representing the encryption properties for a column

ColumnEncryptionDefinitionParameter

Single encryption parameter for a column

ColumnEncryptionKeyNameParameter

Parameter representing the column encryption key used to encrypt the column

ColumnEncryptionKeyStatement

Base class for all Column Encryption Key statement objects

ColumnEncryptionKeyValue

Class representing the value of a column encryption key encrypted with column master key

ColumnEncryptionKeyValueParameter

Single parameter in of a column encryption key value

ColumnEncryptionTypeParameter

Single parameter in column definition for column encryption type

ColumnMasterKeyNameParameter

Parameter representing the column master key used to encrypt the column encrytion key

ColumnMasterKeyParameter

Single parameter in CREATE COLUMN MASTER KEY statement

ColumnMasterKeyPathParameter

Parameter representing path of the key in the key store provider

ColumnMasterKeyStoreProviderNameParameter

Key store provider parameter protecting the column master key

ColumnReferenceExpression

This class represents a column. Because of the ambiguity of Sql syntax, we can not distiguish columns from properties without having the Table and type definitions, even then it could be ambiguous. So the column might have trailing properties in the Identifiers.

ColumnStorageOptions

Represents column storage options.

ColumnWithSortOrder

Represents a column identifier with a sort order.

CommandSecurityElement80

Represents the security element that has commands.

CommitTransactionStatement

Represents the commit transaction statement.

CommonTableExpression

This class represents the common table expression.

CompositeGroupingSpecification

Composes a list of sub-specifications.

CompressionDelayIndexOption

Represents the compression delay index option that can be an expression with an optional minute/minutes time unit.

CompressionEndpointProtocolOption

Represents PORTS HTTP endpoint protocol option

CompressionPartitionRange

Represents a single range in DATA_COMPRESSION option.

ComputeClause

Represents the compute by clause that can be used in statements like select.

ComputeFunction

Represents compute function that can be used in compute clause.

ConstraintDefinition

Represents base class for constraints.

ContainmentDatabaseOption

Database option for containment

ContinueStatement

Represents the continue statement.

ContractMessage

Represents information about single message in CREATE CONTRACT statement

ConvertCall

Represents the convert call.

CreateAggregateStatement

Represents CREATE AGGREGATE statement

CreateApplicationRoleStatement

Represents the create application role statement.

CreateAssemblyStatement

Represents the CREATE ASSEMBLY statement.

CreateAsymmetricKeyStatement

Represents CREATE ASYMMETRIC KEY statement

CreateAvailabilityGroupStatement

Represents the CREATE AVAILABILITY GROUP statement

CreateBrokerPriorityStatement

Represents the Create Broker Priority statement.

CreateCertificateStatement

Represents CREATE CERTIFICATE statement

CreateColumnEncryptionKeyStatement

Represents a CREATE COLUMN ENCRYPTION KEY statement

CreateColumnMasterKeyStatement

Represents a CREATE COLUMN MASTER KEY statement

CreateColumnStoreIndexStatement

Represents the create column store index statement.

CreateContractStatement

Represents CREATE CONTRACT statement

CreateCredentialStatement

Represents CREATE CREDENTIAL statement

CreateCryptographicProviderStatement

Represents the Create Cryptographic Provider statement.

CreateDatabaseAuditSpecificationStatement

Creates database audit specification.

CreateDatabaseEncryptionKeyStatement

Creates database encryption key

CreateDatabaseStatement

Represents CREATE DATABASE statement

CreateDefaultStatement

Represents the Create Default statement.

CreateEndpointStatement

Represents CREATE ENDPOINT statement

CreateEventNotificationStatement

Represents the create event notification statement.

CreateEventSessionStatement

Represents the Create Event Session statement.

CreateExternalDataSourceStatement

Represents a CREATE EXTERNAL DATA SOURCE statement.

CreateExternalFileFormatStatement

Represents a CREATE EXTERNAL FILE FORMAT statement.

CreateExternalResourcePoolStatement

Represents the Create External Resource Pool statement.

CreateExternalTableStatement

Represents a CREATE EXTERNAL TABLE statement.

CreateFederationStatement

Represents the CREATE FEDERATION statement

CreateFullTextCatalogStatement

Represents CREATE FULLTEXT CATALOG statement

CreateFullTextIndexStatement

Represents the create fulltext index statement.

CreateFullTextStopListStatement

Represents the Create FullText StopList statement.

CreateFunctionStatement

Represents the Create Function statement.

CreateIndexStatement

Represents the create index statement.

CreateLoginSource

Base class for different login sources in CREATE LOGIN statement

CreateLoginStatement

Represents CREATE LOGIN statement.

CreateMasterKeyStatement

Represents CREATE MASTER KEY statement.

CreateMessageTypeStatement

Represents CREATE MESSAGE TYPE statement

CreateOrAlterFunctionStatement

Represents the Create Or Alter Function statement.

CreateOrAlterProcedureStatement

The create or alter procedure statement.

CreateOrAlterTriggerStatement

The CREATE OR ALTER TRIGGER statement.

CreateOrAlterViewStatement

The CREATE OR ALTER VIEW statement.

CreatePartitionFunctionStatement

Represents CREATE PARTITION FUNCTION statement

CreatePartitionSchemeStatement

Represents CREATE PARTITION SCHEME statement

CreateProcedureStatement

The create procedure statement.

CreateQueueStatement

Represents create queue statement.

CreateRemoteServiceBindingStatement

Represents CREATE REMOTE SERVICE BINDING statement

CreateResourcePoolStatement

Represents the Create Resource Pool statement.

CreateRoleStatement

Represents the create role statement.

CreateRouteStatement

Represents create route statement.

CreateRuleStatement

Represents the Create Rule statement.

CreateSchemaStatement

Represents the create schema statement.

CreateSearchPropertyListStatement

Represents CREATE SEARCH PROPERTY LIST statement

CreateSecurityPolicyStatement

Represents a CREATE SECURITY POLICY statement

CreateSelectiveXmlIndexStatement

Represents the create selective xml index statement.

CreateSequenceStatement

Represents CREATE SEQUENCE statement

CreateServerAuditSpecificationStatement

Creates server audit specification.

CreateServerAuditStatement

Creates server audit.

CreateServerRoleStatement

Represents the CREATE SERVER ROLE statement.

CreateServiceStatement

Represents CREATE SERVICE statement

CreateSpatialIndexStatement

Represents the Create Spatial Index statement.

CreateStatisticsStatement

Represents the create statistics statement.

CreateSymmetricKeyStatement

Represents CREATE SYMMETRIC KEY statement

CreateSynonymStatement

Represents the create synonym statement.

CreateTableStatement

Represents Create Table statement

CreateTriggerStatement

The CREATE TRIGGER statement.

CreateTypeStatement

Represents the create type statement.

CreateTypeTableStatement

Creates table type

CreateTypeUddtStatement

Represents the create type statement for user defined data types, the one that derive from Sql types.

CreateTypeUdtStatement

Represents the create type statement for user defined types, the one that derive from CLR types.

CreateUserStatement

Represents the create user statement.

CreateViewStatement

The CREATE VIEW statement.

CreateWorkloadGroupStatement

Represents the Create Workload Group statement.

CreateXmlIndexStatement

Represents the create xml index statement.

CreateXmlSchemaCollectionStatement

Represents the create xml schema collection statement.

CreationDispositionKeyOption

Represents CREATION_DISPOSITION option.

CredentialStatement

Represents common parts of ALTER and CREATE CREDENTIAL statement

CryptoMechanism

Represents the decryption mechanism.

CubeGroupingSpecification

Represents CUBE grouping specification.

CursorDefaultDatabaseOption

CURSOR_DEFAULT option in ALTER DATABASE statement, SET case

CursorDefinition

Represents cursor definition

CursorId

Represents reference to cursor

CursorOption

Represents a cursor option.

CursorStatement

Base type for open/close/fetch cursor statements

DatabaseAuditAction

Represents a single action in audit action specification.

DatabaseConfigurationClearOption

Single option in ALTER DATABASE SCOPED CONFIGURATION statement, CLEAR option

DatabaseConfigurationSetOption

Single option in ALTER DATABASE SCOPED CONFIGURATION statement, SET option

DatabaseEncryptionKeyStatement

Base class for statements dealing with encryption key.

DatabaseOption

Single option in ALTER DATABASE statement, SET case

DataCompressionOption

Represents a single data compression option.

DataModificationSpecification

Base class for common options of data modification specifications.

DataModificationStatement

Represents a data modification statement.

DataModificationTableReference

Represents sub-dml with output clause which serves as table reference.

DataTypeReference

The base data type class.

DataTypeSequenceOption

Represents sequence Option that defines the data type

DbccNamedLiteral

Represents named literal in DBCC statement

DbccOption

Represents a dbcc option.

DbccStatement

Represents DBCC statement (all variants)

DeallocateCursorStatement

Deallocate cursor statement

DeclareCursorStatement

Represents DECLARE CURSOR statement

DeclareTableVariableBody

Represents the body of the declare @variable table variation.

DeclareTableVariableStatement

This class represents the declare @variable statement's table variation.

DeclareVariableElement

This class represents a single declaration in the body of DeclareVariableStatement.

DeclareVariableStatement

This statement represents declare @variable statement except table declarations.

DefaultConstraintDefinition

Represents the default constraint.

DefaultLiteral

Represents the literal for DEFAULT

DelayedDurabilityDatabaseOption

Database option for delayed durability

DeleteMergeAction

Represents delete merge action

DeleteSpecification

The properties for Delete

DeleteStatement

Represents the delete statement.

DenyStatement

Represents the deny statement.

DenyStatement80

Represents the deny statement.

DeviceInfo

Represents information about device used for backup or restore

DialogOption

Represents a dialog option.

DiskStatement

Represents the DISK statement.

DiskStatementOption

Represents disk statement option.

DropAggregateStatement

Represents DROP AGGREGATE statement

DropAlterFullTextIndexAction

Represents DROP action for ALTER FULLTEXT INDEX statement.

DropApplicationRoleStatement

Represents DROP APPLICATION ROLE statement.

DropAssemblyStatement

Represents DROP ASSEMBLY statement

DropAsymmetricKeyStatement

Represents DROP ASYMMETRIC KEY statement.

DropAvailabilityGroupStatement

Represents the DROP AVAILABILITY GROUP statement.

DropBrokerPriorityStatement

Represents the Drop Broker Priority statement.

DropCertificateStatement

Represents DROP CERTIFICATE statement.

DropChildObjectsStatement

Represents DROP which has child objects (DROP INDEX or STATISTICS)

DropClusteredConstraintMoveOption

The drop clustered constraint move option

DropClusteredConstraintOption

The abstract base class for drop clustered constraints.

DropClusteredConstraintStateOption

The abstract base class for drop clustered constraints.

DropClusteredConstraintValueOption

The drop clustered constraint option with value specified

DropClusteredConstraintWaitAtLowPriorityLockOption

The drop clustered constraint wait at low priority lock option

DropColumnEncryptionKeyStatement

Represents a DROP COLUMN ENCRYPTION KEY statement

DropColumnMasterKeyStatement

Represents a DROP COLUMN MASTER KEY statement

DropContractStatement

Represents DROP CONTRACT statement.

DropCredentialStatement

Represents DROP CREDENTIAL statement.

DropCryptographicProviderStatement

Represents the Drop Cryptographic Provider statement.

DropDatabaseAuditSpecificationStatement

Represents DROP DATABASE AUDIT SPECIFICATION statement.

DropDatabaseEncryptionKeyStatement

Drops database encryption key.

DropDatabaseStatement

Represents DROP DATABASE statement

DropDefaultStatement

Represents DROP DEFAULT statement

DropEndpointStatement

Represents DROP ENDPOINT statement.

DropEventNotificationStatement

Represents DROP EVENT NOTIFICATION statement.

DropEventSessionStatement

Represents the Drop Event Session statement.

DropExternalDataSourceStatement

Represents a DROP EXTERNAL DATA SOURCE statement.

DropExternalFileFormatStatement

Represents a DROP EXTERNAL FILE FORMAT statement.

DropExternalResourcePoolStatement

Represents the Drop External Resource Pool statement.

DropExternalTableStatement

Represents a DROP EXTERNAL TABLE statement.

DropFederationStatement

Represents the DROP FEDERATION statement.

DropFullTextCatalogStatement

Represents DROP FULLTEXT CATALOG statement.

DropFullTextIndexStatement

Represents DROP FULLTEXT INDEX statement.

DropFullTextStopListStatement

Represents the Drop Fulltext Stoplist statement.

DropFunctionStatement

Represents DROP FUNCTION statement

DropIndexClause

Represents relational or xml index in DROP INDEX statement

DropIndexClauseBase

Represents single clause in DROP INDEX statement

DropIndexStatement

Represents DROP INDEX statement

DropLoginStatement

Represents DROP LOGIN statement.

DropMasterKeyStatement

Represents DROP MASTER KEY statement.

DropMemberAlterRoleAction

Represents the drop member alter role action.

DropMessageTypeStatement

Represents DROP MESSAGE TYPE statement.

DropObjectsStatement

Represents DROP statement which references list of objects

DropPartitionFunctionStatement

Represents DROP PARTITION FUNCTION statement.

DropPartitionSchemeStatement

Represents DROP PARTITION SCHEME statement.

DropProcedureStatement

Represents DROP PROCEDURE statement

DropQueueStatement

Represents DROP QUEUE statement.

DropRemoteServiceBindingStatement

Represents DROP REMOTE SERVICE BINDING statement.

DropResourcePoolStatement

Represents the Drop Resource Pool statement.

DropRoleStatement

Represents DROP ROLE statement.

DropRouteStatement

Represents DROP ROUTE statement.

DropRuleStatement

Represents DROP RULE statement

DropSchemaStatement

Represents DROP SCHEMA statement

DropSearchPropertyListAction

The DROP search property list action

DropSearchPropertyListStatement

Represents DROP SEARCH PROPERTY LIST statement

DropSecurityPolicyStatement

Represents a DROP SECURITY POLICY statement

DropSequenceStatement

Represents DROP SEQUENCE statement

DropServerAuditSpecificationStatement

Represents DROP SERVER AUDIT SPECIFICATION statement.

DropServerAuditStatement

Drops server audit.

DropServerRoleStatement

Represents the DROP SERVER ROLE statement.

DropServiceStatement

Represents DROP SERVICE statement.

DropSignatureStatement

Represents DROP SIGNATURE statements.

DropStatisticsStatement

Represents DROP STATISTICS statement

DropSymmetricKeyStatement

Represents DROP SYMMETRIC KEY statement.

DropSynonymStatement

Represents DROP SYNONYM statement

DropTableStatement

Represents DROP TABLE statement

DropTriggerStatement

Represents DROP TRIGGER statement

DropTypeStatement

Represents DROP TYPE statement.

DropUnownedObjectStatement

Represents DROP statement for those unowned objects

DropUserStatement

Represents DROP USER statement.

DropViewStatement

Represents DROP VIEW statement

DropWorkloadGroupStatement

Represents the Drop Workload Group statement.

DropXmlSchemaCollectionStatement

Represents DROP XML SCHEMA COLLECTION statement.

DurabilityTableOption

DURABILITY table option.

EnabledDisabledPayloadOption

Represents an option which can be either ENABLED or DISABLED

EnableDisableTriggerStatement

Defines the modifications to triggers. Triggers can be enabled or disabled.

EncryptedValueParameter

Parameter representing the encrypted value of the column encryption key

EncryptionPayloadOption

Represents ENCRYPTION payload option

EncryptionSource

Base class for different key/certificates sources

EndConversationStatement

Represents END CONVERSATION statement

EndpointAffinity

Represents AFFINITY option in CREATE/ALTER ENDPOINT statements

EndpointProtocolOption

Represents single protocol option in CREATE ENDPOINT statement

EventDeclaration

Represents the event declaration

EventDeclarationCompareFunctionParameter

Represents the event declaration predicate parameter

EventDeclarationSetParameter

Represents the event declaration set parameter

EventGroupContainer

Represents event type

EventNotificationObjectScope

Represents scope of event notification.

EventRetentionSessionOption

Represents the EVENT_RETENTION_MODE session option

EventSessionObjectName

Represents object names used in CREATE and ALTER EVENT SESSION statements.

EventSessionStatement

Represents the CREATE and ALTER EVENT SESSION statement.

EventTypeContainer

Represents event type

EventTypeGroupContainer

Represents event type or group

ExecutableEntity

Base class for all possible things which can be executed with EXECUTE statement.

ExecutableProcedureReference

Represents a reference to a procedure in execute.

ExecutableStringList

Strings representing commands passed to EXECUTE statement.

ExecuteAsClause

Represents the execute as clause.

ExecuteAsFunctionOption

The execute as function option

ExecuteAsProcedureOption

The execute as procedure option

ExecuteAsStatement

Represents EXECUTE AS statement

ExecuteAsTriggerOption

The EXECUTE AS trigger option

ExecuteContext

Represents the security context for execute statements

ExecuteInsertSource

Represents the insert source for EXECUTE.

ExecuteOption

Represents an option to the execute statement

ExecuteParameter

Parameter passed to procedure in EXECUTE statement

ExecuteSpecification

Represents a call to EXECUTE

ExecuteStatement

Represents the EXECUTE T-SQL statement

ExistsPredicate

Represents the exists predicate.

ExpressionCallTarget

Represents an expression target of a function call.

ExpressionGroupingSpecification

An expression on which the grouping operation is performed.

ExpressionWithSortOrder

This class represents an expression with a sort order.

ExternalDataSourceLiteralOrIdentifierOption

Represents property of type Literal or Identifier.

ExternalDataSourceOption

CREATE EXTERNAL DATA SOURCE statement optional property.

ExternalDataSourceStatement

Base class for all external data source statement objects.

ExternalFileFormatContainerOption

Represents a list of external file format suboptions.

ExternalFileFormatLiteralOption

Represents any property value of type Literal.

ExternalFileFormatOption

CREATE EXTERNAL FILE FORMAT statement optional property.

ExternalFileFormatStatement

Base class for all external file format statement objects.

ExternalFileFormatUseDefaultTypeOption

Represents the USE_DEFAULT_TYPE optional property value.

ExternalResourcePoolAffinitySpecification

Represents the external resource pool statement affinity specification.

ExternalResourcePoolParameter

Represents the external resource pool statement parameters.

ExternalResourcePoolStatement

Represents Create and Alter External Resource Pool Statement.

ExternalTableColumnDefinition

Represents most basic column definition.

ExternalTableDistributionOption

The external table DISTRIBUTION option for external tables on shard map manager data sources.

ExternalTableDistributionPolicy

Base class for external table distribution policies.

ExternalTableLiteralOrIdentifierOption

An external table with clause option that expects a literal or identifer as the value being set.

ExternalTableOption

A single external table option.

ExternalTableRejectTypeOption

The external table REJECT_TYPE option for external tables on HDFS data sources.

ExternalTableReplicatedDistributionPolicy

Representation of the REPLICATED option for an external table distribution policy.

ExternalTableRoundRobinDistributionPolicy

Representation of the ROUND_ROBIN option for an external table distribution policy.

ExternalTableShardedDistributionPolicy

Representation of the SHARDED option for an external table distribution policy.

ExternalTableStatement

Base class for all external table statement objects.

ExtractFromExpression

Represents the expression that start with Extract from.

FailoverModeReplicaOption

Represents the replica option for failover mode.

FederationScheme

This class stores the federation scheme for a table

FetchCursorStatement

Represents FETCH cursor statement

FetchType

Holds information about different fetch orientations

FileDeclaration

Represents single file declaration in CREATE DATABASE statement

FileDeclarationOption

Represents single file declaration option in CREATE DATABASE statement

FileEncryptionSource

Represents reference to a (executable) file containing key or certificate

FileGroupDefinition

Represent filegroup in CREATE DATABASE statement

FileGroupOrPartitionScheme

Represents a filegroup or a partition scheme.

FileGrowthFileDeclarationOption

The file declaration option for FILEGROWTH.

FileNameFileDeclarationOption

The file declaration option for FILENAME.

FileStreamDatabaseOption

FILESTREAM option in create and alter database.

FileStreamOnDropIndexOption

Represents the FILESTREAM_ON option in DROP INDEX

FileStreamOnTableOption

Filestream_on table option.

FileStreamRestoreOption

Represents the FileStream option in a restore statement.

FileTableCollateFileNameTableOption

FILETABLE_COLLATE_FILENAME table option.

FileTableConstraintNameTableOption

FILETABLE_PRIMARY_KEY_CONSTRAINT_NAME, FILETABLE_STREAMID_UNIQUE_CONSTRAINT_NAME, or FILETABLE_FULLPATH_UNIQUE_CONSTRAINT_NAME table option.

FileTableDirectoryTableOption

FILETABLE_DIRECTORY table option.

ForceSeekTableHint

Represents forceseek hint.

ForClause

Base class for different FOR clauses in SELECT

ForeignKeyConstraintDefinition

Represents the foreign key constraint.

FromClause

Represents the From clause in a QuerySpecification

FullTextCatalogAndFileGroup

Represents catalog / filegroup option in CREATE FULLTEXT STATEMENT.

FullTextCatalogOption

Base class for fulltext catalog options.

FullTextCatalogStatement

Represents CREATE FULLTEXT CATALOG statement

FullTextIndexColumn

Represents the column for a fulltext index.

FullTextIndexOption

Represents a single option in CREATE FULLTEXT INDEX statement.

FullTextPredicate

Represents the fulltext predicate.

FullTextStopListAction

Represents the action in Alter Fulltext Stoplist Statement.

FullTextTableReference

Represents FREETEXTTABLE and CONTAINSTABLE table references.

FunctionCall

Represents a function call.

FunctionCallSetClause

Represents SET clause for function calls.

FunctionOption

Represents a Function Option

FunctionReturnType

Base class for function return type

FunctionStatementBody

Represents CREATE/ALTER FUNCTION statement

GeneralSetCommand

To be broken into separate classes - when we would have time. For now, represents single command in a SET statement (e.g. set !language us_english!)

GenericConfigurationOption

Option which can be set to a signed integer, string literal, identifier or the keywords ON/OFF/PRIMARY.

GetConversationGroupStatement

Represents GET CONVERSATION GROUP statement

GlobalFunctionTableReference

This class represents the set of global built in functions which do not belong to a schema.

GlobalVariableExpression

Represents a global variable expression

GoToStatement

Represents the goto statement.

GrandTotalGroupingSpecification

Represents ( ) (grand total) grouping specification.

GrantStatement

Represents the grant statement.

GrantStatement80

Represents the grant statement.

GraphMatchExpression

A boolean expression for a MATCH expression

GraphMatchPredicate

A boolean expression for MATCH

GridParameter

Represents the spatial index structured parameter for GRIDS option.

GridsSpatialIndexOption

Represents the GRIDS spatial index option.

GroupByClause

Represents the group by clause that can be used in statements like select, update.

GroupingSetsGroupingSpecification

Represents GROUPING SETS grouping specification.

GroupingSpecification

Represents a single grouping specification in GROUP BY clause.

HadrAvailabilityGroupDatabaseOption

Database option for hadr availability group

HadrDatabaseOption

Database option for HADR.

HavingClause

Represents the having clause that can be used in statements like select.

Identifier

This fragment is used to represent an identifier

IdentifierAtomicBlockOption

Option which be set to an identifier in BEGIN ATOMIC…END statement

IdentifierDatabaseOption

Database option with an identifier value

IdentifierLiteral

Represents an identifier that is treated as a literal.

IdentifierOrScalarExpression

Represents either an Identifer or ScalarExpression

IdentifierOrValueExpression

Represents either an Identifer or ValueExpression

IdentifierPrincipalOption

Options with identifier value in CREATE or ALTER LOGIN or USER statement

IdentifierSnippet

Placeholder for an arbitrary identifier.

IdentityFunctionCall

This class represents the identity function that can be used in a SelectColumn.

IdentityOptions

Represents Identity Options for a Column

IdentityValueKeyOption

Represents IDENTITY_VALUE option.

IfStatement

Represents the if statement.

IgnoreDupKeyIndexOption

Represents the ignore_dup_key index option.

IIfCall

Represents the iif expression.

IndexDefinition

Represents the base for index definitions.

IndexExpressionOption

Represents the index option that could be an expression.

IndexOption

Represents the index option.

IndexStatement

Represents the base for create index statements.

IndexStateOption

Represents the index option that could be on or off.

IndexTableHint

Represents INDEX table hint.

IndexType

Represents an index type

InlineDerivedTable

This node represents a derived table.

InlineResultSetDefinition

Represents the inline definition of a result set

InPredicate

Represents the in predicate.

InsertBulkColumnDefinition

Represents column definition in INSERT BULK statement (?)

InsertBulkStatement

Represents INSERT BULK statement (BCP syntax)

InsertMergeAction

Represents insert merge action

InsertSource

Base class for source nodes of insert statements.

InsertSpecification

The properties for Insert

InsertStatement

Represents the insert statement.

IntegerLiteral

Represents an Integer literal.

InternalOpenRowset

Represents OPENROWSET table reference - undocumented case.

IPv4

Represents IP address (x.x.x.x)

JoinParenthesisTableReference

Represents the parenthesis that can encapsulate a join.

JoinTableReference

Base class for JOIN table references

JsonForClause

Represents FOR JSON (options) case

JsonForClauseOption

Represents FOR JSON (options) case

KeyOption

Represents key option in CREATE SYMMETRIC KEY statement.

KeySourceKeyOption

Represents KEY_SOURCE option.

KillQueryNotificationSubscriptionStatement

Represents the kill query notification subscription statement.

KillStatement

Represents the kill statement.

KillStatsJobStatement

Represents the kill stats job statement.

LabelStatement

Represents the label statement.

LeftFunctionCall

Represents LEFT call.

LikePredicate

Represents the like predicate.

LineNoStatement

Represents the lineno statement.

ListenerIPEndpointProtocolOption

Represents LISTENER_IP TCP endpoint protocol option

Literal

Represents a literal constant.

LiteralAtomicBlockOption

Option which be set to a value in BEGIN ATOMIC…END statement

LiteralAuditTargetOption

Audit option with a literal value.

LiteralAvailabilityGroupOption

Availability group option with a literal value.

LiteralBulkInsertOption

Represents simple single option in BULK INSERT statement.

LiteralDatabaseOption

Database option with a literal value

LiteralEndpointProtocolOption

Represents an option which has single string or integer value

LiteralOptimizerHint

Represents optimizer hint, which can be represented as flag with optional literal value.

LiteralOptionValue

Represents the literal value of an option.

LiteralPayloadOption

Represents payload option with a single literal value

LiteralPrincipalOption

Literal option in CREATE/ALTER LOGIN/USER statement

LiteralRange

Represents a single literal or a range of literals.

LiteralReplicaOption

Represents a replica option with a literal value.

LiteralSessionOption

Represents the MAX_MEMORY event session option

LiteralStatisticsOption

Represents the statistics option.

LiteralTableHint

Represents table hint with literal value.

LockEscalationTableOption

Lock escalation table option.

LoginTypePayloadOption

Represents LOGIN_TYPE payload option

LowPriorityLockWaitAbortAfterWaitOption

Represents the action of the low priority lock wait option.

LowPriorityLockWaitMaxDurationOption

Represents the max duration of the low priority lock wait option.

LowPriorityLockWaitOption

Represents the low priority lock wait option.

LowPriorityLockWaitTableSwitchOption

Represents the low priority lock wait option for alter table switch statement.

MasterKeyStatement

Represents the master key statement.

MaxDispatchLatencySessionOption

Represents the MAX_DISPATCH_LATENCY event session option

MaxDopConfigurationOption

MAXDOP option in ALTER DATABASE SCOPED CONFIGURATION statement

MaxDurationOption

Represents the max duration option.

MaxLiteral

Represents the MAX literal.

MaxRolloverFilesAuditTargetOption

MAX_ROLLOVER_FILES audit target option.

MaxSizeAuditTargetOption

MaxSize option in case of FILE audit target.

MaxSizeDatabaseOption

MAXSIZE option in create and alter database for Azure.

MaxSizeFileDeclarationOption

The file declaration value for MAXSIZE.

MemoryOptimizedTableOption

MEMORY_OPTIMIZED table option.

MemoryPartitionSessionOption

Represents the MEMORY_PARTITION_MODE session option

MergeAction

Represents action in merge statement

MergeActionClause

The condition and action to take for merge.

MergeSpecification

The merge specification.

MergeStatement

Represents the MERGE statement.

MessageTypeStatementBase

Represents common parts of CREATE and ALTER MESSAGE TYPE statements

MethodSpecifier

Represents the method specifier.

MirrorToClause

Represents MIRROR TO clause BACKUP statement

MoneyLiteral

Represents a Money literal.

MoveConversationStatement

Represents MOVE CONVERSATION statement

MoveRestoreOption

Represents MOVE restore option

MoveToDropIndexOption

Represents the Move To option in DROP INDEX

MultiPartIdentifier

Represents a multi-part identifier.

MultiPartIdentifierCallTarget

Represents target of a call which is a column or CLR property on a column.

NamedTableReference

The table reference to a CTE or schema object.

NameFileDeclarationOption

The file declaration option for NAME or NEWNAME.

NextValueForExpression

Represents the NEXT VALUE FOR expression.

NullableConstraintDefinition

Represents the nullable constraint.

NullIfExpression

Represents the nullif expression.

NullLiteral

Represents a null literal.

NumericLiteral

Represents a Numeric literal.

OdbcConvertSpecification

Represents the Odbc convert specification.

OdbcFunctionCall

Represents the ODBC function call.

OdbcLiteral

Represents an odbc formatted literal.

OdbcQualifiedJoinTableReference

Represents the odbc qualified join in a from clause.

OffsetClause

This class represents an offset/fetch filter, that can be used in select statements for paging the result set.

OnFailureAuditOption

ON_FAILURE option in CREATE/ALTER SERVER AUDIT statement.

OnlineIndexLowPriorityLockWaitOption

Represents the low priority lock wait suboption for online index option.

OnlineIndexOption

Represents the online option.

OnOffAssemblyOption

Represents an on/off assembly option.

OnOffAtomicBlockOption

Option which be set to an OptionState in BEGIN ATOMIC…END statement

OnOffAuditTargetOption

RESERVE_DISK_SPACE option in case of FILE audit target.

OnOffDatabaseOption

Option which can be set to ON or OFF, in CREATE/ALTER DATABASE statement.

OnOffDialogOption

Represents ON/OFF dialog options.

OnOffFullTextCatalogOption

Represents ON/OFF fulltext catalog options.

OnOffOptionValue

Represents either an ON or OFF option value.

OnOffPrimaryConfigurationOption

Option which can be set to ON or OFF or PRIMARY.

OnOffPrincipalOption

Security option in CREATE or ALTER LOGIN or USER statement

OnOffRemoteServiceBindingOption

The remote service binding option for ON/OFF options.

OnOffSessionOption

Represents the TRACK_CAUSALITY and STARTUP_STATE event session option

OnOffStatisticsOption

Represents new-style on-off options.

OpenCursorStatement

Open cursor statement

OpenJsonTableReference

Represents OPENJSON table reference

OpenMasterKeyStatement

Open master key statement.

OpenQueryTableReference

Represents OPENQUERY table reference.

OpenRowsetTableReference

Represents OPENROWSET table reference.

OpenSymmetricKeyStatement

Open symmetric key statement.

OpenXmlTableReference

Represents OPENXML table reference

OptimizeForOptimizerHint

Represents OPTIMIZE FOR optimizer hint

OptimizerHint

Represents single optimizer hint

OptionValue

Represents an option value.

OrderBulkInsertOption

Represents ORDER option in BULK INSERT statement.

OrderByClause

Represents the order by clause that can be used in statements like select.

OrderIndexOption

Represents the order option.

OutputClause

Represents the output clause.

OutputIntoClause

Represents the OutputInto Clause

OverClause

Represents the over clause.

PageVerifyDatabaseOption

PAGE_VERIFY option in ALTER DATABASE statement, SET case

ParameterizationDatabaseOption

PARAMETERIZATION option in ALTER DATABASE statement, SET case

ParameterizedDataTypeReference

The data type abstract class that can have parameters.

ParameterlessCall

Represents calls without the parenthesis and parameters.

ParenthesisExpression

Represents an expression enclosed in parentheses.

ParseCall

Represents the parse function call.

ParseError

This class reports the error that occured during parsing.

PartitionFunctionCall

Represents the partition function call.

PartitionParameterType

Parameter type in CREATE PARTITION FUNCTION statement

PartitionSpecifications

Represents the specifications for a table partition.

PartitionSpecifier

Represents a partition specifier as expression or ALL.

PartnerDatabaseOption

PARTNER option in ALTER DATABASE statement, SET case

PasswordAlterPrincipalOption

PASSWORD option in ALTER LOGIN statement

PasswordCreateLoginSource

Password case in CREATE LOGIN statement

PayloadOption

Represents a single payload option in CREATE / ALTER ENDPOINT statement

Permission

Represents the permission that can be used in security statement body.

PermissionSetAssemblyOption

Represents the PERMISSION_SET assembly option.

PivotedTableReference

Represents the pivoted table reference in a from clause.

PortsEndpointProtocolOption

Represents PORTS HTTP endpoint protocol option

PredicateSetStatement

Represents the various Set {...} { ON | OFF } options in the TSQL grammar.

PrimaryExpression

Represents the abstract base class for primary expressions.

PrimaryRoleReplicaOption

Represents the replica option for primary role.

PrincipalOption

Single option in CREATE or ALTER LOGIN or USER statement

PrintStatement

Represents the print statement.

Privilege80

Represents a privilage that can be used in a security statement.

PrivilegeSecurityElement80

Represents the security element that has priviliges.

ProcedureOption

Represents a Procedure Option

ProcedureParameter

This class represents a parameter that can be passed into a procedure.

ProcedureReference

Reference to procedure by name and number

ProcedureReferenceName

Represents a procedure by name, either as a ProcedureReference or contained within a variable.

ProcedureStatementBody

Represents CREATE/ALTER PROCEDURE statement.

ProcedureStatementBodyBase

Represents common propeties in CREATE/ALTER PROC/FUNCTION statements

ProcessAffinityRange

Represents a single process affinity range in ALTER SERVER CONFIGURATION statement.

ProviderEncryptionSource

Represents reference to a EKM provider.

ProviderKeyNameKeyOption

Represents PROVIDER_KEY_NAME option.

QualifiedJoin

Represents the qualified join in a from clause.

QueryDerivedTable

This node represents a derived table.

QueryExpression

This class is an abstract base class for the query expression hierarchy in select statement.

QueryParenthesisExpression

This class represents the parenthesis expression that wraps a QueryExpression.

QuerySpecification

This class represents the major part of the select statement.

QueryStoreCapturePolicyOption

Capture Policy part of QueryStore Options

QueryStoreDatabaseOption

Query Store (QDS) option in ALTER DATABASE statement, SET case

QueryStoreDataFlushIntervalOption

Data Flush Interval part of QueryStore Options

QueryStoreDesiredStateOption

Desired State part of QueryStore Options

QueryStoreIntervalLengthOption

Runtime Stats Interval length part of QueryStore Options

QueryStoreMaxPlansPerQueryOption

Max Plans Per Query part of QueryStore Options

QueryStoreMaxStorageSizeOption

Max Storage Size part of QueryStore Options

QueryStoreOption

A single query store option.

QueryStoreSizeCleanupPolicyOption

Size Based Cleanup Policy part of QueryStore Options

QueryStoreTimeCleanupPolicyOption

Time based Cleanup Policy part of QueryStore Options

QueueDelayAuditOption

QUEUE_DELAY option in CREATE/ALTER SERVER AUDIT statement.

QueueExecuteAsOption

The queue option for execute as.

QueueOption

Represents the queue option.

QueueProcedureOption

The queue option for procedure.

QueueStatement

Represents the base for queue statements.

QueueStateOption

Represents the base for queue option that has a state.

QueueValueOption

The queue option with a value.

RaiseErrorLegacyStatement

Represents the legacy style raiserror statement.

RaiseErrorStatement

Represents the raiserror statement.

ReadOnlyForClause

Represents FOR READ ONLY case used only in DECLARE CURSOR

ReadTextStatement

Represents the readtext statement.

RealLiteral

Represents a Real literal.

ReceiveStatement

Represents RECEIVE statement

ReconfigureStatement

Represents the reconfigure statement.

RecoveryDatabaseOption

RECOVERY option in ALTER DATABASE statement, SET case

RemoteDataArchiveAlterTableOption

REMOTE_DATA_ARCHIVE table option for alter.

RemoteDataArchiveDatabaseOption

REMOTE_DATA_ARCHIVE create / alter database options.

RemoteDataArchiveDatabaseSetting

REMOTE_DATA_ARCHIVE DB-level settings

RemoteDataArchiveDbCredentialSetting

CREDENTIAL setting for REMOTE_DATA_ARCHIVE

RemoteDataArchiveDbFederatedServiceAccountSetting

FEDERATED_SERVICE_ACCOUNT setting for REMOTE_DATA_ARCHIVE

RemoteDataArchiveDbServerSetting

SERVER setting for REMOTE_DATA_ARCHIVE

RemoteDataArchiveTableOption

REMOTE_DATA_ARCHIVE table option for create and alter.

RemoteServiceBindingOption

A remote service binding option.

RemoteServiceBindingStatementBase

Represents common base for CREATE and ALTER REMOTE SERVICE BINDING statements

RenameAlterRoleAction

Represents the rename alter role action.

ResampleStatisticsOption

Represents the resample statistics option that supports specifying a list of partition ranges on which to resample.

ResourcePoolAffinitySpecification

Represents the resource pool statement affinity specification.

ResourcePoolParameter

Represents the resource pool statement parameters.

ResourcePoolStatement

Represents Create and Alter Resource Pool Statement.

RestoreMasterKeyStatement

Represents RESTORE MASTER KEY statement

RestoreOption

Represents a single option in RESTORE statement

RestoreServiceMasterKeyStatement

Represents RESTORE SERVICE MASTER KEY statement

RestoreStatement

Represents RESTORE/LOAD statement

ResultColumnDefinition

Represents the column definition of a result set

ResultSetDefinition

The definition of an individual result set

ResultSetsExecuteOption

The results set description for EXECUTE statements

RetentionPeriodDefinition

Definition of retention period for system versioned temporal table.

ReturnStatement

Represents return statement

RevertStatement

Represents REVERT statement

RevokeStatement

Represents the revoke statement.

RevokeStatement80

Represents the revoke statement.

RightFunctionCall

Represents RIGHT call.

RolePayloadOption

Represents ROLE payload option

RoleStatement

Represents the role statement base.

RollbackTransactionStatement

Represents the rollback transaction statement.

RollupGroupingSpecification

Represents ROLLUP grouping specification.

RouteOption

Represents the for route option.

RouteStatement

Represents the base for route statements.

RowValue

Represents data for a single row.

SaveTransactionStatement

Represents the save transaction statement.

ScalarExpression

The abstract base class that represents scalar expressions.

ScalarExpressionDialogOption

Represents scalar expression dialog options.

ScalarExpressionRestoreOption

Represents single option with optional value

ScalarExpressionSequenceOption

Represents sequence option with a scalar expression.

ScalarExpressionSnippet

Placeholder for an arbitrary scalar expression.

ScalarFunctionReturnType

The return type definition for scalar-valued functions

ScalarSubquery

Represents the subquery.

SchemaDeclarationItem

Represents information about one column in schema declaration.

SchemaDeclarationItemOpenjson

Represents information about one result column in Openjson.

SchemaObjectFunctionTableReference

A table reference to a table-valued function

SchemaObjectName

Represents a schema object name.

SchemaObjectNameOrValueExpression

Represents either a SchemaObjectName or ValueExpression

SchemaObjectNameSnippet

Placeholder for an arbitrary schema object name.

SchemaObjectResultSetDefinition

Represents the result set as a reference to an existing schema object or type

SchemaPayloadOption

Represents SCHEMA payload option

SearchedCaseExpression

Represents a searched case expression.

SearchedWhenClause

Represents the when clause that is used in a searched case expression.

SearchPropertyListAction

Base class for search property list actions.

SearchPropertyListFullTextIndexOption

Represents the search property list option in FULLTEXT INDEX statement.

SecondaryRoleReplicaOption

Represents the replica option for secondary role.

SecurityElement80

Represents the security statement body that is common for Grant Deny and Revoke Statements.

SecurityPolicyOption

Represents an option in a CREATE/ALTER SECURITY POLICY statement

SecurityPolicyStatement

Base class for all Security Policy statement objects

SecurityPredicateAction

Represents a security predicate add alter or drop action.

SecurityPrincipal

Represents the principal that can be used in security statement body.

SecurityStatement

Represents the security statement body base class.

SecurityStatementBody80

Represents the security statement body base class.

SecurityTargetObject

Represents the target object that can be used in security statement body.

SecurityTargetObjectName

Represents the security target object name.

SecurityUserClause80

Represents the security statement body that is common for Grant Deny and Revoke Statements.

SelectElement

Represents an element in the SELECT clause.

SelectFunctionReturnType

The return type definition for inline table-valued functions

SelectInsertSource

Represents the insert source for SELECT.

SelectiveXmlIndexPromotedPath

Represents xml path specified in CreateSelectiveXmlIndex statement

SelectScalarExpression

The column element that is used right after the select keyword.

SelectSetVariable

This class represents the setting a variable inside a select statement.

SelectStarExpression

This represents a select * expression

SelectStatement

Represents a SELECT statement.

SelectStatementSnippet

Placeholder for an arbitrary select statement.

SemanticTableReference

Represents SEMANTICKEYPHRASETABLE, SEMANTICSIMILARITYTABLE and SEMANTICSIMILARITYDETAILSTABLE table references.

SendStatement

Represents SEND statement

SequenceOption

Represents a sequence option.

SequenceStatement

Base class for all sequence statement objects

ServerAuditStatement

Common base for CREATE and ALTER SERVER audit statements.

ServiceContract

Represents service contract reference (with optional action)

SessionOption

Represents the event session option

SessionTimeoutPayloadOption

Represents SESSION_TIMEOUT payload option

SetClause

The base class for SET clause.

SetCommand

Represents single command in a SET statement (e.g. set !language us_english!)

SetCommandStatement

Represents SET command statement (e.g. SET language us_english)

SetErrorLevelStatement

Represents SET ERRLVL statement

SetFipsFlaggerCommand

Represents SET FIPS_FLAGGER command

SetIdentityInsertStatement

Represents SET IDENTITY_INSERT statement

SetOffsetsStatement

Represents SET OFFSETS statement

SetOnOffStatement

Represents Set statement ending if { ON | OFF }

SetRowCountStatement

Represents SET ROWCOUNT statement

SetSearchPropertyListAlterFullTextIndexAction

Represents SEARCH PROPERTY LIST action for ALTER FULLTEXT INDEX statement

SetStatisticsStatement

Represents Set Statistics {...} { ON | OFF } options in the TSQL grammar.

SetStopListAlterFullTextIndexAction

Represents STOPLIST action for ALTER FULLTEXT INDEX statement.

SetTextSizeStatement

Represents SET TEXTSIZE statement

SetTransactionIsolationLevelStatement

Represents SET TRANSACTION ISOLATION LEVEL statement (?) Snapshot (?)

SetUserStatement

Represents the setuser statement.

SetVariableStatement

Represents the set @local_variable statement

ShutdownStatement

Represents the shutdown statement.

SignatureStatementBase

Represents common base for ADD and DROP SIGNATURE statements.

SimpleAlterFullTextIndexAction

Represents flag action for ALTER FULLTEXT INDEX statement.

SimpleCaseExpression

Represents a simple case expression.

SimpleWhenClause

Represents the when clause that is used in a simple case expression.

SizeFileDeclarationOption

The file declaration option for SIZE.

SoapMethod

Represents SOAP method in payload part of CREATE ENDPOINT statement

SourceDeclaration

Represents event source declaration name.

SpatialIndexOption

Represents the spatial index option.

SpatialIndexRegularOption

Specifies the spatial index regular options.

Sql100ScriptGenerator

Script generator for T-SQL 100

Sql110ScriptGenerator

Script generator for T-SQL 110

Sql120ScriptGenerator

Script generator for T-SQL 120

Sql130ScriptGenerator

Script generator for T-SQL 130

Sql140ScriptGenerator

Script generator for T-SQL 140

Sql80ScriptGenerator

Script generator for T-SQL 80

Sql90ScriptGenerator

Script generator for T-SQL 90

SqlCommandIdentifier

Represents the SqlCommandIdentifier.

SqlDataTypeReference

Represents built-in data types

SqlScriptGenerator

Sql specific script generator.

SqlScriptGeneratorOptions

Controls the options for Sql Script Generation

StateAuditOption

STATE option in ALTER SERVER AUDIT statement.

StatementList

Represents a list of statements.

StatementListSnippet

Placeholder for an arbitrary statement list.

StatementWithCtesAndXmlNamespaces

This class represents a statement that can begin with a common table expression or xml namespaces.

StatisticsOption

Represents the statistics option.

StatisticsPartitionRange

Represents a single partition range, with constant expressions

StopListFullTextIndexOption

Represents STOPLIST option in FULLTEXT INDEX statement.

StopRestoreOption

Represents StopAtMark/StopBeforeMark restore options

StringLiteral

Represents a string literal.

SubqueryComparisonPredicate

Represents the comparison predicates that have subqueries.

SymmetricKeyStatement

Represents common properties for ALTER and CREATE SYMMETRIC KEY statements

SystemTimePeriodDefinition

Period for temporal system time.

SystemVersioningTableOption

SYSTEM_VERSIONING table option.

TableClusteredIndexType

Representation of the Clustered Index type for a table index.

TableDataCompressionOption

The table option for DATA_COMPRESSION.

TableDefinition

This class stores the common body for defining a table

TableDistributionOption

Represents the table DISTRIBUTION option for SQL DW tables.

TableDistributionPolicy

Base class for table distribution policies.

TableHashDistributionPolicy

Representation of the HASH option for an table distribution policy.

TableHint

Represents single table hint.

TableHintsOptimizerHint

Represents optimizer hint containing table hint.

TableIndexOption

Represents the table INDEX option for SQL DW tables.

TableIndexType

Base class for table index types.

TableNonClusteredIndexType

Representation of the Non-Clustered Index type or HEAP for a table index.

TableOption

A single table option.

TablePartitionOption

Represents the table PARTITION option for SQL DW tables.

TablePartitionOptionSpecifications

For specifying range and values in the partition table option in the CREATE TABLE statement.

TableReference

This is an abstract base class that represents table reference.

TableReferenceWithAlias

This represents a table reference that can have an alias.

TableReferenceWithAliasAndColumns

Represents a table reference that can specify column aliases.

TableReplicateDistributionPolicy

Representation of the REPLICATE option for an table distribution policy.

TableRoundRobinDistributionPolicy

Representation of the ROUND_ROBIN option for an table distribution policy.

TableSampleClause

Represents the TABLESAMPLE clause.

TableSwitchOption

Represents the alter table switch option.

TableValuedFunctionReturnType

The return type definition for multi-statement table-valued functions

TargetDeclaration

Represents the target declaration

TargetRecoveryTimeDatabaseOption

TARGET_RECOVERY_TIME option in ALTER DATABASE statement, SET case

TemporalClause

Base class for all temporal clauses.

TextModificationStatement

Represents the writetext statement.

ThrowStatement

Represents the THROW statement

TopRowFilter

This class represents the top row filter, that can be used in select statement.

TransactionStatement

The abstract base class for transaction statements.

TriggerAction

Represents the trigger action.

TriggerObject

Information on what trigger is being created/altered

TriggerOption

Represents the trigger option.

TriggerStatementBody

Represents CREATE/ALTER TRIGGER statement.

TruncateTableStatement

Represents the truncate table statement.

TryCastCall

Represents the try_cast call.

TryCatchStatement

Defines the try catch statement.

TryConvertCall

Represents the try_convert function call.

TryParseCall

Represents the try_parse function call.

TSEqualCall

Represents the tsequal function call which is a boolean function.

TSql100Parser

The TSql Parser for 10.0.

TSql110Parser

The TSql Parser for 11.0.

TSql120Parser

The TSql Parser for 12.0.

TSql130Parser

The TSql Parser for 13.0.

TSql140Parser

The TSql Parser for 14.0.

TSql80Parser

The TSql Parser for 8.0.

TSql90Parser

The TSql Parser for 9.0.

TSqlAuditEventGroupHelper

Exposes the audit event groups.

TSqlAuditEventTypeHelper

Exposes the audit event types.

TSqlBatch

Represents a batch in T-SQL script.

TSqlConcreteFragmentVisitor

The base visitor for the concrete TSql fragments

TSqlFragment

This class is a real internal class to parser, therefore it is not in the spec tree.

TSqlFragmentSnippet

Placeholder for an arbitrary TSqlFragment.

TSqlFragmentVisitor

The base visitor for the TSql script dom.

TSqlParser

The abstract base class for TSql Parsers.

TSqlParserToken

Represents a single Token in the input text.

TSqlScript

Represents a TSql sript.

TSqlStatement

Represents a single T-SQL statement.

TSqlStatementSnippet

Placeholder for an arbitrary statement.

TSqlTriggerEventGroupHelper

Exposes the trigger event groups.

TSqlTriggerEventTypeHelper

Exposes the trigger event types.

UnaryExpression

An expression that has a single expression as child.

UniqueConstraintDefinition

Represents the unique or primary key constraint. This class translates 80 syntax into 90 syntax, this should be reflected in the AST, if a differentiator is to be written.

UnpivotedTableReference

Represents the unpivoted table reference in a from clause.

UnqualifiedJoin

Represents the unqualified join in a from clause.

UpdateCall

Represents the update function call which is a boolean function for use in triggers.

UpdateDeleteSpecificationBase

Base class for Update and Delete Specs

UpdateForClause

Represents FOR UPDATE [columns] case used only in DECLARE CURSOR

UpdateMergeAction

Represents update merge action

UpdateSpecification

The properties for Update

UpdateStatement

Represents the update statement.

UpdateStatisticsStatement

Represents the update statistics statement.

UpdateTextStatement

Represents the updatetext statement.

UseFederationStatement

Represents the USE FEDERATION statement

UseHintList

Represents optimizer hints in a USE HINT clause.

UserDataTypeReference

Represents user-defined data types

UserDefinedTypeCallTarget

Represents target of a call which is a column or CLR property on a column.

UserDefinedTypePropertyAccess

This class represents a property on a Udt.

UserLoginOption

Represents the user login option.

UserRemoteServiceBindingOption

The remote service binding option for USER.

UserStatement

Represents the user statement base.

UseStatement

Represents the use statement.

ValueExpression

Base class for literals, variables, and global variables.

ValuesInsertSource

Represents the insert source for VALUES.

VariableMethodCallTableReference

Represents a table reference that is a method call on a variable reference

VariableReference

Represents a reference to a variable

VariableTableReference

This class represents a table reference which is a variable.

VariableValuePair

Represents single variable-value pair in OPTIMIZE FOR optimizer hint

ViewOption

Represents the View option.

ViewStatementBody

Base class for CREATE/ALTER VIEW statement.

WaitAtLowPriorityOption

Represents the low priority lock wait option for alter table switch statement.

WaitForStatement

Represents the waitfor statement.

WaitForSupportedStatement

Base class for statements inside WAITFOR statement

WhenClause

Abstract class for case expression when clauses

WhereClause

Represents the where clause that can be used in statements like select, update.

WhileStatement

Represents the while statement.

WindowDelimiter

Represents specification of a window boundary.

WindowFrameClause

Represents the specification of window bounds for windowing aggregates.

WindowsCreateLoginSource

Windows case in CREATE LOGIN statement

WithCtesAndXmlNamespaces

This class represents a common construct that can have common table expressions and xml namespaces in it.

WithinGroupClause

Represents the within group clause.

WitnessDatabaseOption

WITNESS option in ALTER DATABASE statement, SET case

WorkloadGroupImportanceParameter

Represents the workload group importance parameter.

WorkloadGroupParameter

Represents the workload group statement parameters.

WorkloadGroupResourceParameter

Represents the workload group statement parameters.

WorkloadGroupStatement

Represents Create and Alter Workload Group Statement.

WriteTextStatement

Represents the writetext statement.

WsdlPayloadOption

Represents WSDL payload option

XmlDataTypeReference

Represents xml data types

XmlForClause

Represents FOR XML (options) case

XmlForClauseOption

Represents FOR XML (options) case

XmlNamespaces

This class represents XmlNameSpaces

XmlNamespacesAliasElement

The alias variation for the xml namespace element.

XmlNamespacesDefaultElement

The default variation for the xml namespace element.

XmlNamespacesElement

The element that is used in defining xml namespace.

Enums

AbortAfterWaitType

The action to be taken after low priority wait times out.

AffinityKind

The types of endpoint affinity

AllowConnectionsOptionKind

The allow read options.

AlterAction

The types of alter action

AlterAvailabilityGroupActionType

The types alter availability group actions

AlterAvailabilityGroupStatementType

The types of alter availability group statements.

AlterCertificateStatementKind

The types of Alter Certificate

AlterEventSessionStatementType

The types of alter event session statement

AlterFederationKind

The types of alter federation statement

AlterFullTextCatalogAction

The types of alter fulltext catalog action

AlterIndexType

The possible alter index types.

AlterMasterKeyOption

The types of alter master key options

AlterResourceGovernorCommandType

The types of alter resource governor command

AlterServerConfigurationBufferPoolExtensionOptionKind

The types of buffer pool extension options.

AlterServerConfigurationDiagnosticsLogOptionKind

The types of diagnostics log options.

AlterServerConfigurationFailoverClusterPropertyOptionKind

The types of failover cluster properties.

AlterServerConfigurationHadrClusterOptionKind

The types of HADR cluster properties.

AlterServerConfigurationSoftNumaOptionKind

The types of softnuma options.

AlterServiceMasterKeyOption

The types of alter service master key option

AlterTableAlterColumnOption

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

ApplicationRoleOptionKind

The possible application role options.

AssemblyOptionKind

The possible Assembly Options.

AssignmentKind

The types of assignment

AtomicBlockOptionKind

Options specified in the ATOMIC block statement

AttachMode

The types of attach mode

AuditActionGroup

The types of audit action group

AuditFailureActionType

The action to take on audit failure.

AuditOptionKind
AuditTargetKind

The possible audit target kinds

AuditTargetOptionKind
AuthenticationProtocol

The types of authentication protocols

AuthenticationTypes

Possible authentication types

AutomaticTuningOptionKind

The possible Automatic Tuning Options under 'ALTER DATABASE d1 SET AUTOMATIC_TUNING = (...)'

AutomaticTuningOptionState

The possible Automatic Tuning Options under 'ALTER DATABASE d1 SET AUTOMATIC_TUNING = (OPTION = ...)'

AutomaticTuningState

State of Automatic Tuning option

AvailabilityGroupOptionKind

The types of availability group options

AvailabilityModeOptionKind

The availability mode options.

AvailabilityReplicaOptionKind

The possible Availability Replica Options.

BackupOptionKind

The types of backup options

BackupRestoreItemKind

The types of backup restore item options

BinaryExpressionType

The types of scalar expressions that have two expressions as children.

BinaryQueryExpressionType

The types of query expressions that have two query expressions as children.

BooleanBinaryExpressionType

The types of boolean expressions that have two expressions as children.

BooleanComparisonType

The types of comparison expressions

BooleanTernaryExpressionType

The types of expressions that have three expressions as children.

BoundingBoxParameterType

The types of bounding box paramter

BrokerPriorityParameterSpecialType

The types of broker priority parameters

BrokerPriorityParameterType

The types of broker priority parameters

BulkInsertOptionKind

If this enum grows beyond 31, Parser needs to be updated - it uses Int32 to check for option duplication

CatalogCollation

Values for the CATALOG_COLLATION database option

CertificateOptionKinds

The types of certificate options

ChangeTrackingOption

The possible change tracking options.

ColumnEncryptionDefinitionParameterKind

Parameter types for column encryption definition

ColumnEncryptionKeyAlterType

Column encryption key alter statement types

ColumnEncryptionKeyValueParameterKind

Column encryption key value parameters

ColumnEncryptionType

Types of encryption supported on a column.

ColumnMasterKeyParameterKind

Parameter types for column master key definition

ColumnType

Column Types, used for class Column.

CommandOptions

Commands that can be used in security statements.

CompressionDelayTimeUnit

Possible values for units in COMPRESSION_DELAY clause.

ComputeFunctionType

The possible types for compute function of compute clause.

ConstraintEnforcement

Defines how constraints can be enforced.

ContainmentOptionKind

The possible containment settings.

CryptoMechanismType

The types of crypto mechanism

CursorOptionKind

Different cursor options

DatabaseAuditActionKind

The types of database audit action

DatabaseConfigClearOptionKind

The types of database options that can be cleared

DatabaseConfigSetOptionKind

The types of database configuration options that can be set

DatabaseConfigurationOptionState

State of some database configuration options

DatabaseEncryptionKeyAlgorithm

Possible algorithms for database encryption key.

DatabaseMirroringEndpointRole

The types of database mirroring endpoint role

DatabaseOptionKind

The types of database options

DataCompressionLevel

The possible values for data compression level

DbccCommand

The possible values for dbcc commands

DbccOptionKind

The types of dbcc options

DelayedDurabilityOptionKind

The possible delayed durability settings.

DeleteUpdateAction

Shows the action that will be taken on delete or update.

DeviceType

The types of devices

DialogOptionKind
DiskStatementOptionKind

Different disk statement options

DiskStatementType

The disk statement type.

DropClusteredConstraintOptionKind

Drop clustered constraint option types.

DropSchemaBehavior

DROP SCHEMA behavior (in case of SQL 2000)

DurabilityTableOptionKind

The table durability kinds

EnableDisableOptionType

The types of enable disable options

EncryptionAlgorithm

Possible algorithms for encryption

EncryptionAlgorithmPreference

Possible values for encryption algorithm preference.

EndpointEncryptionSupport

The types of endpoint encryption support

EndpointProtocol

The types of endpoint protocol

EndpointProtocolOptions

The possible endpoint protocol options

EndpointState

The types of endpoint state

EndpointType

The types of endpoint

EventNotificationEventGroup

The types of event group

EventNotificationEventType

Possible event types

EventNotificationTarget

The possible event notification targets.

EventSessionEventRetentionModeType

The types of event retention modes

EventSessionMemoryPartitionModeType

The types of memory partition mode

EventSessionScope

The allowed scopes of event sessions

ExecuteAsOption

The execute as options.

ExecuteOptionKind
ExternalDataSourceOptionKind

The external data source options.

ExternalDataSourceType

The enumeration specifies the external data source type for external tables Currently, we support HADOOP, RDBMS, and SHARD_MAP_MANAGER.

ExternalFileFormatOptionKind

The external file format options.

ExternalFileFormatType

The enumeration specifies the external file format types DELIMITEDTEXT, RCFILE, ORC, PARQUET.

ExternalFileFormatUseDefaultType

The enumeration specifies the external file format use default type option FALSE (default) or TRUE.

ExternalResourcePoolAffinityType

The types of paramters used in a CREATE/ALTER EXTERNAL RESOURCE POOL statement

ExternalResourcePoolParameterType

The types of parameters used in a CREATE/ALTER EXTERNAL RESOURCE POOL statement

ExternalTableOptionKind

The external table options.

ExternalTableRejectType

The enumeration specifies the external table reject types VALUE (default) or PERCENTAGE.

FailoverActionOptionKind

The types of failover action options.

FailoverModeOptionKind

The failover mode options.

FetchOrientation

Possible values for fetch orientation

FileDeclarationOptionKind

The possible File Declaration Options

FipsComplianceLevel

Fips 127-2 compliance level

FullTextCatalogOptionKind
FullTextFunctionType

The fulltext function types.

FullTextIndexOptionKind

The possible FullText Index Options

FunctionOptionKind

Possible values for function options

GeneralSetCommandType

Types of set commands with parameter

GeneratedAlwaysType

Possible values for 'GENERATED ALWAYS' clause

GridParameterType

The types of grid parameters

GroupByOption

The options that group by clause might have.

HadrDatabaseOptionKind

The types of Hadr database options

ImportanceParameterType

The possible values for importance parameter in CREATE/ALTER WORKLOAD GROUP and CREATE SPATIAL INDEX statements

IndexOptionKind

The possible index options.

IndexTypeKind

The possible index types.

InsertOption

The type of insert options

IsolationLevel

Isolation levels for SET TRANSACTION ISOLATION LEVEL command

JoinHint

The types of join hints.

JsonForClauseOptions

Enum to store different JSON for clause options

KeyOptionKind
KeywordCasing

Represents the possible ways of casing SQL keywords

LiteralType

The literal types.

LockEscalationMethod

The types of lock escalation methods

LowPriorityLockWaitOptionKind

The possible low priority lock wait options.

MemoryUnit

Memory units for file declaration options in CREATE DATABASE statement

MergeCondition

The possible values for merge condition

MessageSender

The types of message senders

MessageValidationMethod

The types of message validation methods

MigrationState

The types of migration state

ModifyFileGroupOption

The possible values for modify filegroup options

NonTransactedFileStreamAccess

The possible non transacted filestream access values.

NullNotNull

Represents optional NULL/NOT NULL contraint in column definition in INSERT BULK statement

OdbcLiteralType

Represents the Odbc Literal Types

OptimizerHintKind

Optimizer hints

OptionState

State of some option

PageVerifyDatabaseOptionKind

The types of page verify alter database options

ParameterlessCallType

Specifies the type of the parameterless call.

ParameterModifier

The types of parameter modifier

ParameterStyle

Parameter style for external function bodies

PartitionFunctionRange

The possible values for partition function range

PartitionTableOptionRange

The possible values for partition table option range

PartnerDatabaseOptionKind

The types of partner alter database options

PayloadOptionKinds

The types of payload options

PermissionSetOption

The permission set options.

PortTypes

The possible values for port types

PrincipalOptionKind

The types of login options

PrincipalType

The principal types that can be used in security statements.

PrivilegeType80

The privilege types that can be used in security statements.

ProcedureOptionKind

The types of procedure options

ProcessAffinityType

The type of process affinity in ALTER SERVER CONFIGURATION statement

QualifiedJoinType

The types of qualified joins.

QueryStoreCapturePolicyOptionKind

The possible Query Store Capture Policy Modes

QueryStoreDesiredStateOptionKind

The possible Query Store Desired State Options

QueryStoreOptionKind

The possible Query Store Options under 'ALTER DATABASE d1 SET QUERY_STORE = (...)'

QueryStoreSizeCleanupPolicyOptionKind

The possible Size based Cleanup Policy Modes

QueueOptionKind

The possible queue options.

QuoteType

The possible quote type.

RaiseErrorOptions

RaiseError options.

RdaTableOption

The types of RDA table option

RecoveryDatabaseOptionKind

The types of recovery alter database options

RemoteDataArchiveDatabaseSettingKind

The possible settings under 'ALTER DATABASE d1 SET REMOTE_DATA_ARCHIVE = (...)'

RemoteServiceBindingOptionKind
ResourcePoolAffinityType

The types of paramters used in a CREATE/ALTER RESOURCE POOL statement

ResourcePoolParameterType

The types of paramters used in a CREATE/ALTER RESOURCE POOL statement

RestoreOptionKind

The types of restore options

RestoreStatementKind

The types of restore statements

ResultSetsOptionKind

Indicates whether the Result Sets are defined on Execute Statements

ResultSetType

Indicates the mechanism used for defining the Result Set.

RouteOptionKind

The possible route options.

SecondaryXmlIndexType

The secondary xml index types.

SecurityObjectKind

The types of security objects

SecurityPolicyActionType

The types of security policy statement actions

SecurityPolicyOptionKind

The security policy options.

SecurityPredicateActionType

The types of security predicate options

SecurityPredicateOperation

The types of security predicate operations

SecurityPredicateType

The types of security predicates

SemanticFunctionType

The semantic function types.

SeparatorType

The possible separator types.

SequenceOptionKind

The types of Sequence options

ServiceBrokerOption

Possible service broker options for CREATE DATABASE statement

SessionOptionKind
SetOffsets

The various types of keywords used in SET OFFSETS statement.

SetOptions

The various types of predicate SET options found in SQL.

SetStatisticsOptions

The various types of predicate SET STATISTICS options found in SQL.

SignableElementKind

The types of signable elements

SimpleAlterFullTextIndexActionKind

The types of alter fulltext index actions

SoapMethodAction

The types of soap method actions

SoapMethodFormat

The possible soap method formats

SoapMethodSchemas

The types of soap method schema

SortOrder

This enum is the possibilities for a sort order.

SparseColumnOption

The possible values for sparse column options

SpatialIndexingSchemeType

The types of spatial indexing scheme

SqlDataTypeOption

These are the possible data types in Sql. The capitalization of names are influenced by System.Data.SqlDbType.

SqlEngineType

This enum lists the engine type of SQL Server

SqlVersion

This enum lists the versions for Sql.

StatisticsOptionKind

The possible Statistics options.

SubqueryComparisonPredicateType

The types of comparison predicates that involve a subquery.

TableElementType

Table element type.

TableHintKind

The table hints.

TableOptionKind

The possible Table Options

TableSampleClauseOption

The table sample clause options.

TableSwitchOptionKind

The possible options for alter table switch statement.

TemporalClauseType

Possible values for temporal clause in 'FROM' part of a query.

TemporalRetentionPeriodUnit

Possible values for units in HISTORY_RETENTION_PERIOD clause.

TimeUnit

The types of time units used in various statements. More time units can be added as necessary.

TriggerActionType

Specify which data modification statements, when attempted against this table or view, activate the trigger.

TriggerEnforcement

Options on enforcement of trigger execution.

TriggerOptionKind

The possible Trigger options.

TriggerScope

This enum list possible trigger scopes

TriggerType

Specifies the type of the trigger.

TSqlTokenType
UnaryExpressionType

The types of scalar expressions that have a single expression as a child.

UniqueRowFilter

Used in Select statement.

UnqualifiedJoinType

The possible index options.

UserLoginOptionType

The possible user login options.

UserType80

The privilege types that can be used in security statements.

ViewOptionKind

The possible View options.

WaitForOption

The possible waitfor options.

WindowDelimiterType

Type of a window boundary

WindowFrameType

Type of the window frame. Specifies whether ROWS or RANGE units are used.

WorkloadGroupParameterType

The types of workload resource paramters

XmlDataTypeOption

These are the possible modifiers to the xml data type.

XmlForClauseOptions

Enum to store different XML for clause options