ACCELERATED_DATABASE_RECOVERY option in ALTER DATABASE statement, SET case
AddAlterFullTextIndexActionRepresents ADD action for ALTER FULLTEXT INDEX statement.
AddFileSpecRepresents single file in ADD FILE FROM clause in ALTER ASSEMBLY statement
AddMemberAlterRoleActionRepresents the add member alter role action.
AddSearchPropertyListActionThe ADD search property list action.
AddSensitivityClassificationStatementAdds sensitivity classification to specified columns.
AddSignatureStatementRepresents ADD SIGNATURE statements.
AdHocDataSourceRepresents ad hoc datasource.
AdHocTableReferenceOPENDATASOURCE (ad-hoc) table reference.
AlgorithmKeyOptionRepresents ALGORITHM option.
AlterApplicationRoleStatementRepresents the alter application role statement.
AlterAssemblyStatementRepresents the ALTER ASSEMBLY statement.
AlterAsymmetricKeyStatementRepresents ALTER ASYMMETRIC KEY statement
AlterAuthorizationStatementRepresents alter authorization statement.
AlterAvailabilityGroupActionAction to take for alter availability group.
AlterAvailabilityGroupFailoverActionRepresents the failover action to take for alter availability group.
AlterAvailabilityGroupFailoverOptionRepresents a failover option.
AlterAvailabilityGroupStatementRepresents the ALTER AVAILABILITY GROUP statement
AlterBrokerPriorityStatementRepresents the Alter Broker Priority statement.
AlterCertificateStatementRepresents ALTER CERTIFICATE statement
AlterColumnAlterFullTextIndexActionRepresents ALTER COLUMN action for ALTER FULLTEXT INDEX statement.
AlterColumnEncryptionKeyStatementRepresents an ALTER COLUMN ENCRYPTION KEY statement
AlterCreateEndpointStatementBaseRepresents common part of CREATE and ALTER ENDPOINT statements
AlterCreateServiceStatementBaseRepresents CREATE SERVICE statement
AlterCredentialStatementRepresents ALTER CREDENTIAL statement
AlterCryptographicProviderStatementRepresents the Alter Cryptographic Provider statement.
AlterDatabaseAddFileGroupStatementAdd and remove filegroup cases from ALTER DATABASE
AlterDatabaseAddFileStatementAdd file case from ALTER DATABASE
AlterDatabaseAuditSpecificationStatementAlters database audit specification.
AlterDatabaseCollateStatementAlter COLLATE case from ALTER DATABASE
AlterDatabaseEncryptionKeyStatementAlters database encryption key
AlterDatabaseModifyFileGroupStatementModify filegroup case from ALTER DATABASE
AlterDatabaseModifyFileStatementModify file case from ALTER DATABASE
AlterDatabaseModifyNameStatementModify name case from ALTER DATABASE
AlterDatabaseRebuildLogStatementRebuild log case from ALTER DATABASE (undocumented)
AlterDatabaseRemoveFileGroupStatementAdd and remove filegroup cases from ALTER DATABASE
AlterDatabaseRemoveFileStatementRemove file case from ALTER DATABASE
AlterDatabaseScopedConfigurationClearStatementRepresents ALTER DATABASE SCOPED CONFIGURATION CLEAR statement
AlterDatabaseScopedConfigurationSetStatementRepresents ALTER DATABASE SCOPED CONFIGURATION SET statement
AlterDatabaseScopedConfigurationStatementRepresents ALTER DATABASE SCOPED CONFIGURATION statement
AlterDatabaseSetStatementRepresents SET case in ALTER DATABASE statement
AlterDatabaseStatementRepresents ALTER DATABASE statement
AlterDatabaseTerminationContains termination information
AlterEndpointStatementRepresents ALTER ENDPOINT statement
AlterEventSessionStatementRepresents the Alter Event Session statement.
AlterExternalDataSourceStatementRepresents an ALTER EXTERNAL DATA SOURCE statement.
AlterExternalLanguageStatementRepresents the ALTER EXTERNAL LANGUAGE statement.
AlterExternalLibraryStatementRepresents the ALTER EXTERNAL LIBRARY statement.
AlterExternalResourcePoolStatementRepresents the Alter External Resource Pool statement.
AlterFederationStatementRepresents the ALTER FEDERATION statement
AlterFullTextCatalogStatementRepresents ALTER FULLTEXT CATALOG statement
AlterFullTextIndexActionRepresents altering action for ALTER FULLTEXT INDEX statement.
AlterFullTextIndexStatementRepresents ALTER FULLTEXT INDEX statement.
AlterFullTextStopListStatementRepresents the Alter Fulltext Stoplist statement.
AlterFunctionStatementRepresents the Alter Function statement.
AlterIndexStatementRepresents the alter index statement.
AlterLoginAddDropCredentialStatementRepresents ALTER LOGIN which adds or drops credential name.
AlterLoginEnableDisableStatementRepresents ALTER LOGIN which enables or disables login.
AlterLoginOptionsStatementRepresents ALTER LOGIN which alters options.
AlterLoginStatementRepresents ALTER LOGIN statement.
AlterMasterKeyStatementRepresents the master key statement.
AlterMessageTypeStatementRepresents ALTER MESSAGE TYPE statement
AlterPartitionFunctionStatementRepresents ALTER PARTITION FUNCTION statement.
AlterPartitionSchemeStatementRepresents ALTER PARTITION SCHEME statement.
AlterProcedureStatementThe alter procedure statement.
AlterQueueStatementRepresents alter queue statement.
AlterRemoteServiceBindingStatementRepresents ALTER REMOTE SERVICE BINDING statement
AlterResourceGovernorStatementRepresents the Alter Resource Governor Statement.
AlterResourcePoolStatementRepresents the Alter Resource Pool statement.
AlterRoleActionRepresents an action in ALTER ROLE.
AlterRoleStatementRepresents the alter role statement.
AlterRouteStatementRepresents alter route statement.
AlterSchemaStatementRepresents ALTER SCHEMA statement
AlterSearchPropertyListStatementRepresents ALTER SEARCH PROPERTY LIST statement
AlterSecurityPolicyStatementRepresents an ALTER SECURITY POLICY statement
AlterSequenceStatementRepresents ALTER SEQUENCE statement
AlterServerAuditSpecificationStatementAlters server audit specification.
AlterServerAuditStatementAlters server audit.
AlterServerConfigurationBufferPoolExtensionContainerOptionRepresents a single ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION top level setting that can have a list of suboptions.
AlterServerConfigurationBufferPoolExtensionOptionRepresents a single ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION option.
AlterServerConfigurationBufferPoolExtensionSizeOptionRepresents the SIZE option for the BUFFER POOL EXTENSION.
AlterServerConfigurationDiagnosticsLogMaxSizeOptionRepresents a single ALTER SERVER CONFIGURATION SET DIAGNOSTICS LOG MAX_SIZE option.
AlterServerConfigurationDiagnosticsLogOptionRepresents a single ALTER SERVER CONFIGURATION SET DIAGNOSTICS LOG option.
AlterServerConfigurationExternalAuthenticationContainerOptionRepresents a single ALTER SERVER CONFIGURATION SET EXTERNAL AUTHENTICATION top level setting that can have a list of suboptions.
AlterServerConfigurationExternalAuthenticationOptionRepresents a single ALTER SERVER CONFIGURATION SET EXTERNAL AUTHENTICATION option.
AlterServerConfigurationFailoverClusterPropertyOptionRepresents a single ALTER SERVER CONFIGURATION SET FAILOVER CLUSTER PROPERTY option.
AlterServerConfigurationHadrClusterOptionRepresents a single ALTER SERVER CONFIGURATION SET HADR CLUSTER option.
AlterServerConfigurationSetBufferPoolExtensionStatementRepresents ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION statement.
AlterServerConfigurationSetDiagnosticsLogStatementRepresents ALTER SERVER CONFIGURATION SET DIAGNOSTICS LOG statement.
AlterServerConfigurationSetExternalAuthenticationStatementRepresents ALTER SERVER CONFIGURATION SET EXTERNAL AUTHENTICATION statement.
AlterServerConfigurationSetFailoverClusterPropertyStatementRepresents ALTER SERVER CONFIGURATION SET FAILOVER CLUSTER PROPERTY statement.
AlterServerConfigurationSetHadrClusterStatementRepresents ALTER SERVER CONFIGURATION SET HADR CLUSTER statement.
AlterServerConfigurationSetSoftNumaStatementRepresents ALTER SERVER CONFIGURATION SET SOFTNUMA statement.
AlterServerConfigurationSoftNumaOptionRepresents a single ALTER SERVER CONFIGURATION SET SOFTNUMA option.
AlterServerConfigurationStatementRepresents ALTER SERVER CONFIGURATION statement.
AlterServerRoleStatementRepresents the ALTER SERVER ROLE statement.
AlterServiceMasterKeyStatementRepresents ALTER SERVICE MASTER KEY statement
AlterServiceStatementRepresents ALTER SERVICE statement
AlterSymmetricKeyStatementRepresents ALTER SYMMETRIC KEY statement
AlterTableAddTableElementStatementAdd table element specialization of Alter Table statement. Has column and constraint definitions.
AlterTableAlterColumnStatementAlter column specialization of Alter Table statement.
AlterTableAlterIndexStatementAlter index rebuild specialization of Alter Table statement.
AlterTableAlterPartitionStatementSplit/Merge the partitions of a SQL DW table.
AlterTableChangeTrackingModificationStatementModifies change tracking for a table.
AlterTableConstraintModificationStatementDefines modifications to a table constraint.
AlterTableDropTableElementRepresents an individual element that can be used in alter table drop statement.
AlterTableDropTableElementStatementDrop table element specialization of Alter Table statement. Has names of columns and constraints to be dropped.
AlterTableFileTableNamespaceStatementEnables or disable filetable namespace on a table.
AlterTableRebuildStatementRebuilds indicies on a table.
AlterTableSetStatementChanges table options for a table.
AlterTableStatementRepresents the alter table statement base class.
AlterTableSwitchStatementSwitch specialization of Alter Table statement.
AlterTableTriggerModificationStatementDefines the modifications to a Trigger on a table. Triggers can be enabled or disabled.
AlterTriggerStatementThe ALTER TRIGGER statement.
AlterUserStatementRepresents the alter user statement.
AlterViewStatementThe ALTER VIEW statement.
AlterWorkloadGroupStatementRepresents the Alter Workload Group statement.
AlterXmlSchemaCollectionStatementRepresents the alter xml schema collection statement.
ApplicationRoleOptionRepresents the application role option.
ApplicationRoleStatementRepresents the application role statement base.
AssemblyEncryptionSourceRepresents reference to an assembly containing key or certificate
AssemblyNameRepresents CLR assembly names.
AssemblyOptionRepresents an assembly option.
AssemblyStatementRepresents common parts in create and alter assembly statements.
AssignmentSetClauseRepresents SET clause for assignment.
AsymmetricKeyCreateLoginSourceCertificate case in CREATE LOGIN statement
AtomicBlockOptionRepresents single atomic block option.
AtTimeZoneCallRepresents the AT TIME ZONE call.
AuditActionGroupReferenceRepresents audit group reference.
AuditActionSpecificationRepresents audit action specification.
AuditGuidAuditOptionAUDIT_GUID option in CREATE SERVER AUDIT statement.
AuditOptionSingle option in CREATE/ALTER SERVER AUDIT statement.
AuditSpecificationDetailBase class for audit action specification and audit action group name.
AuditSpecificationPartRepresents one ADD/DROP clause in audit specification statement.
AuditSpecificationStatementRepresents audit specification statement.
AuditTargetAudit target in CREATE/ALTER SERVER AUDIT statements.
AuditTargetOptionSingle option for audit target.
AuthenticationEndpointProtocolOptionRepresents AUTHENTICATION HTTP endpoint protocol option
AuthenticationPayloadOptionRepresents AUTHENTICATION payload option
AutoCleanupChangeTrackingOptionDetailAUTO_CLEANUP part of CHANGE_TRACKING option in ALTER DATABASE SET statement.
AutoCreateStatisticsDatabaseOptionDatabase option with parentheses-wrapped suboptions.
AutomaticTuningCreateIndexOptionCreate Index part of Automatic Tuning Options
AutomaticTuningDatabaseOptionAutomatic tuning option in ALTER DATABASE statement, SET case
AutomaticTuningDropIndexOptionDrop Index part of Automatic Tuning Options
AutomaticTuningForceLastGoodPlanOptionForce Last Good Plan part of Automatic Tuning Options
AutomaticTuningMaintainIndexOptionMaintain Index part of Automatic Tuning Options
AutomaticTuningOptionA single Automatic Tuning option.
AvailabilityGroupOptionBase for availability group options.
AvailabilityGroupStatementBase for availability group statements
AvailabilityModeReplicaOptionRepresents the replica option for availability mode.
AvailabilityReplicaThe declaration of an availability replica.
AvailabilityReplicaOptionRepresents an availability replica option.
BackupCertificateStatementRepresents BACKUP CERTIFICATE statement
BackupDatabaseStatementRepresents BACKUP DATABASE statement
BackupEncryptionOptionRepresents the encryption option in a backup statement.
BackupMasterKeyStatementRepresents BACKUP MASTER KEY statement
BackupOptionRepresents a single option in BACKUP statement
BackupRestoreFileInfoInformation about files/filegroups being backed up/restored (READ_WRITE_FILEGROUPS - 2005 only)
BackupRestoreMasterKeyStatementBaseRepresents common part of BACKUP and RESTORE (SERVICE) MASTER KEY statements
BackupServiceMasterKeyStatementRepresents BACKUP SERVICE MASTER KEY statement
BackupStatementRepresents BACKUP/DUMP statement
BackupTransactionLogStatementRepresents BACKUP TRANSACTION statement
BackwardsCompatibleDropIndexClauseRepresents old-style clause in DROP INDEX statement
BeginConversationTimerStatementRepresents BEGIN CONVERSATION TIMER statement
BeginDialogStatementRepresents BEGIN DIALOG statement
BeginEndAtomicBlockStatementRepresents a group of statements that start with a BEGIN and end with an END keyword in a ATOMIC block.
BeginEndBlockStatementRepresents a group of statements that start with a BEGIN and end with an END keyword.
BeginTransactionStatementRepresents the begin transaction and begin distributed transaction statements.
BinaryExpressionAn expression that has two expressions as children.
BinaryLiteralRepresents a Binary literal.
BinaryQueryExpressionThis class represents the union that is used in a select statement.
BooleanBinaryExpressionA boolean expression that has two boolean expressions as children
BooleanComparisonExpressionA boolean expression that does a comparison between two scalar expressions
BooleanExpressionThe abstract base class that represents boolean expressions
BooleanExpressionSnippetPlaceholder for an arbitrary boolean expression.
BooleanIsNullExpressionA boolean expression for IS [NOT] NULL
BooleanNotExpressionRepresents a NOT boolean expression
BooleanParenthesisExpressionRepresents a boolean expression enclosed in parentheses.
BooleanTernaryExpressionA boolean expression that has three expressions as children.
BoundingBoxParameterRepresents the spatial index structured parameter by name.
BoundingBoxSpatialIndexOptionRepresents the BOUNDING_BOX spatial index option.
BreakStatementRepresents the break statement.
BrokerPriorityParameterRepresents the broker prioriry statement parameters.
BrokerPriorityStatementRepresents Create and Alter Broker Priority Statement.
BrowseForClauseRepresents FOR BROWSE case
BuiltInFunctionTableReferenceThis class represents the built in functions as a simple table reference.
BulkInsertBaseRepresents BULK INSERT statement
BulkInsertOptionRepresents single option in BULK INSERT statement
BulkInsertStatementRepresents BULK INSERT statement
BulkOpenRowsetRepresents OPENROWSET (BULK ...) table reference.
CallTargetRepresents a target of a function call.
CaseExpressionRepresents the case expression.
CastCallRepresents the cast call.
CatalogCollationOptionSets the database's CATALOG_COLLATION
CellsPerObjectSpatialIndexOptionRepresents the CELLS_PER_OBJECT spatial index option.
CertificateCreateLoginSourceCertificate case in CREATE LOGIN statement
CertificateOptionRepresents single SUBJECT or START_DATE or EXPIRE_DATE options in CREATE CERTIFICATE statement
CertificateStatementBaseRepresents CREATE CERTIFICATE statement
ChangeRetentionChangeTrackingOptionDetailCHANGE_RETENTION part of CHANGE_TRACKING option in ALTER DATABASE SET statement.
ChangeTableChangesTableReferenceCHANGETABLE clause with CHANGES option.
ChangeTableVersionTableReferenceCHANGETABLE clause with VERSION option.
ChangeTrackingDatabaseOptionCHANGE_TRACKING option in ALTER DATABASE statement, SET case
ChangeTrackingFullTextIndexOptionRepresents CHANGE_TRACKING option in FULLTEXT INDEX statement.
ChangeTrackingOptionDetailOne detail for ChangeTrackingDatabaseOption
CharacterSetPayloadOptionRepresents CHARACTER_SET payload option
CheckConstraintDefinitionRepresents the check constraint.
CheckpointStatementRepresents the checkpoint statement.
ChildObjectNameRepresents the name of a schema object child.
ClassifierEndTimeOptionRepresents the start time option for workload classifier.
ClassifierImportanceOptionRepresents the importance option for workload classifier.
ClassifierMemberNameOptionRepresents the member name option for workload classifier.
ClassifierStartTimeOptionRepresents the start time option for workload classifier.
ClassifierWlmContextOptionRepresents the wlm context option for workload classifier.
ClassifierWlmLabelOptionRepresents the query label option for workload classifier.
ClassifierWorkloadGroupOptionRepresents the workload group option for workload classifier.
CloseCursorStatementClose cursor statement
CloseMasterKeyStatementClose master key statement.
CloseSymmetricKeyStatementClose symmetric key statement.
CoalesceExpressionRepresents the coalesce expression.
ColumnDefinitionThis fragment represents a column definition
ColumnDefinitionBaseRepresents most basic column definition
ColumnEncryptionAlgorithmNameParameterParameter representing the encryption algorithm used to encrypt the column encryption key
ColumnEncryptionAlgorithmParameterSingle parameter in column definition for column encryption algorithm used to encrypt the column
ColumnEncryptionDefinitionClass representing the encryption properties for a column
ColumnEncryptionDefinitionParameterSingle encryption parameter for a column
ColumnEncryptionKeyNameParameterParameter representing the column encryption key used to encrypt the column
ColumnEncryptionKeyStatementBase class for all Column Encryption Key statement objects
ColumnEncryptionKeyValueClass representing the value of a column encryption key encrypted with column master key
ColumnEncryptionKeyValueParameterSingle parameter in of a column encryption key value
ColumnEncryptionTypeParameterSingle parameter in column definition for column encryption type
ColumnMasterKeyEnclaveComputationsParameterParameter representing enclave computation signature
ColumnMasterKeyNameParameterParameter representing the column master key used to encrypt the column encrytion key
ColumnMasterKeyParameterSingle parameter in CREATE COLUMN MASTER KEY statement
ColumnMasterKeyPathParameterParameter representing path of the key in the key store provider
ColumnMasterKeyStoreProviderNameParameterKey store provider parameter protecting the column master key
ColumnReferenceExpressionThis 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.
ColumnStorageOptionsRepresents column storage options.
ColumnWithSortOrderRepresents a column identifier with a sort order.
CommandSecurityElement80Represents the security element that has commands.
CommitTransactionStatementRepresents the commit transaction statement.
CommonTableExpressionThis class represents the common table expression.
CompositeGroupingSpecificationComposes a list of sub-specifications.
CompressionDelayIndexOptionRepresents the compression delay index option that can be an expression with an optional minute/minutes time unit.
CompressionEndpointProtocolOptionRepresents PORTS HTTP endpoint protocol option
CompressionPartitionRangeRepresents a single range in DATA_COMPRESSION option.
ComputeClauseRepresents the compute by clause that can be used in statements like select.
ComputeFunctionRepresents compute function that can be used in compute clause.
ConstraintDefinitionRepresents base class for constraints.
ContainmentDatabaseOptionDatabase option for containment
ContinueStatementRepresents the continue statement.
ContractMessageRepresents information about single message in CREATE CONTRACT statement
ConvertCallRepresents the convert call.
CopyColumnOptionRepresents column options of copy command
CopyCredentialOptionRepresents COPY statement CREDENTIAL options
CopyOptionRepresents COPY statement options
CopyStatementRepresents COPY statement
CopyStatementOptionBaseA single copy statement option.
CreateAggregateStatementRepresents CREATE AGGREGATE statement
CreateApplicationRoleStatementRepresents the create application role statement.
CreateAssemblyStatementRepresents the CREATE ASSEMBLY statement.
CreateAsymmetricKeyStatementRepresents CREATE ASYMMETRIC KEY statement
CreateAvailabilityGroupStatementRepresents the CREATE AVAILABILITY GROUP statement
CreateBrokerPriorityStatementRepresents the Create Broker Priority statement.
CreateCertificateStatementRepresents CREATE CERTIFICATE statement
CreateColumnEncryptionKeyStatementRepresents a CREATE COLUMN ENCRYPTION KEY statement
CreateColumnMasterKeyStatementRepresents a CREATE COLUMN MASTER KEY statement
CreateColumnStoreIndexStatementRepresents the create column store index statement.
CreateContractStatementRepresents CREATE CONTRACT statement
CreateCredentialStatementRepresents CREATE CREDENTIAL statement
CreateCryptographicProviderStatementRepresents the Create Cryptographic Provider statement.
CreateDatabaseAuditSpecificationStatementCreates database audit specification.
CreateDatabaseEncryptionKeyStatementCreates database encryption key
CreateDatabaseStatementRepresents CREATE DATABASE statement
CreateDefaultStatementRepresents the Create Default statement.
CreateEndpointStatementRepresents CREATE ENDPOINT statement
CreateEventNotificationStatementRepresents the create event notification statement.
CreateEventSessionStatementRepresents the Create Event Session statement.
CreateExternalDataSourceStatementRepresents a CREATE EXTERNAL DATA SOURCE statement.
CreateExternalFileFormatStatementRepresents a CREATE EXTERNAL FILE FORMAT statement.
CreateExternalLanguageStatementRepresents the CREATE EXTERNAL LANGUAGE statement.
CreateExternalLibraryStatementRepresents the CREATE EXTERNAL LIBRARY statement.
CreateExternalResourcePoolStatementRepresents the Create External Resource Pool statement.
CreateExternalStreamingJobStatementRepresents an EXEC sys.sp_create_streaming_job statement.
CreateExternalStreamStatementRepresents an CREATE EXTERNAL STREAM statement.
CreateExternalTableStatementRepresents a CREATE EXTERNAL TABLE statement.
CreateFederationStatementRepresents the CREATE FEDERATION statement
CreateFullTextCatalogStatementRepresents CREATE FULLTEXT CATALOG statement
CreateFullTextIndexStatementRepresents the create fulltext index statement.
CreateFullTextStopListStatementRepresents the Create FullText StopList statement.
CreateFunctionStatementRepresents the Create Function statement.
CreateIndexStatementRepresents the create index statement.
CreateLoginSourceBase class for different login sources in CREATE LOGIN statement
CreateLoginStatementRepresents CREATE LOGIN statement.
CreateMasterKeyStatementRepresents CREATE MASTER KEY statement.
CreateMessageTypeStatementRepresents CREATE MESSAGE TYPE statement
CreateOrAlterFunctionStatementRepresents the Create Or Alter Function statement.
CreateOrAlterProcedureStatementThe create or alter procedure statement.
CreateOrAlterTriggerStatementThe CREATE OR ALTER TRIGGER statement.
CreateOrAlterViewStatementThe CREATE OR ALTER VIEW statement.
CreatePartitionFunctionStatementRepresents CREATE PARTITION FUNCTION statement
CreatePartitionSchemeStatementRepresents CREATE PARTITION SCHEME statement
CreateProcedureStatementThe create procedure statement.
CreateQueueStatementRepresents create queue statement.
CreateRemoteServiceBindingStatementRepresents CREATE REMOTE SERVICE BINDING statement
CreateResourcePoolStatementRepresents the Create Resource Pool statement.
CreateRoleStatementRepresents the create role statement.
CreateRouteStatementRepresents create route statement.
CreateRuleStatementRepresents the Create Rule statement.
CreateSchemaStatementRepresents the create schema statement.
CreateSearchPropertyListStatementRepresents CREATE SEARCH PROPERTY LIST statement
CreateSecurityPolicyStatementRepresents a CREATE SECURITY POLICY statement
CreateSelectiveXmlIndexStatementRepresents the create selective xml index statement.
CreateSequenceStatementRepresents CREATE SEQUENCE statement
CreateServerAuditSpecificationStatementCreates server audit specification.
CreateServerAuditStatementCreates server audit.
CreateServerRoleStatementRepresents the CREATE SERVER ROLE statement.
CreateServiceStatementRepresents CREATE SERVICE statement
CreateSpatialIndexStatementRepresents the Create Spatial Index statement.
CreateStatisticsStatementRepresents the create statistics statement.
CreateSymmetricKeyStatementRepresents CREATE SYMMETRIC KEY statement
CreateSynonymStatementRepresents the create synonym statement.
CreateTableStatementRepresents Create Table statement
CreateTriggerStatementThe CREATE TRIGGER statement.
CreateTypeStatementRepresents the create type statement.
CreateTypeTableStatementCreates table type
CreateTypeUddtStatementRepresents the create type statement for user defined data types, the one that derive from Sql types.
CreateTypeUdtStatementRepresents the create type statement for user defined types, the one that derive from CLR types.
CreateUserStatementRepresents the create user statement.
CreateViewStatementThe CREATE VIEW statement.
CreateWorkloadClassifierStatementRepresents the Create Workload Classifier statement.
CreateWorkloadGroupStatementRepresents the Create Workload Group statement.
CreateXmlIndexStatementRepresents the create xml index statement.
CreateXmlSchemaCollectionStatementRepresents the create xml schema collection statement.
CreationDispositionKeyOptionRepresents CREATION_DISPOSITION option.
CredentialStatementRepresents common parts of ALTER and CREATE CREDENTIAL statement
CryptoMechanismRepresents the decryption mechanism.
CubeGroupingSpecificationRepresents CUBE grouping specification.
CursorDefaultDatabaseOptionCURSOR_DEFAULT option in ALTER DATABASE statement, SET case
CursorDefinitionRepresents cursor definition
CursorIdRepresents reference to cursor
CursorOptionRepresents a cursor option.
CursorStatementBase type for open/close/fetch cursor statements
DatabaseAuditActionRepresents a single action in audit action specification.
DatabaseConfigurationClearOptionSingle option in ALTER DATABASE SCOPED CONFIGURATION statement, CLEAR option
DatabaseConfigurationSetOptionSingle option in ALTER DATABASE SCOPED CONFIGURATION statement, SET option
DatabaseEncryptionKeyStatementBase class for statements dealing with encryption key.
DatabaseOptionSingle option in ALTER DATABASE statement, SET case
DataCompressionOptionRepresents a single data compression option.
DataModificationSpecificationBase class for common options of data modification specifications.
DataModificationStatementRepresents a data modification statement.
DataModificationTableReferenceRepresents sub-dml with output clause which serves as table reference.
DataRetentionTableOptionDATA_RETENTION table option.
DataTypeReferenceThe base data type class.
DataTypeSequenceOptionRepresents sequence Option that defines the data type
DbccNamedLiteralRepresents named literal in DBCC statement
DbccOptionRepresents a dbcc option.
DbccStatementRepresents DBCC statement (all variants)
DeallocateCursorStatementDeallocate cursor statement
DeclareCursorStatementRepresents DECLARE CURSOR statement
DeclareTableVariableBodyRepresents the body of the declare @variable table variation.
DeclareTableVariableStatementThis class represents the declare @variable statement's table variation.
DeclareVariableElementThis class represents a single declaration in the body of DeclareVariableStatement.
DeclareVariableStatementThis statement represents declare @variable statement except table declarations.
DefaultConstraintDefinitionRepresents the default constraint.
DefaultLiteralRepresents the literal for DEFAULT
DelayedDurabilityDatabaseOptionDatabase option for delayed durability
DeleteMergeActionRepresents delete merge action
DeleteSpecificationThe properties for Delete
DeleteStatementRepresents the delete statement.
DenyStatementRepresents the deny statement.
DenyStatement80Represents the deny statement.
DeviceInfoRepresents information about device used for backup or restore
DialogOptionRepresents a dialog option.
DiskStatementRepresents the DISK statement.
DiskStatementOptionRepresents disk statement option.
DistinctPredicateRepresents the distinct predicate.
DropAggregateStatementRepresents DROP AGGREGATE statement
DropAlterFullTextIndexActionRepresents DROP action for ALTER FULLTEXT INDEX statement.
DropApplicationRoleStatementRepresents DROP APPLICATION ROLE statement.
DropAssemblyStatementRepresents DROP ASSEMBLY statement
DropAsymmetricKeyStatementRepresents DROP ASYMMETRIC KEY statement.
DropAvailabilityGroupStatementRepresents the DROP AVAILABILITY GROUP statement.
DropBrokerPriorityStatementRepresents the Drop Broker Priority statement.
DropCertificateStatementRepresents DROP CERTIFICATE statement.
DropChildObjectsStatementRepresents DROP which has child objects (DROP INDEX or STATISTICS)
DropClusteredConstraintMoveOptionThe drop clustered constraint move option
DropClusteredConstraintOptionThe abstract base class for drop clustered constraints.
DropClusteredConstraintStateOptionThe abstract base class for drop clustered constraints.
DropClusteredConstraintValueOptionThe drop clustered constraint option with value specified
DropClusteredConstraintWaitAtLowPriorityLockOptionThe drop clustered constraint wait at low priority lock option
DropColumnEncryptionKeyStatementRepresents a DROP COLUMN ENCRYPTION KEY statement
DropColumnMasterKeyStatementRepresents a DROP COLUMN MASTER KEY statement
DropContractStatementRepresents DROP CONTRACT statement.
DropCredentialStatementRepresents DROP CREDENTIAL statement.
DropCryptographicProviderStatementRepresents the Drop Cryptographic Provider statement.
DropDatabaseAuditSpecificationStatementRepresents DROP DATABASE AUDIT SPECIFICATION statement.
DropDatabaseEncryptionKeyStatementDrops database encryption key.
DropDatabaseStatementRepresents DROP DATABASE statement
DropDefaultStatementRepresents DROP DEFAULT statement
DropEndpointStatementRepresents DROP ENDPOINT statement.
DropEventNotificationStatementRepresents DROP EVENT NOTIFICATION statement.
DropEventSessionStatementRepresents the Drop Event Session statement.
DropExternalDataSourceStatementRepresents a DROP EXTERNAL DATA SOURCE statement.
DropExternalFileFormatStatementRepresents a DROP EXTERNAL FILE FORMAT statement.
DropExternalLanguageStatementRepresents the DROP EXTERNAL LANGUAGE statement.
DropExternalLibraryStatementRepresents the DROP EXTERNAL LIBRARY statement.
DropExternalResourcePoolStatementRepresents the Drop External Resource Pool statement.
DropExternalStreamingJobStatementRepresents an EXEC sys.sp_drop_streaming_job statement.
DropExternalStreamStatementRepresents a DROP EXTERNAL STREAM statement.
DropExternalTableStatementRepresents a DROP EXTERNAL TABLE statement.
DropFederationStatementRepresents the DROP FEDERATION statement.
DropFullTextCatalogStatementRepresents DROP FULLTEXT CATALOG statement.
DropFullTextIndexStatementRepresents DROP FULLTEXT INDEX statement.
DropFullTextStopListStatementRepresents the Drop Fulltext Stoplist statement.
DropFunctionStatementRepresents DROP FUNCTION statement
DropIndexClauseRepresents relational or xml index in DROP INDEX statement
DropIndexClauseBaseRepresents single clause in DROP INDEX statement
DropIndexStatementRepresents DROP INDEX statement
DropLoginStatementRepresents DROP LOGIN statement.
DropMasterKeyStatementRepresents DROP MASTER KEY statement.
DropMemberAlterRoleActionRepresents the drop member alter role action.
DropMessageTypeStatementRepresents DROP MESSAGE TYPE statement.
DropObjectsStatementRepresents DROP statement which references list of objects
DropPartitionFunctionStatementRepresents DROP PARTITION FUNCTION statement.
DropPartitionSchemeStatementRepresents DROP PARTITION SCHEME statement.
DropProcedureStatementRepresents DROP PROCEDURE statement
DropQueueStatementRepresents DROP QUEUE statement.
DropRemoteServiceBindingStatementRepresents DROP REMOTE SERVICE BINDING statement.
DropResourcePoolStatementRepresents the Drop Resource Pool statement.
DropRoleStatementRepresents DROP ROLE statement.
DropRouteStatementRepresents DROP ROUTE statement.
DropRuleStatementRepresents DROP RULE statement
DropSchemaStatementRepresents DROP SCHEMA statement
DropSearchPropertyListActionThe DROP search property list action
DropSearchPropertyListStatementRepresents DROP SEARCH PROPERTY LIST statement
DropSecurityPolicyStatementRepresents a DROP SECURITY POLICY statement
DropSensitivityClassificationStatementDrops sensitivity classification from specified columns.
DropSequenceStatementRepresents DROP SEQUENCE statement
DropServerAuditSpecificationStatementRepresents DROP SERVER AUDIT SPECIFICATION statement.
DropServerAuditStatementDrops server audit.
DropServerRoleStatementRepresents the DROP SERVER ROLE statement.
DropServiceStatementRepresents DROP SERVICE statement.
DropSignatureStatementRepresents DROP SIGNATURE statements.
DropStatisticsStatementRepresents DROP STATISTICS statement
DropSymmetricKeyStatementRepresents DROP SYMMETRIC KEY statement.
DropSynonymStatementRepresents DROP SYNONYM statement
DropTableStatementRepresents DROP TABLE statement
DropTriggerStatementRepresents DROP TRIGGER statement
DropTypeStatementRepresents DROP TYPE statement.
DropUnownedObjectStatementRepresents DROP statement for those unowned objects
DropUserStatementRepresents DROP USER statement.
DropViewStatementRepresents DROP VIEW statement
DropWorkloadClassifierStatementRepresents Drop Workload Classifier statement
DropWorkloadGroupStatementRepresents the Drop Workload Group statement.
DropXmlSchemaCollectionStatementRepresents DROP XML SCHEMA COLLECTION statement.
DurabilityTableOptionDURABILITY table option.
DWCompatibilityLevelConfigurationOptionDWCompatibilityLevel option in ALTER DATABASE SCOPED CONFIGURATION statement
EnabledDisabledPayloadOptionRepresents an option which can be either ENABLED or DISABLED
EnableDisableTriggerStatementDefines the modifications to triggers. Triggers can be enabled or disabled.
EncryptedValueParameterParameter representing the encrypted value of the column encryption key
EncryptionPayloadOptionRepresents ENCRYPTION payload option
EncryptionSourceBase class for different key/certificates sources
EndConversationStatementRepresents END CONVERSATION statement
EndpointAffinityRepresents AFFINITY option in CREATE/ALTER ENDPOINT statements
EndpointProtocolOptionRepresents single protocol option in CREATE ENDPOINT statement
EventDeclarationRepresents the event declaration
EventDeclarationCompareFunctionParameterRepresents the event declaration predicate parameter
EventDeclarationSetParameterRepresents the event declaration set parameter
EventGroupContainerRepresents event type
EventNotificationObjectScopeRepresents scope of event notification.
EventRetentionSessionOptionRepresents the EVENT_RETENTION_MODE session option
EventSessionObjectNameRepresents object names used in CREATE and ALTER EVENT SESSION statements.
EventSessionStatementRepresents the CREATE and ALTER EVENT SESSION statement.
EventTypeContainerRepresents event type
EventTypeGroupContainerRepresents event type or group
ExecutableEntityBase class for all possible things which can be executed with EXECUTE statement.
ExecutableProcedureReferenceRepresents a reference to a procedure in execute.
ExecutableStringListStrings representing commands passed to EXECUTE statement.
ExecuteAsClauseRepresents the execute as clause.
ExecuteAsFunctionOptionThe execute as function option
ExecuteAsProcedureOptionThe execute as procedure option
ExecuteAsStatementRepresents EXECUTE AS statement
ExecuteAsTriggerOptionThe EXECUTE AS trigger option
ExecuteContextRepresents the security context for execute statements
ExecuteInsertSourceRepresents the insert source for EXECUTE.
ExecuteOptionRepresents an option to the execute statement
ExecuteParameterParameter passed to procedure in EXECUTE statement
ExecuteSpecificationRepresents a call to EXECUTE
ExecuteStatementRepresents the EXECUTE T-SQL statement
ExistsPredicateRepresents the exists predicate.
ExpressionCallTargetRepresents an expression target of a function call.
ExpressionGroupingSpecificationAn expression on which the grouping operation is performed.
ExpressionWithSortOrderThis class represents an expression with a sort order.
ExternalCreateLoginSourceExternal case in CREATE LOGIN statement
ExternalDataSourceLiteralOrIdentifierOptionRepresents property of type Literal or Identifier.
ExternalDataSourceOptionCREATE EXTERNAL DATA SOURCE statement optional property.
ExternalDataSourceStatementBase class for all external data source statement objects.
ExternalFileFormatContainerOptionRepresents a list of external file format suboptions.
ExternalFileFormatLiteralOptionRepresents any property value of type Literal.
ExternalFileFormatOptionCREATE EXTERNAL FILE FORMAT statement optional property.
ExternalFileFormatStatementBase class for all external file format statement objects.
ExternalFileFormatUseDefaultTypeOptionRepresents the USE_DEFAULT_TYPE optional property value.
ExternalFileOptionExternalFileOption base class.
ExternalLanguageFileOptionRepresents a single file in CREATE EXTERNAL LANGUAGE statement
ExternalLanguageStatementRepresents common parts in create and alter external language statements.
ExternalLibraryFileOptionRepresents a single file in CREATE EXTERNAL LIBRARY statement
ExternalLibraryStatementRepresents common parts in create and alter external library statements.
ExternalResourcePoolAffinitySpecificationRepresents the external resource pool statement affinity specification.
ExternalResourcePoolParameterRepresents the external resource pool statement parameters.
ExternalResourcePoolStatementRepresents Create and Alter External Resource Pool Statement.
ExternalStreamingJobStatementBase class for all external streaming job statement objects.
ExternalStreamLiteralOrIdentifierOptionRepresents property of type Literal or Identifier.
ExternalStreamOptionCREATE EXTERNAL STREAM statement optional property.
ExternalStreamStatementBase class for all external stream statement objects.
ExternalTableColumnDefinitionRepresents most basic column definition.
ExternalTableDistributionOptionThe external table DISTRIBUTION option for external tables on shard map manager data sources.
ExternalTableDistributionPolicyBase class for external table distribution policies.
ExternalTableLiteralOrIdentifierOptionAn external table with clause option that expects a literal or identifer as the value being set.
ExternalTableOptionA single external table option.
ExternalTableRejectTypeOptionThe external table REJECT_TYPE option for external tables on HDFS data sources.
ExternalTableReplicatedDistributionPolicyRepresentation of the REPLICATED option for an external table distribution policy.
ExternalTableRoundRobinDistributionPolicyRepresentation of the ROUND_ROBIN option for an external table distribution policy.
ExternalTableShardedDistributionPolicyRepresentation of the SHARDED option for an external table distribution policy.
ExternalTableStatementBase class for all external table statement objects.
ExtractFromExpressionRepresents the expression that start with Extract from.
FailoverModeReplicaOptionRepresents the replica option for failover mode.
FederationSchemeThis class stores the federation scheme for a table
FetchCursorStatementRepresents FETCH cursor statement
FetchTypeHolds information about different fetch orientations
FileDeclarationRepresents single file declaration in CREATE DATABASE statement
FileDeclarationOptionRepresents single file declaration option in CREATE DATABASE statement
FileEncryptionSourceRepresents reference to a (executable) file containing key or certificate
FileGroupDefinitionRepresent filegroup in CREATE DATABASE statement
FileGroupOrPartitionSchemeRepresents a filegroup or a partition scheme.
FileGrowthFileDeclarationOptionThe file declaration option for FILEGROWTH.
FileNameFileDeclarationOptionThe file declaration option for FILENAME.
FileStreamDatabaseOptionFILESTREAM option in create and alter database.
FileStreamOnDropIndexOptionRepresents the FILESTREAM_ON option in DROP INDEX
FileStreamOnTableOptionFilestream_on table option.
FileStreamRestoreOptionRepresents the FileStream option in a restore statement.
FileTableCollateFileNameTableOptionFILETABLE_COLLATE_FILENAME table option.
FileTableConstraintNameTableOptionFILETABLE_PRIMARY_KEY_CONSTRAINT_NAME, FILETABLE_STREAMID_UNIQUE_CONSTRAINT_NAME, or FILETABLE_FULLPATH_UNIQUE_CONSTRAINT_NAME table option.
FileTableDirectoryTableOptionFILETABLE_DIRECTORY table option.
ForceSeekTableHintRepresents forceseek hint.
ForClauseBase class for different FOR clauses in SELECT
ForeignKeyConstraintDefinitionRepresents the foreign key constraint.
FromClauseRepresents the From clause in a QuerySpecification
FullTextCatalogAndFileGroupRepresents catalog / filegroup option in CREATE FULLTEXT STATEMENT.
FullTextCatalogOptionBase class for fulltext catalog options.
FullTextCatalogStatementRepresents CREATE FULLTEXT CATALOG statement
FullTextIndexColumnRepresents the column for a fulltext index.
FullTextIndexOptionRepresents a single option in CREATE FULLTEXT INDEX statement.
FullTextPredicateRepresents the fulltext predicate.
FullTextStopListActionRepresents the action in Alter Fulltext Stoplist Statement.
FullTextTableReferenceRepresents FREETEXTTABLE and CONTAINSTABLE table references.
FunctionCallRepresents a function call.
FunctionCallSetClauseRepresents SET clause for function calls.
FunctionOptionRepresents a Function Option
FunctionReturnTypeBase class for function return type
FunctionStatementBodyRepresents CREATE/ALTER FUNCTION statement
GeneralSetCommandTo 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!)
GenericConfigurationOptionOption which can be set to a signed integer, string literal, identifier or the keywords ON/OFF/PRIMARY.
GetConversationGroupStatementRepresents GET CONVERSATION GROUP statement
GlobalFunctionTableReferenceThis class represents the set of global built in functions which do not belong to a schema.
GlobalVariableExpressionRepresents a global variable expression
GoToStatementRepresents the goto statement.
GrandTotalGroupingSpecificationRepresents ( ) (grand total) grouping specification.
GrantStatementRepresents the grant statement.
GrantStatement80Represents the grant statement.
GraphConnectionBetweenNodesThe abstract base class that represents the connection from one node table to other in graph tables.
GraphConnectionConstraintDefinitionRepresents the connection constraint for graph tables.
GraphMatchCompositeExpressionA boolean expression for a MATCH expression
GraphMatchExpressionA boolean expression for a MATCH expression
GraphMatchLastNodePredicateA boolean expression for LastNode
GraphMatchNodeExpressionA boolean expression for MATCH
GraphMatchPredicateA boolean expression for MATCH
GraphMatchRecursivePredicateA boolean expression for Shortest Path expression
GraphRecursiveMatchQuantifierA boolean expression for MATCH
GridParameterRepresents the spatial index structured parameter for GRIDS option.
GridsSpatialIndexOptionRepresents the GRIDS spatial index option.
GroupByClauseRepresents the group by clause that can be used in statements like select, update.
GroupingSetsGroupingSpecificationRepresents GROUPING SETS grouping specification.
GroupingSpecificationRepresents a single grouping specification in GROUP BY clause.
HadrAvailabilityGroupDatabaseOptionDatabase option for hadr availability group
HadrDatabaseOptionDatabase option for HADR.
HavingClauseRepresents the having clause that can be used in statements like select.
IdentifierThis fragment is used to represent an identifier
IdentifierAtomicBlockOptionOption which be set to an identifier in BEGIN ATOMIC…END statement
IdentifierDatabaseOptionDatabase option with an identifier value
IdentifierLiteralRepresents an identifier that is treated as a literal.
IdentifierOrScalarExpressionRepresents either an Identifer or ScalarExpression
IdentifierOrValueExpressionRepresents either an Identifer or ValueExpression
IdentifierPrincipalOptionOptions with identifier value in CREATE or ALTER LOGIN or USER statement
IdentifierSnippetPlaceholder for an arbitrary identifier.
IdentityFunctionCallThis class represents the identity function that can be used in a SelectColumn.
IdentityOptionsRepresents Identity Options for a Column
IdentityValueKeyOptionRepresents IDENTITY_VALUE option.
IfStatementRepresents the if statement.
IgnoreDupKeyIndexOptionRepresents the ignore_dup_key index option.
IIfCallRepresents the iif expression.
IndexDefinitionRepresents the base for index definitions.
IndexExpressionOptionRepresents the index option that could be an expression.
IndexOptionRepresents the index option.
IndexStatementRepresents the base for create index statements.
IndexStateOptionRepresents the index option that could be on or off.
IndexTableHintRepresents INDEX table hint.
IndexTypeRepresents an index type
InlineDerivedTableThis node represents a derived table.
InlineFunctionOptionThe Inline function option
InlineResultSetDefinitionRepresents the inline definition of a result set
InPredicateRepresents the in predicate.
InsertBulkColumnDefinitionRepresents column definition in INSERT BULK statement (?)
InsertBulkStatementRepresents INSERT BULK statement (BCP syntax)
InsertMergeActionRepresents insert merge action
InsertSourceBase class for source nodes of insert statements.
InsertSpecificationThe properties for Insert
InsertStatementRepresents the insert statement.
IntegerLiteralRepresents an Integer literal.
InternalOpenRowsetRepresents OPENROWSET table reference - undocumented case.
IPv4Represents IP address (x.x.x.x)
JoinParenthesisTableReferenceRepresents the parenthesis that can encapsulate a join.
JoinTableReferenceBase class for JOIN table references
JsonForClauseRepresents FOR JSON (options) case
JsonForClauseOptionRepresents FOR JSON (options) case
JsonKeyValueRepresent a key value Pair
KeyOptionRepresents key option in CREATE SYMMETRIC KEY statement.
KeySourceKeyOptionRepresents KEY_SOURCE option.
KillQueryNotificationSubscriptionStatementRepresents the kill query notification subscription statement.
KillStatementRepresents the kill statement.
KillStatsJobStatementRepresents the kill stats job statement.
LabelStatementRepresents the label statement.
LedgerOptionSets the database's Ledger Option
LedgerTableOptionLEDGER table option.
LedgerViewOptionLEDGER View option.
LeftFunctionCallRepresents LEFT call.
LikePredicateRepresents the like predicate.
LineNoStatementRepresents the lineno statement.
ListenerIPEndpointProtocolOptionRepresents LISTENER_IP TCP endpoint protocol option
ListTypeCopyOptionRepresents list of same kind of external file options
LiteralRepresents a literal constant.
LiteralAtomicBlockOptionOption which be set to a value in BEGIN ATOMIC…END statement
LiteralAuditTargetOptionAudit option with a literal value.
LiteralAvailabilityGroupOptionAvailability group option with a literal value.
LiteralBulkInsertOptionRepresents simple single option in BULK INSERT statement.
LiteralDatabaseOptionDatabase option with a literal value
LiteralEndpointProtocolOptionRepresents an option which has single string or integer value
LiteralOpenRowsetCosmosOptionRepresents simple single option in BULK INSERT (Provider='CosmosDB' ...) statement.
LiteralOptimizerHintRepresents optimizer hint, which can be represented as flag with optional literal value.
LiteralOptionValueRepresents the literal value of an option.
LiteralPayloadOptionRepresents payload option with a single literal value
LiteralPrincipalOptionLiteral option in CREATE/ALTER LOGIN/USER statement
LiteralRangeRepresents a single literal or a range of literals.
LiteralReplicaOptionRepresents a replica option with a literal value.
LiteralSessionOptionRepresents the MAX_MEMORY event session option
LiteralStatisticsOptionRepresents the statistics option.
LiteralTableHintRepresents table hint with literal value.
LocationOptionRepresents the LOCATION option for SQL DW Tables.
LockEscalationTableOptionLock escalation table option.
LoginTypePayloadOptionRepresents LOGIN_TYPE payload option
LowPriorityLockWaitAbortAfterWaitOptionRepresents the action of the low priority lock wait option.
LowPriorityLockWaitMaxDurationOptionRepresents the max duration of the low priority lock wait option.
LowPriorityLockWaitOptionRepresents the low priority lock wait option.
LowPriorityLockWaitTableSwitchOptionRepresents the low priority lock wait option for alter table switch statement.
MasterKeyStatementRepresents the master key statement.
MaxDispatchLatencySessionOptionRepresents the MAX_DISPATCH_LATENCY event session option
MaxDopConfigurationOptionMAXDOP option in ALTER DATABASE SCOPED CONFIGURATION statement
MaxDurationOptionRepresents the max duration option.
MaxLiteralRepresents the MAX literal.
MaxRolloverFilesAuditTargetOptionMAX_ROLLOVER_FILES audit target option.
MaxSizeAuditTargetOptionMaxSize option in case of FILE audit target.
MaxSizeDatabaseOptionMAXSIZE option in create and alter database for Azure.
MaxSizeFileDeclarationOptionThe file declaration value for MAXSIZE.
MemoryOptimizedTableOptionMEMORY_OPTIMIZED table option.
MemoryPartitionSessionOptionRepresents the MEMORY_PARTITION_MODE session option
MergeActionRepresents action in merge statement
MergeActionClauseThe condition and action to take for merge.
MergeSpecificationThe merge specification.
MergeStatementRepresents the MERGE statement.
MessageTypeStatementBaseRepresents common parts of CREATE and ALTER MESSAGE TYPE statements
MethodSpecifierRepresents the method specifier.
MirrorToClauseRepresents MIRROR TO clause BACKUP statement
MoneyLiteralRepresents a Money literal.
MoveConversationStatementRepresents MOVE CONVERSATION statement
MoveRestoreOptionRepresents MOVE restore option
MoveToDropIndexOptionRepresents the Move To option in DROP INDEX
MultiPartIdentifierRepresents a multi-part identifier.
MultiPartIdentifierCallTargetRepresents target of a call which is a column or CLR property on a column.
NamedTableReferenceThe table reference to a CTE or schema object.
NameFileDeclarationOptionThe file declaration option for NAME or NEWNAME.
NextValueForExpressionRepresents the NEXT VALUE FOR expression.
NullableConstraintDefinitionRepresents the nullable constraint.
NullIfExpressionRepresents the nullif expression.
NullLiteralRepresents a null literal.
NumericLiteralRepresents a Numeric literal.
OdbcConvertSpecificationRepresents the Odbc convert specification.
OdbcFunctionCallRepresents the ODBC function call.
OdbcLiteralRepresents an odbc formatted literal.
OdbcQualifiedJoinTableReferenceRepresents the odbc qualified join in a from clause.
OffsetClauseThis class represents an offset/fetch filter, that can be used in select statements for paging the result set.
OnFailureAuditOptionON_FAILURE option in CREATE/ALTER SERVER AUDIT statement.
OnlineIndexLowPriorityLockWaitOptionRepresents the low priority lock wait suboption for online index option.
OnlineIndexOptionRepresents the online option.
OnOffAssemblyOptionRepresents an on/off assembly option.
OnOffAtomicBlockOptionOption which be set to an OptionState in BEGIN ATOMIC…END statement
OnOffAuditTargetOptionRESERVE_DISK_SPACE option in case of FILE audit target.
OnOffDatabaseOptionOption which can be set to ON or OFF, in CREATE/ALTER DATABASE statement.
OnOffDialogOptionRepresents ON/OFF dialog options.
OnOffFullTextCatalogOptionRepresents ON/OFF fulltext catalog options.
OnOffOptionValueRepresents either an ON or OFF option value.
OnOffPrimaryConfigurationOptionOption which can be set to ON or OFF or PRIMARY.
OnOffPrincipalOptionSecurity option in CREATE or ALTER LOGIN or USER statement
OnOffRemoteServiceBindingOptionThe remote service binding option for ON/OFF options.
OnOffSessionOptionRepresents the TRACK_CAUSALITY and STARTUP_STATE event session option
OnOffStatisticsOptionRepresents new-style on-off options.
OpenCursorStatementOpen cursor statement
OpenJsonTableReferenceRepresents OPENJSON table reference
OpenMasterKeyStatementOpen master key statement.
OpenQueryTableReferenceRepresents OPENQUERY table reference.
OpenRowsetColumnDefinitionRepresent the column that a user would like to read from a file.
OpenRowsetCosmosRepresents OPENROWSET (PROVIDER = 'CosmosDB' ...) table reference.
OpenRowsetCosmosOptionRepresents single option in OPENROWSET (Provider='CosmosDb'...) statement
OpenRowsetTableReferenceRepresents OPENROWSET table reference.
OpenSymmetricKeyStatementOpen symmetric key statement.
OpenXmlTableReferenceRepresents OPENXML table reference
OperatorAuditOptionOPERATOR_AUDIT option in CREATE/ALTER SERVER AUDIT statement.
OptimizeForOptimizerHintRepresents OPTIMIZE FOR optimizer hint
OptimizerHintRepresents single optimizer hint
OptionValueRepresents an option value.
OrderBulkInsertOptionRepresents ORDER option in BULK INSERT statement.
OrderByClauseRepresents the order by clause that can be used in statements like select.
OrderIndexOptionRepresents the order option.
OutputClauseRepresents the output clause.
OutputIntoClauseRepresents the OutputInto Clause
OverClauseRepresents the over clause.
PageVerifyDatabaseOptionPAGE_VERIFY option in ALTER DATABASE statement, SET case
ParameterizationDatabaseOptionPARAMETERIZATION option in ALTER DATABASE statement, SET case
ParameterizedDataTypeReferenceThe data type abstract class that can have parameters.
ParameterlessCallRepresents calls without the parenthesis and parameters.
ParenthesisExpressionRepresents an expression enclosed in parentheses.
ParseCallRepresents the parse function call.
ParseErrorThis class reports the error that occured during parsing.
PartitionFunctionCallRepresents the partition function call.
PartitionParameterTypeParameter type in CREATE PARTITION FUNCTION statement
PartitionSpecificationsRepresents the specifications for a table partition.
PartitionSpecifierRepresents a partition specifier as expression or ALL.
PartnerDatabaseOptionPARTNER option in ALTER DATABASE statement, SET case
PasswordAlterPrincipalOptionPASSWORD option in ALTER LOGIN statement
PasswordCreateLoginSourcePassword case in CREATE LOGIN statement
PayloadOptionRepresents a single payload option in CREATE / ALTER ENDPOINT statement
PermissionRepresents the permission that can be used in security statement body.
PermissionSetAssemblyOptionRepresents the PERMISSION_SET assembly option.
PivotedTableReferenceRepresents the pivoted table reference in a from clause.
PortsEndpointProtocolOptionRepresents PORTS HTTP endpoint protocol option
PredicateSetStatementRepresents the various Set {...} { ON | OFF } options in the TSQL grammar.
PredictTableReferenceRepresents PREDICT table reference
PrimaryExpressionRepresents the abstract base class for primary expressions.
PrimaryRoleReplicaOptionRepresents the replica option for primary role.
PrincipalOptionSingle option in CREATE or ALTER LOGIN or USER statement
PrintStatementRepresents the print statement.
Privilege80Represents a privilage that can be used in a security statement.
PrivilegeSecurityElement80Represents the security element that has priviliges.
ProcedureOptionRepresents a Procedure Option
ProcedureParameterThis class represents a parameter that can be passed into a procedure.
ProcedureReferenceReference to procedure by name and number
ProcedureReferenceNameRepresents a procedure by name, either as a ProcedureReference or contained within a variable.
ProcedureStatementBodyRepresents CREATE/ALTER PROCEDURE statement.
ProcedureStatementBodyBaseRepresents common propeties in CREATE/ALTER PROC/FUNCTION statements
ProcessAffinityRangeRepresents a single process affinity range in ALTER SERVER CONFIGURATION statement.
ProviderEncryptionSourceRepresents reference to a EKM provider.
ProviderKeyNameKeyOptionRepresents PROVIDER_KEY_NAME option.
QualifiedJoinRepresents the qualified join in a from clause.
QueryDerivedTableThis node represents a derived table.
QueryExpressionThis class is an abstract base class for the query expression hierarchy in select statement.
QueryParenthesisExpressionThis class represents the parenthesis expression that wraps a QueryExpression.
QuerySpecificationThis class represents the major part of the select statement.
QueryStoreCapturePolicyOptionCapture Policy part of QueryStore Options
QueryStoreDatabaseOptionQuery Store (QDS) option in ALTER DATABASE statement, SET case
QueryStoreDataFlushIntervalOptionData Flush Interval part of QueryStore Options
QueryStoreDesiredStateOptionDesired State part of QueryStore Options
QueryStoreIntervalLengthOptionRuntime Stats Interval length part of QueryStore Options
QueryStoreMaxPlansPerQueryOptionMax Plans Per Query part of QueryStore Options
QueryStoreMaxStorageSizeOptionMax Storage Size part of QueryStore Options
QueryStoreOptionA single query store option.
QueryStoreSizeCleanupPolicyOptionSize Based Cleanup Policy part of QueryStore Options
QueryStoreTimeCleanupPolicyOptionTime based Cleanup Policy part of QueryStore Options
QueueDelayAuditOptionQUEUE_DELAY option in CREATE/ALTER SERVER AUDIT statement.
QueueExecuteAsOptionThe queue option for execute as.
QueueOptionRepresents the queue option.
QueueProcedureOptionThe queue option for procedure.
QueueStatementRepresents the base for queue statements.
QueueStateOptionRepresents the base for queue option that has a state.
QueueValueOptionThe queue option with a value.
RaiseErrorLegacyStatementRepresents the legacy style raiserror statement.
RaiseErrorStatementRepresents the raiserror statement.
ReadOnlyForClauseRepresents FOR READ ONLY case used only in DECLARE CURSOR
ReadTextStatementRepresents the readtext statement.
RealLiteralRepresents a Real literal.
ReceiveStatementRepresents RECEIVE statement
ReconfigureStatementRepresents the reconfigure statement.
RecoveryDatabaseOptionRECOVERY option in ALTER DATABASE statement, SET case
RemoteDataArchiveAlterTableOptionREMOTE_DATA_ARCHIVE table option for alter.
RemoteDataArchiveDatabaseOptionREMOTE_DATA_ARCHIVE create / alter database options.
RemoteDataArchiveDatabaseSettingREMOTE_DATA_ARCHIVE DB-level settings
RemoteDataArchiveDbCredentialSettingCREDENTIAL setting for REMOTE_DATA_ARCHIVE
RemoteDataArchiveDbFederatedServiceAccountSettingFEDERATED_SERVICE_ACCOUNT setting for REMOTE_DATA_ARCHIVE
RemoteDataArchiveDbServerSettingSERVER setting for REMOTE_DATA_ARCHIVE
RemoteDataArchiveTableOptionREMOTE_DATA_ARCHIVE table option for create and alter.
RemoteServiceBindingOptionA remote service binding option.
RemoteServiceBindingStatementBaseRepresents common base for CREATE and ALTER REMOTE SERVICE BINDING statements
RenameAlterRoleActionRepresents the rename alter role action.
RenameEntityStatementRepresents a Rename TABLE statement
ResampleStatisticsOptionRepresents the resample statistics option that supports specifying a list of partition ranges on which to resample.
ResourcePoolAffinitySpecificationRepresents the resource pool statement affinity specification.
ResourcePoolParameterRepresents the resource pool statement parameters.
ResourcePoolStatementRepresents Create and Alter Resource Pool Statement.
RestoreMasterKeyStatementRepresents RESTORE MASTER KEY statement
RestoreOptionRepresents a single option in RESTORE statement
RestoreServiceMasterKeyStatementRepresents RESTORE SERVICE MASTER KEY statement
RestoreStatementRepresents RESTORE/LOAD statement
ResultColumnDefinitionRepresents the column definition of a result set
ResultSetDefinitionThe definition of an individual result set
ResultSetsExecuteOptionThe results set description for EXECUTE statements
RetentionDaysAuditTargetOptionRetentionDays option in case of URL audit target.
RetentionPeriodDefinitionDefinition of retention period for system versioned temporal table and data retention table option.
ReturnStatementRepresents return statement
RevertStatementRepresents REVERT statement
RevokeStatementRepresents the revoke statement.
RevokeStatement80Represents the revoke statement.
RightFunctionCallRepresents RIGHT call.
RolePayloadOptionRepresents ROLE payload option
RoleStatementRepresents the role statement base.
RollbackTransactionStatementRepresents the rollback transaction statement.
RollupGroupingSpecificationRepresents ROLLUP grouping specification.
RouteOptionRepresents the for route option.
RouteStatementRepresents the base for route statements.
RowValueRepresents data for a single row.
SaveTransactionStatementRepresents the save transaction statement.
ScalarExpressionThe abstract base class that represents scalar expressions.
ScalarExpressionDialogOptionRepresents scalar expression dialog options.
ScalarExpressionRestoreOptionRepresents single option with optional value
ScalarExpressionSequenceOptionRepresents sequence option with a scalar expression.
ScalarExpressionSnippetPlaceholder for an arbitrary scalar expression.
ScalarFunctionReturnTypeThe return type definition for scalar-valued functions
ScalarSubqueryRepresents the subquery.
SchemaDeclarationItemRepresents information about one column in schema declaration.
SchemaDeclarationItemOpenjsonRepresents information about one result column in Openjson.
SchemaObjectFunctionTableReferenceA table reference to a table-valued function
SchemaObjectNameRepresents a schema object name.
SchemaObjectNameOrValueExpressionRepresents either a SchemaObjectName or ValueExpression
SchemaObjectNameSnippetPlaceholder for an arbitrary schema object name.
SchemaObjectResultSetDefinitionRepresents the result set as a reference to an existing schema object or type
SchemaPayloadOptionRepresents SCHEMA payload option
SearchedCaseExpressionRepresents a searched case expression.
SearchedWhenClauseRepresents the when clause that is used in a searched case expression.
SearchPropertyListActionBase class for search property list actions.
SearchPropertyListFullTextIndexOptionRepresents the search property list option in FULLTEXT INDEX statement.
SecondaryRoleReplicaOptionRepresents the replica option for secondary role.
SecurityElement80Represents the security statement body that is common for Grant Deny and Revoke Statements.
SecurityPolicyOptionRepresents an option in a CREATE/ALTER SECURITY POLICY statement
SecurityPolicyStatementBase class for all Security Policy statement objects
SecurityPredicateActionRepresents a security predicate add alter or drop action.
SecurityPrincipalRepresents the principal that can be used in security statement body.
SecurityStatementRepresents the security statement body base class.
SecurityStatementBody80Represents the security statement body base class.
SecurityTargetObjectRepresents the target object that can be used in security statement body.
SecurityTargetObjectNameRepresents the security target object name.
SecurityUserClause80Represents the security statement body that is common for Grant Deny and Revoke Statements.
SelectElementRepresents an element in the SELECT clause.
SelectFunctionReturnTypeThe return type definition for inline table-valued functions
SelectInsertSourceRepresents the insert source for SELECT.
SelectiveXmlIndexPromotedPathRepresents xml path specified in CreateSelectiveXmlIndex statement
SelectScalarExpressionThe column element that is used right after the select keyword.
SelectSetVariableThis class represents the setting a variable inside a select statement.
SelectStarExpressionThis represents a select * expression
SelectStatementRepresents a SELECT statement.
SelectStatementSnippetPlaceholder for an arbitrary select statement.
SemanticTableReferenceRepresents SEMANTICKEYPHRASETABLE, SEMANTICSIMILARITYTABLE and SEMANTICSIMILARITYDETAILSTABLE table references.
SendStatementRepresents SEND statement
SensitivityClassificationUtility class to expose sensitivity classification enums and methods
SensitivityClassificationOptionSingle option in ADD SENSITIVITY CLASSIFICATION statement.
SensitivityClassificationStatementRepresents the base sensitivity classification statement.
SequenceOptionRepresents a sequence option.
SequenceStatementBase class for all sequence statement objects
ServerAuditStatementCommon base for CREATE and ALTER SERVER audit statements.
ServiceContractRepresents service contract reference (with optional action)
SessionOptionRepresents the event session option
SessionTimeoutPayloadOptionRepresents SESSION_TIMEOUT payload option
SetClauseThe base class for SET clause.
SetCommandRepresents single command in a SET statement (e.g. set !language us_english!)
SetCommandStatementRepresents SET command statement (e.g. SET language us_english)
SetErrorLevelStatementRepresents SET ERRLVL statement
SetFipsFlaggerCommandRepresents SET FIPS_FLAGGER command
SetIdentityInsertStatementRepresents SET IDENTITY_INSERT statement
SetOffsetsStatementRepresents SET OFFSETS statement
SetOnOffStatementRepresents Set statement ending if { ON | OFF }
SetRowCountStatementRepresents SET ROWCOUNT statement
SetSearchPropertyListAlterFullTextIndexActionRepresents SEARCH PROPERTY LIST action for ALTER FULLTEXT INDEX statement
SetStatisticsStatementRepresents Set Statistics {...} { ON | OFF } options in the TSQL grammar.
SetStopListAlterFullTextIndexActionRepresents STOPLIST action for ALTER FULLTEXT INDEX statement.
SetTextSizeStatementRepresents SET TEXTSIZE statement
SetTransactionIsolationLevelStatementRepresents SET TRANSACTION ISOLATION LEVEL statement (?) Snapshot (?)
SetUserStatementRepresents the setuser statement.
SetVariableStatementRepresents the set @local_variable statement
ShutdownStatementRepresents the shutdown statement.
SignatureStatementBaseRepresents common base for ADD and DROP SIGNATURE statements.
SimpleAlterFullTextIndexActionRepresents flag action for ALTER FULLTEXT INDEX statement.
SimpleCaseExpressionRepresents a simple case expression.
SimpleWhenClauseRepresents the when clause that is used in a simple case expression.
SingleValueTypeCopyOptionRepresents literals for COPY options
SizeFileDeclarationOptionThe file declaration option for SIZE.
SoapMethodRepresents SOAP method in payload part of CREATE ENDPOINT statement
SourceDeclarationRepresents event source declaration name.
SpatialIndexOptionRepresents the spatial index option.
SpatialIndexRegularOptionSpecifies the spatial index regular options.
Sql100ScriptGeneratorScript generator for T-SQL 100
Sql110ScriptGeneratorScript generator for T-SQL 110
Sql120ScriptGeneratorScript generator for T-SQL 120
Sql130ScriptGeneratorScript generator for T-SQL 130
Sql140ScriptGeneratorScript generator for T-SQL 140
Sql150ScriptGeneratorScript generator for T-SQL 150
Sql160ScriptGeneratorScript generator for T-SQL 160
Sql80ScriptGeneratorScript generator for T-SQL 80
Sql90ScriptGeneratorScript generator for T-SQL 90
SqlCommandIdentifierRepresents the SqlCommandIdentifier.
SqlDataTypeReferenceRepresents built-in data types
SqlScriptGeneratorSql specific script generator.
SqlScriptGeneratorOptionsControls the options for Sql Script Generation
SqlServerlessScriptGeneratorScript generator for Serverless SQL Pools
StateAuditOptionSTATE option in ALTER SERVER AUDIT statement.
StatementListRepresents a list of statements.
StatementListSnippetPlaceholder for an arbitrary statement list.
StatementWithCtesAndXmlNamespacesThis class represents a statement that can begin with a common table expression or xml namespaces.
StatisticsOptionRepresents the statistics option.
StatisticsPartitionRangeRepresents a single partition range, with constant expressions
StopListFullTextIndexOptionRepresents STOPLIST option in FULLTEXT INDEX statement.
StopRestoreOptionRepresents StopAtMark/StopBeforeMark restore options
StringLiteralRepresents a string literal.
SubqueryComparisonPredicateRepresents the comparison predicates that have subqueries.
SymmetricKeyStatementRepresents common properties for ALTER and CREATE SYMMETRIC KEY statements
SystemTimePeriodDefinitionPeriod for temporal system time.
SystemVersioningTableOptionSYSTEM_VERSIONING table option.
TableClusteredIndexTypeRepresentation of the Clustered Index type for a table index.
TableDataCompressionOptionThe table option for DATA_COMPRESSION.
TableDefinitionThis class stores the common body for defining a table
TableDistributionOptionRepresents the table DISTRIBUTION option for SQL DW tables.
TableDistributionPolicyBase class for table distribution policies.
TableHashDistributionPolicyRepresentation of the HASH option for an table distribution policy.
TableHintRepresents single table hint.
TableHintsOptimizerHintRepresents optimizer hint containing table hint.
TableIndexOptionRepresents the table INDEX option for SQL DW tables.
TableIndexTypeBase class for table index types.
TableNonClusteredIndexTypeRepresentation of the Non-Clustered Index type or HEAP for a table index.
TableOptionA single table option.
TablePartitionOptionRepresents the table PARTITION option for SQL DW tables.
TablePartitionOptionSpecificationsFor specifying range and values in the partition table option in the CREATE TABLE statement.
TableReferenceThis is an abstract base class that represents table reference.
TableReferenceWithAliasThis represents a table reference that can have an alias.
TableReferenceWithAliasAndColumnsRepresents a table reference that can specify column aliases.
TableReplicateDistributionPolicyRepresentation of the REPLICATE option for an table distribution policy.
TableRoundRobinDistributionPolicyRepresentation of the ROUND_ROBIN option for an table distribution policy.
TableSampleClauseRepresents the TABLESAMPLE clause.
TableSwitchOptionRepresents the alter table switch option.
TableValuedFunctionReturnTypeThe return type definition for multi-statement table-valued functions
TableXmlCompressionOptionThe table option for XMLCOMPRESSION.
TargetDeclarationRepresents the target declaration
TargetRecoveryTimeDatabaseOptionTARGET_RECOVERY_TIME option in ALTER DATABASE statement, SET case
TemporalClauseBase class for all temporal clauses.
TextModificationStatementRepresents the writetext statement.
ThrowStatementRepresents the THROW statement
TopRowFilterThis class represents the top row filter, that can be used in select statement.
TransactionStatementThe abstract base class for transaction statements.
TriggerActionRepresents the trigger action.
TriggerObjectInformation on what trigger is being created/altered
TriggerOptionRepresents the trigger option.
TriggerStatementBodyRepresents CREATE/ALTER TRIGGER statement.
TruncateTableStatementRepresents the truncate table statement.
TruncateTargetTableSwitchOptionRepresents the truncate target table option for alter table switch statement.
TryCastCallRepresents the try_cast call.
TryCatchStatementDefines the try catch statement.
TryConvertCallRepresents the try_convert function call.
TryParseCallRepresents the try_parse function call.
TSEqualCallRepresents the tsequal function call which is a boolean function.
TSql100ParserThe TSql Parser for 10.0.
TSql110ParserThe TSql Parser for 11.0.
TSql120ParserThe TSql Parser for 12.0.
TSql130ParserThe TSql Parser for 13.0.
TSql140ParserThe TSql Parser for 14.0.
TSql150ParserThe TSql Parser for 15.0.
TSql160ParserThe TSql Parser for 16.0.
TSql80ParserThe TSql Parser for 8.0.
TSql90ParserThe TSql Parser for 9.0.
TSqlAuditEventGroupHelperExposes the audit event groups.
TSqlAuditEventTypeHelperExposes the audit event types.
TSqlBatchRepresents a batch in T-SQL script.
TSqlConcreteFragmentVisitorThe base visitor for the concrete TSql fragments
TSqlFragmentThis class is a real internal class to parser, therefore it is not in the spec tree.
TSqlFragmentSnippetPlaceholder for an arbitrary TSqlFragment.
TSqlFragmentVisitorThe base visitor for the TSql script dom.
TSqlParserThe abstract base class for TSql Parsers.
TSqlParserTokenRepresents a single Token in the input text.
TSqlScriptRepresents a TSql sript.
TSqlStatementRepresents a single T-SQL statement.
TSqlStatementSnippetPlaceholder for an arbitrary statement.
TSqlTriggerEventGroupHelperExposes the trigger event groups.
TSqlTriggerEventTypeHelperExposes the trigger event types.
UnaryExpressionAn expression that has a single expression as child.
UniqueConstraintDefinitionRepresents 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.
UnpivotedTableReferenceRepresents the unpivoted table reference in a from clause.
UnqualifiedJoinRepresents the unqualified join in a from clause.
UpdateCallRepresents the update function call which is a boolean function for use in triggers.
UpdateDeleteSpecificationBaseBase class for Update and Delete Specs
UpdateForClauseRepresents FOR UPDATE [columns] case used only in DECLARE CURSOR
UpdateMergeActionRepresents update merge action
UpdateSpecificationThe properties for Update
UpdateStatementRepresents the update statement.
UpdateStatisticsStatementRepresents the update statistics statement.
UpdateTextStatementRepresents the updatetext statement.
UseFederationStatementRepresents the USE FEDERATION statement
UseHintListRepresents optimizer hints in a USE HINT clause.
UserDataTypeReferenceRepresents user-defined data types
UserDefinedTypeCallTargetRepresents target of a call which is a column or CLR property on a column.
UserDefinedTypePropertyAccessThis class represents a property on a Udt.
UserLoginOptionRepresents the user login option.
UserRemoteServiceBindingOptionThe remote service binding option for USER.
UserStatementRepresents the user statement base.
UseStatementRepresents the use statement.
ValueExpressionBase class for literals, variables, and global variables.
ValuesInsertSourceRepresents the insert source for VALUES.
VariableMethodCallTableReferenceRepresents a table reference that is a method call on a variable reference
VariableReferenceRepresents a reference to a variable
VariableTableReferenceThis class represents a table reference which is a variable.
VariableValuePairRepresents single variable-value pair in OPTIMIZE FOR optimizer hint
ViewDistributionOptionRepresents the view DISTRIBUTION option for SQL DW materialized views.
ViewDistributionPolicyBase class for materialized view distribution policies.
ViewForAppendOptionRepresents the view FOR_APPEND option for SQL DW materialized views.
ViewHashDistributionPolicyRepresentation of the HASH option for a materialized view distribution policy.
ViewOptionRepresents the View option.
ViewRoundRobinDistributionPolicyRepresentation of the ROUND_ROBIN option for a materialized view distribution policy.
ViewStatementBodyBase class for CREATE/ALTER VIEW statement.
WaitAtLowPriorityOptionRepresents the low priority lock wait option for alter table switch statement.
WaitForStatementRepresents the waitfor statement.
WaitForSupportedStatementBase class for statements inside WAITFOR statement
WhenClauseAbstract class for case expression when clauses
WhereClauseRepresents the where clause that can be used in statements like select, update.
WhileStatementRepresents the while statement.
WindowClauseRepresents the window clause.
WindowDefinitionDefinition of a named window.
WindowDelimiterRepresents specification of a window boundary.
WindowFrameClauseRepresents the specification of window bounds for windowing aggregates.
WindowsCreateLoginSourceWindows case in CREATE LOGIN statement
WithCtesAndXmlNamespacesThis class represents a common construct that can have common table expressions and xml namespaces in it.
WithinGroupClauseRepresents the within group clause.
WitnessDatabaseOptionWITNESS option in ALTER DATABASE statement, SET case
WlmTimeLiteralRepresents a Literal of time type used in Workload Management.
WorkloadClassifierOptionA single workload classifier option.
WorkloadClassifierStatementRepresents Create Workload Classifier statement
WorkloadGroupImportanceParameterRepresents the workload group importance parameter.
WorkloadGroupParameterRepresents the workload group statement parameters.
WorkloadGroupResourceParameterRepresents the workload group statement parameters.
WorkloadGroupStatementRepresents Create and Alter Workload Group Statement.
WriteTextStatementRepresents the writetext statement.
WsdlPayloadOptionRepresents WSDL payload option
XmlCompressionOptionRepresents a single xml compression option.
XmlDataTypeReferenceRepresents xml data types
XmlForClauseRepresents FOR XML (options) case
XmlForClauseOptionRepresents FOR XML (options) case
XmlNamespacesThis class represents XmlNameSpaces
XmlNamespacesAliasElementThe alias variation for the xml namespace element.
XmlNamespacesDefaultElementThe default variation for the xml namespace element.
XmlNamespacesElementThe element that is used in defining xml namespace.
AbortAfterWaitTypeThe action to be taken after low priority wait times out.
AffinityKindThe types of endpoint affinity
AllowConnectionsOptionKindThe allow read options.
AlterActionThe types of alter action
AlterAvailabilityGroupActionTypeThe types alter availability group actions
AlterAvailabilityGroupStatementTypeThe types of alter availability group statements.
AlterCertificateStatementKindThe types of Alter Certificate
AlterEventSessionStatementTypeThe types of alter event session statement
AlterFederationKindThe types of alter federation statement
AlterFullTextCatalogActionThe types of alter fulltext catalog action
AlterIndexTypeThe possible alter index types.
AlterMasterKeyOptionThe types of alter master key options
AlterResourceGovernorCommandTypeThe types of alter resource governor command
AlterServerConfigurationBufferPoolExtensionOptionKindThe types of buffer pool extension options.
AlterServerConfigurationDiagnosticsLogOptionKindThe types of diagnostics log options.
AlterServerConfigurationExternalAuthenticationOptionKindThe types of external authentication options.
AlterServerConfigurationFailoverClusterPropertyOptionKindThe types of failover cluster properties.
AlterServerConfigurationHadrClusterOptionKindThe types of HADR cluster properties.
AlterServerConfigurationSoftNumaOptionKindThe types of softnuma options.
AlterServiceMasterKeyOptionThe types of alter service master key option
AlterTableAlterColumnOptionThe options for alter column version of alter table statement. AddRowguidcol, DropRowguidcol can only happen if there is no DataType.
ApplicationRoleOptionKindThe possible application role options.
AssemblyOptionKindThe possible Assembly Options.
AssignmentKindThe types of assignment
AtomicBlockOptionKindOptions specified in the ATOMIC block statement
AttachModeThe types of attach mode
AuditActionGroupThe types of audit action group
AuditFailureActionTypeThe action to take on audit failure.
AuditOptionKind AuditTargetKindThe possible audit target kinds
AuditTargetOptionKind AuthenticationProtocolThe types of authentication protocols
AuthenticationTypesPossible authentication types
AutomaticTuningOptionKindThe possible Automatic Tuning Options under 'ALTER DATABASE d1 SET AUTOMATIC_TUNING = (...)'
AutomaticTuningOptionStateThe possible Automatic Tuning Options under 'ALTER DATABASE d1 SET AUTOMATIC_TUNING = (OPTION = ...)'
AutomaticTuningStateState of Automatic Tuning option
AvailabilityGroupOptionKindThe types of availability group options
AvailabilityModeOptionKindThe availability mode options.
AvailabilityReplicaOptionKindThe possible Availability Replica Options.
BackupOptionKindThe types of backup options
BackupRestoreItemKindThe types of backup restore item options
BinaryExpressionTypeThe types of scalar expressions that have two expressions as children.
BinaryQueryExpressionTypeThe types of query expressions that have two query expressions as children.
BooleanBinaryExpressionTypeThe types of boolean expressions that have two expressions as children.
BooleanComparisonTypeThe types of comparison expressions
BooleanTernaryExpressionTypeThe types of expressions that have three expressions as children.
BoundingBoxParameterTypeThe types of bounding box paramter
BrokerPriorityParameterSpecialTypeThe types of broker priority parameters
BrokerPriorityParameterTypeThe types of broker priority parameters
BulkInsertOptionKindIf this enum grows beyond 63, Parser needs to be updated - it uses Int64 to check for option duplication
CatalogCollationValues for the CATALOG_COLLATION database option
CertificateOptionKindsThe types of certificate options
ChangeTrackingOptionThe possible change tracking options.
ColumnEncryptionDefinitionParameterKindParameter types for column encryption definition
ColumnEncryptionKeyAlterTypeColumn encryption key alter statement types
ColumnEncryptionKeyValueParameterKindColumn encryption key value parameters
ColumnEncryptionTypeTypes of encryption supported on a column.
ColumnMasterKeyParameterKindParameter types for column master key definition
ColumnTypeColumn Types, used for class Column.
CommandOptionsCommands that can be used in security statements.
CompressionDelayTimeUnitPossible values for units in COMPRESSION_DELAY clause.
ComputeFunctionTypeThe possible types for compute function of compute clause.
ConstraintEnforcementDefines how constraints can be enforced.
ContainmentOptionKindThe possible containment settings.
CopyCommandCompressionTypeCompression type supported by copy command.
CopyCommandCredentialTypeCredential identity supported by COPY statement.
CopyCommandDateFormatDateformat supported for copy command.
CopyCommandEncodingEncoding supported for copy command.
CopyCommandFileFormatTypeThe supported file types for copy command.
CopyCommandIdentityInsertIdentity insert supported by copy command.
CopyOptionKindIf this enum grows beyond 31, Parser needs to be updated - it uses Int32 to check for option duplication
CryptoMechanismTypeThe types of crypto mechanism
CursorOptionKindDifferent cursor options
DatabaseAuditActionKindThe types of database audit action
DatabaseConfigClearOptionKindThe types of database options that can be cleared
DatabaseConfigSetOptionKindThe types of database configuration options that can be set
DatabaseConfigurationOptionStateState of some database configuration options
DatabaseEncryptionKeyAlgorithmPossible algorithms for database encryption key.
DatabaseMirroringEndpointRoleThe types of database mirroring endpoint role
DatabaseOptionKindThe types of database options
DataCompressionLevelThe possible values for data compression level
DbccCommandThe possible values for dbcc commands
DbccOptionKindThe types of dbcc options
DelayedDurabilityOptionKindThe possible delayed durability settings.
DeleteUpdateActionShows the action that will be taken on delete or update.
DeviceTypeThe types of devices
DialogOptionKind DiskStatementOptionKindDifferent disk statement options
DiskStatementTypeThe disk statement type.
DropClusteredConstraintOptionKindDrop clustered constraint option types.
DropSchemaBehaviorDROP SCHEMA behavior (in case of SQL 2000)
DurabilityTableOptionKindThe table durability kinds
EnableDisableOptionTypeThe types of enable disable options
EncryptionAlgorithmPossible algorithms for encryption
EncryptionAlgorithmPreferencePossible values for encryption algorithm preference.
EndpointEncryptionSupportThe types of endpoint encryption support
EndpointProtocolThe types of endpoint protocol
EndpointProtocolOptionsThe possible endpoint protocol options
EndpointStateThe types of endpoint state
EndpointTypeThe types of endpoint
EventNotificationEventGroupThe types of event group
EventNotificationEventTypePossible event types
EventNotificationTargetThe possible event notification targets.
EventSessionEventRetentionModeTypeThe types of event retention modes
EventSessionMemoryPartitionModeTypeThe types of memory partition mode
EventSessionScopeThe allowed scopes of event sessions
ExecuteAsOptionThe execute as options.
ExecuteOptionKind ExternalDataSourceOptionKindThe external data source options.
ExternalDataSourcePushdownOptionThe enumeration specifies the external data source type for external tables Currently, we support HADOOP, RDBMS, and SHARD_MAP_MANAGER.
ExternalDataSourceTypeThe 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.
ExternalFileFormatOptionKindThe external file format options.
ExternalFileFormatTypeThe enumeration specifies the external file format types DELIMITEDTEXT, RCFILE, ORC, PARQUET.
ExternalFileFormatUseDefaultTypeThe enumeration specifies the external file format use default type option FALSE (default) or TRUE.
ExternalResourcePoolAffinityTypeThe types of paramters used in a CREATE/ALTER EXTERNAL RESOURCE POOL statement
ExternalResourcePoolParameterTypeThe types of parameters used in a CREATE/ALTER EXTERNAL RESOURCE POOL statement
ExternalStreamOptionKindExternal Stream options
ExternalTableOptionKindThe external table options.
ExternalTableRejectTypeThe enumeration specifies the external table reject types VALUE (default) or PERCENTAGE.
FailoverActionOptionKindThe types of failover action options.
FailoverModeOptionKindThe failover mode options.
FetchOrientationPossible values for fetch orientation
FileDeclarationOptionKindThe possible File Declaration Options
FileFormatTypeThe supported external file formats.
FipsComplianceLevelFips 127-2 compliance level
FullTextCatalogOptionKind FullTextFunctionTypeThe fulltext function types.
FullTextIndexOptionKindThe possible FullText Index Options
FunctionOptionKindPossible values for function options
GeneralSetCommandTypeTypes of set commands with parameter
GeneratedAlwaysTypePossible values for 'GENERATED ALWAYS' clause
GraphMatchRecursivePredicateKindRecursive predicate kind for graph match expression.
GridParameterTypeThe types of grid parameters
GroupByOptionThe options that group by clause might have.
HadrDatabaseOptionKindThe types of Hadr database options
ImportanceParameterTypeThe possible values for importance parameter in CREATE/ALTER WORKLOAD GROUP and CREATE SPATIAL INDEX statements
IndexOptionKindThe possible index options.
IndexTypeKindThe possible index types.
InsertOptionThe type of insert options
IsolationLevelIsolation levels for SET TRANSACTION ISOLATION LEVEL command
JoinHintThe types of join hints.
JsonForClauseOptionsEnum to store different JSON for clause options
KeyOptionKind KeywordCasingRepresents the possible ways of casing SQL keywords
LiteralTypeThe literal types.
LockEscalationMethodThe types of lock escalation methods
LowPriorityLockWaitOptionKindThe possible low priority lock wait options.
MemoryUnitMemory units for file declaration options in CREATE DATABASE statement
MergeConditionThe possible values for merge condition
MessageSenderThe types of message senders
MessageValidationMethodThe types of message validation methods
MigrationStateThe types of migration state
ModifyFileGroupOptionThe possible values for modify filegroup options
NonTransactedFileStreamAccessThe possible non transacted filestream access values.
NullNotNullRepresents optional NULL/NOT NULL contraint in column definition in INSERT BULK statement
OdbcLiteralTypeRepresents the Odbc Literal Types
OpenRowsetCosmosOptionKindAvailable options for OPENROWSET (Provider =' CosmosDB' ....) statement. This syntax is specific to Serverless SQL pools
OptimizerHintKindOptimizer hints
OptionStateState of some option
PageVerifyDatabaseOptionKindThe types of page verify alter database options
ParameterlessCallTypeSpecifies the type of the parameterless call.
ParameterModifierThe types of parameter modifier
ParameterStyleParameter style for external function bodies
PartitionFunctionRangeThe possible values for partition function range
PartitionTableOptionRangeThe possible values for partition table option range
PartnerDatabaseOptionKindThe types of partner alter database options
PayloadOptionKindsThe types of payload options
PermissionSetOptionThe permission set options.
PortTypesThe possible values for port types
PredictRunTimeOptionsThe Predict runtime options.
PrincipalOptionKindThe types of login options
PrincipalTypeThe principal types that can be used in security statements.
PrivilegeType80The privilege types that can be used in security statements.
ProcedureOptionKindThe types of procedure options
ProcessAffinityTypeThe type of process affinity in ALTER SERVER CONFIGURATION statement
QualifiedJoinTypeThe types of qualified joins.
QueryStoreCapturePolicyOptionKindThe possible Query Store Capture Policy Modes
QueryStoreDesiredStateOptionKindThe possible Query Store Desired State Options
QueryStoreOptionKindThe possible Query Store Options under 'ALTER DATABASE d1 SET QUERY_STORE = (...)'
QueryStoreSizeCleanupPolicyOptionKindThe possible Size based Cleanup Policy Modes
QueueOptionKindThe possible queue options.
QuoteTypeThe possible quote type.
RaiseErrorOptionsRaiseError options.
RdaTableOptionThe types of RDA table option
RecoveryDatabaseOptionKindThe types of recovery alter database options
RemoteDataArchiveDatabaseSettingKindThe possible settings under 'ALTER DATABASE d1 SET REMOTE_DATA_ARCHIVE = (...)'
RemoteServiceBindingOptionKind ResourcePoolAffinityTypeThe types of paramters used in a CREATE/ALTER RESOURCE POOL statement
ResourcePoolParameterTypeThe types of paramters used in a CREATE/ALTER RESOURCE POOL statement
RestoreOptionKindThe types of restore options
RestoreStatementKindThe types of restore statements
ResultSetsOptionKindIndicates whether the Result Sets are defined on Execute Statements
ResultSetTypeIndicates the mechanism used for defining the Result Set.
RouteOptionKindThe possible route options.
SecondaryXmlIndexTypeThe secondary xml index types.
SecurityObjectKindThe types of security objects
SecurityPolicyActionTypeThe types of security policy statement actions
SecurityPolicyOptionKindThe security policy options.
SecurityPredicateActionTypeThe types of security predicate options
SecurityPredicateOperationThe types of security predicate operations
SecurityPredicateTypeThe types of security predicates
SemanticFunctionTypeThe semantic function types.
SensitivityClassification.OptionTypeSensitivity classification option type used in AddSensitivityClassificationStatement
SensitivityClassification.RankSensitivity classification rank values
SeparatorTypeThe possible separator types.
SequenceOptionKindThe types of Sequence options
ServiceBrokerOptionPossible service broker options for CREATE DATABASE statement
SessionOptionKind SetOffsetsThe various types of keywords used in SET OFFSETS statement.
SetOptionsThe various types of predicate SET options found in SQL.
SetStatisticsOptionsThe various types of predicate SET STATISTICS options found in SQL.
SignableElementKindThe types of signable elements
SimpleAlterFullTextIndexActionKindThe types of alter fulltext index actions
SoapMethodActionThe types of soap method actions
SoapMethodFormatThe possible soap method formats
SoapMethodSchemasThe types of soap method schema
SortOrderThis enum is the possibilities for a sort order.
SparseColumnOptionThe possible values for sparse column options
SpatialIndexingSchemeTypeThe types of spatial indexing scheme
SqlDataTypeOptionThese are the possible data types in Sql. The capitalization of names are influenced by System.Data.SqlDbType.
SqlEngineTypeThis enum lists the engine type of SQL Server
SqlVersionThis enum lists the versions for Sql.
StatisticsOptionKindThe possible Statistics options.
SubqueryComparisonPredicateTypeThe types of comparison predicates that involve a subquery.
TableElementTypeTable element type.
TableHintKindThe table hints.
TableOptionKindThe possible Table Options
TableSampleClauseOptionThe table sample clause options.
TableSwitchOptionKindThe possible options for alter table switch statement.
TemporalClauseTypePossible values for temporal clause in 'FROM' part of a query.
TemporalRetentionPeriodUnitPossible values for units in HISTORY_RETENTION_PERIOD clause.
TimeUnitThe types of time units used in various statements. More time units can be added as necessary.
TriggerActionTypeSpecify which data modification statements, when attempted against this table or view, activate the trigger.
TriggerEnforcementOptions on enforcement of trigger execution.
TriggerOptionKindThe possible Trigger options.
TriggerScopeThis enum list possible trigger scopes
TriggerTypeSpecifies the type of the trigger.
TSqlTokenType UnaryExpressionTypeThe types of scalar expressions that have a single expression as a child.
UniqueRowFilterUsed in Select statement.
UnqualifiedJoinTypeThe possible index options.
UserLoginOptionTypeThe possible user login options.
UserType80The privilege types that can be used in security statements.
ViewOptionKindThe possible View options.
WaitForOptionThe possible waitfor options.
WindowDelimiterTypeType of a window boundary
WindowFrameTypeType of the window frame. Specifies whether ROWS or RANGE units are used.
WorkloadClassifierOptionTypeThe workload classifier options.
WorkloadGroupParameterTypeThe types of workload resource paramters
XmlCompressionOptionStateThe possible Xml Compression Options under 'CREATE TABLE t1 XML_COMPRESSION = { ON | OFF }'
XmlDataTypeOptionThese are the possible modifiers to the xml data type.
XmlForClauseOptionsEnum to store different XML for clause options
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4