Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Reference

Important

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

Classes

AcceleratedDatabaseRecoveryDatabaseOption	ACCELERATED_DATABASE_RECOVERY option in ALTER DATABASE statement, SET case
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.
AddSensitivityClassificationStatement	Adds sensitivity classification to specified columns.
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.
AlterExternalLanguageStatement	Represents the ALTER EXTERNAL LANGUAGE statement.
AlterExternalLibraryStatement	Represents the ALTER EXTERNAL LIBRARY 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.
AlterServerConfigurationExternalAuthenticationContainerOption	Represents a single ALTER SERVER CONFIGURATION SET EXTERNAL AUTHENTICATION top level setting that can have a list of suboptions.
AlterServerConfigurationExternalAuthenticationOption	Represents a single ALTER SERVER CONFIGURATION SET EXTERNAL AUTHENTICATION 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.
AlterServerConfigurationSetExternalAuthenticationStatement	Represents ALTER SERVER CONFIGURATION SET EXTERNAL AUTHENTICATION 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.
ClassifierEndTimeOption	Represents the start time option for workload classifier.
ClassifierImportanceOption	Represents the importance option for workload classifier.
ClassifierMemberNameOption	Represents the member name option for workload classifier.
ClassifierStartTimeOption	Represents the start time option for workload classifier.
ClassifierWlmContextOption	Represents the wlm context option for workload classifier.
ClassifierWlmLabelOption	Represents the query label option for workload classifier.
ClassifierWorkloadGroupOption	Represents the workload group option for workload classifier.
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
ColumnMasterKeyEnclaveComputationsParameter	Parameter representing enclave computation signature
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.
CopyColumnOption	Represents column options of copy command
CopyCredentialOption	Represents COPY statement CREDENTIAL options
CopyOption	Represents COPY statement options
CopyStatement	Represents COPY statement
CopyStatementOptionBase	A single copy statement option.
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.
CreateExternalLanguageStatement	Represents the CREATE EXTERNAL LANGUAGE statement.
CreateExternalLibraryStatement	Represents the CREATE EXTERNAL LIBRARY statement.
CreateExternalResourcePoolStatement	Represents the Create External Resource Pool statement.
CreateExternalStreamingJobStatement	Represents an EXEC sys.sp_create_streaming_job statement.
CreateExternalStreamStatement	Represents an CREATE EXTERNAL STREAM 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.
CreateWorkloadClassifierStatement	Represents the Create Workload Classifier 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.
DataRetentionTableOption	DATA_RETENTION table option.
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.
DistinctPredicate	Represents the distinct predicate.
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.
DropExternalLanguageStatement	Represents the DROP EXTERNAL LANGUAGE statement.
DropExternalLibraryStatement	Represents the DROP EXTERNAL LIBRARY statement.
DropExternalResourcePoolStatement	Represents the Drop External Resource Pool statement.
DropExternalStreamingJobStatement	Represents an EXEC sys.sp_drop_streaming_job statement.
DropExternalStreamStatement	Represents a DROP EXTERNAL STREAM 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
DropSensitivityClassificationStatement	Drops sensitivity classification from specified columns.
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
DropWorkloadClassifierStatement	Represents Drop Workload Classifier statement
DropWorkloadGroupStatement	Represents the Drop Workload Group statement.
DropXmlSchemaCollectionStatement	Represents DROP XML SCHEMA COLLECTION statement.
DurabilityTableOption	DURABILITY table option.
DWCompatibilityLevelConfigurationOption	DWCompatibilityLevel option in ALTER DATABASE SCOPED CONFIGURATION statement
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.
ExternalCreateLoginSource	External case in CREATE LOGIN statement
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.
ExternalFileOption	ExternalFileOption base class.
ExternalLanguageFileOption	Represents a single file in CREATE EXTERNAL LANGUAGE statement
ExternalLanguageStatement	Represents common parts in create and alter external language statements.
ExternalLibraryFileOption	Represents a single file in CREATE EXTERNAL LIBRARY statement
ExternalLibraryStatement	Represents common parts in create and alter external library statements.
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.
ExternalStreamingJobStatement	Base class for all external streaming job statement objects.
ExternalStreamLiteralOrIdentifierOption	Represents property of type Literal or Identifier.
ExternalStreamOption	CREATE EXTERNAL STREAM statement optional property.
ExternalStreamStatement	Base class for all external stream statement objects.
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.
GraphConnectionBetweenNodes	The abstract base class that represents the connection from one node table to other in graph tables.
GraphConnectionConstraintDefinition	Represents the connection constraint for graph tables.
GraphMatchCompositeExpression	A boolean expression for a MATCH expression
GraphMatchExpression	A boolean expression for a MATCH expression
GraphMatchLastNodePredicate	A boolean expression for LastNode
GraphMatchNodeExpression	A boolean expression for MATCH
GraphMatchPredicate	A boolean expression for MATCH
GraphMatchRecursivePredicate	A boolean expression for Shortest Path expression
GraphRecursiveMatchQuantifier	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.
InlineFunctionOption	The Inline function option
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
JsonKeyValue	Represent a key value Pair
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.
LedgerOption	Sets the database's Ledger Option
LedgerTableOption	LEDGER table option.
LedgerViewOption	LEDGER View option.
LeftFunctionCall	Represents LEFT call.
LikePredicate	Represents the like predicate.
LineNoStatement	Represents the lineno statement.
ListenerIPEndpointProtocolOption	Represents LISTENER_IP TCP endpoint protocol option
ListTypeCopyOption	Represents list of same kind of external file options
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
LiteralOpenRowsetCosmosOption	Represents simple single option in BULK INSERT (Provider='CosmosDB' ...) statement.
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.
LocationOption	Represents the LOCATION option for SQL DW Tables.
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.
OpenRowsetColumnDefinition	Represent the column that a user would like to read from a file.
OpenRowsetCosmos	Represents OPENROWSET (PROVIDER = 'CosmosDB' ...) table reference.
OpenRowsetCosmosOption	Represents single option in OPENROWSET (Provider='CosmosDb'...) statement
OpenRowsetTableReference	Represents OPENROWSET table reference.
OpenSymmetricKeyStatement	Open symmetric key statement.
OpenXmlTableReference	Represents OPENXML table reference
OperatorAuditOption	OPERATOR_AUDIT option in CREATE/ALTER SERVER AUDIT statement.
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.
PredictTableReference	Represents PREDICT table reference
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.
RenameEntityStatement	Represents a Rename TABLE statement
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
RetentionDaysAuditTargetOption	RetentionDays option in case of URL audit target.
RetentionPeriodDefinition	Definition of retention period for system versioned temporal table and data retention table option.
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
SensitivityClassification	Utility class to expose sensitivity classification enums and methods
SensitivityClassificationOption	Single option in ADD SENSITIVITY CLASSIFICATION statement.
SensitivityClassificationStatement	Represents the base sensitivity classification 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.
SingleValueTypeCopyOption	Represents literals for COPY options
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
Sql150ScriptGenerator	Script generator for T-SQL 150
Sql160ScriptGenerator	Script generator for T-SQL 160
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
SqlServerlessScriptGenerator	Script generator for Serverless SQL Pools
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
TableXmlCompressionOption	The table option for XMLCOMPRESSION.
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.
TruncateTargetTableSwitchOption	Represents the truncate target table option for alter table switch 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.
TSql150Parser	The TSql Parser for 15.0.
TSql160Parser	The TSql Parser for 16.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
ViewDistributionOption	Represents the view DISTRIBUTION option for SQL DW materialized views.
ViewDistributionPolicy	Base class for materialized view distribution policies.
ViewForAppendOption	Represents the view FOR_APPEND option for SQL DW materialized views.
ViewHashDistributionPolicy	Representation of the HASH option for a materialized view distribution policy.
ViewOption	Represents the View option.
ViewRoundRobinDistributionPolicy	Representation of the ROUND_ROBIN option for a materialized view distribution policy.
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.
WindowClause	Represents the window clause.
WindowDefinition	Definition of a named window.
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
WlmTimeLiteral	Represents a Literal of time type used in Workload Management.
WorkloadClassifierOption	A single workload classifier option.
WorkloadClassifierStatement	Represents Create Workload Classifier statement
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
XmlCompressionOption	Represents a single xml compression 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.
AlterServerConfigurationExternalAuthenticationOptionKind	The types of external authentication 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 63, Parser needs to be updated - it uses Int64 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.
CopyCommandCompressionType	Compression type supported by copy command.
CopyCommandCredentialType	Credential identity supported by COPY statement.
CopyCommandDateFormat	Dateformat supported for copy command.
CopyCommandEncoding	Encoding supported for copy command.
CopyCommandFileFormatType	The supported file types for copy command.
CopyCommandIdentityInsert	Identity insert supported by copy command.
CopyOptionKind	If this enum grows beyond 31, Parser needs to be updated - it uses Int32 to check for option duplication
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.
ExternalDataSourcePushdownOption	The enumeration specifies the external data source type for external tables Currently, we support HADOOP, RDBMS, and SHARD_MAP_MANAGER.
ExternalDataSourceType	The enumeration specifies the external data source type for external tables Currently, we support HADOOP, RDBMS, and SHARD_MAP_MANAGER. EXTERNAL_GENERICS only works for SQL150 and DW, in DW it is called Native external data source.
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
ExternalStreamOptionKind	External Stream options
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
FileFormatType	The supported external file formats.
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
GraphMatchRecursivePredicateKind	Recursive predicate kind for graph match expression.
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
OpenRowsetCosmosOptionKind	Available options for OPENROWSET (Provider =' CosmosDB' ....) statement. This syntax is specific to Serverless SQL pools
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
PredictRunTimeOptions	The Predict runtime options.
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.
SensitivityClassification.OptionType	Sensitivity classification option type used in AddSensitivityClassificationStatement
SensitivityClassification.Rank	Sensitivity classification rank values
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.
WorkloadClassifierOptionType	The workload classifier options.
WorkloadGroupParameterType	The types of workload resource paramters
XmlCompressionOptionState	The possible Xml Compression Options under 'CREATE TABLE t1 XML_COMPRESSION = { ON \| OFF }'
XmlDataTypeOption	These are the possible modifiers to the xml data type.
XmlForClauseOptions	Enum to store different XML for clause options

Share via

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Classes

Enums

Additional resources