Microsoft.SqlServer.Management.Smo Namespace

Classes

AbortAfterWaitConverter
AbstractCollectionBase

Base class for all SMO collections

AffinityInfo

AffinityInfo

AffinityInfoBase

AffinityInfoBase

AgentSubSystemTypeConverter
ApplicationRole

Instance class encapsulating : Server[@Name='']/Database/ApplicationRole

ApplicationRoleCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ApplicationRoleEvents
ArrayListCollectionBase
AsymmetricKey

Instance class encapsulating : Server[@Name='']/Database/AsymmetricKey

AsymmetricKeyCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

AsyncStatus

A helper class that describes status and last exception from an asynchronous operation.

Audit

Instance class encapsulating : Server[@Name='']/Audit

AuditActionTypeConverter
AuditCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

AuditDestinationTypeConverter
AuditExtender
AuditSpecification
AvailabilityDatabase

An Availability Database represents a database that is part of an Availability Group.

AvailabilityDatabaseCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

AvailabilityGroup

An Availability Group (AG) is the unit of high availability. It represents a collection of related databases that form the business critical application that needs high availability and disaster recovery capability.

AvailabilityGroupCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

AvailabilityGroupListener

this is the partial class of code-gen AvailabilityGroupListener

AvailabilityGroupListenerCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

AvailabilityGroupListenerIPAddress

this is the partial class of code-gen AvailabilityGroupListenerIPAddress

AvailabilityGroupListenerIPAddressCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their IPAddress and SubnetMask and SubnetIP properties

AvailabilityGroupListenerIPAddressCollectionBase
AvailabilityGroupState

This is an adapter class that implements the IAvailabilityGroupState logical facet for an Availability Group.

AvailabilityReplica

An Availability Replica is an instance of SQL Server that is part of an Availability Group. The replica hosts copies of the databases in a group. Depending on its current roles, the replica can be the primary of the Availability Group or one of many secondaries.

AvailabilityReplicaCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

Backup
BackupDevice

Instance class encapsulating : Server[@Name='']/BackupDevice

BackupDeviceCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

BackupDeviceItem

Represents a device that will be used to backup to or restore from

BackupDeviceList

Strongly typed list of BackupDeviceItem objects

BackupEncryptionOptions

The BackupEncryptionOptions represents encryption options for backup operations.

BackupMedia

Backup Media class

BackupMediaSet

Backup Media Set

BackupMediaSet.IncompleteBackupMediaSetException

Incomplete backup MediaSet Exception

BackupRestoreBase
BackupSet

Backupset class

BackupSetCollection

Backupset collection class

CatalogCollationTypeConverter
Certificate

Instance class encapsulating : Server[@Name='']/Database/Certificate

CertificateCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

CertificateEvents
Check

Instance class encapsulating : Server[@Name='']/Database/Table/Check

CheckCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

CollationInfo

Provides information about a specific database collation.

CollectionNotAvailableException

The exception thrown when the user is asking for a collection not available for the current server version.

Column

Instance class encapsulating : Server[@Name='']/Database/Table/Column

ColumnCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ColumnEncryptionKey

Represents a sql server column encryption key object

ColumnEncryptionKeyCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ColumnEncryptionKeyValue

Represents a sql server column encryption key value object.

ColumnEncryptionKeyValueCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ColumnEncryptionKeyValueCollectionBase

ColumnEncryptionKeyValueCollectionBase

ColumnMasterKey

Represents a sql server Column Master Key object

ColumnMasterKeyCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ConfigProperty

Instance class encapsulating SQL Server database table trigger

ConfigPropertyCollection
Configuration

Instance class encapsulating SQL Server Configuration object

ConfigurationBase
Cpu

CPU class

CpuCollection

CPU Collection Class

CreateRestorePlanEventArgs

Create restore plan status event args

Credential

Instance class encapsulating : Server[@Name='']/Credential

CredentialCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

CryptographicProvider

Instance class encapsulating : Server[@Name='']/CryptographicProvider

CryptographicProviderCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

Database

Instance class encapsulating : Server[@Name='']/Database

DatabaseActiveDirectory
DatabaseAdapter
DatabaseAdapterBase
DatabaseAuditSpecification

Instance class encapsulating : Server[@Name='']/Database/DatabaseAuditSpecification

DatabaseAuditSpecificationCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

DatabaseAuditSpecificationExtender
DatabaseCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

DatabaseDdlTrigger

Instance class encapsulating : Server[@Name='']/Database/DdlTrigger

DatabaseDdlTriggerCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

DatabaseDdlTriggerEvent

DatabaseDdlTriggerEvent

DatabaseDdlTriggerEventSet

class DatabaseDdlTriggerEventSet

DatabaseEncryptionKey

Instance class encapsulating : Server[@Name='']/Database/DatabaseEncryptionKey

DatabaseEncryptionKeyExtender
DatabaseEvent
DatabaseEventArgs

Provides information about a change to a Database SMO object

DatabaseEvents
DatabaseEventSet
DatabaseFile

Base class for DataFile and LogFile

DatabaseFileMappingsDictionary

This class maps database file paths (i.e. DataFiles and LogFiles paths) from the source server to the corresponding target server location specified by the user.

DatabaseMaintenanceAdapter

The Database Maintenance facet has logical properties. It inherts from the DatabaseAdapter class.

DatabaseMapping

this is a structure to hold database mappings

DatabaseMirroringPayload

Instance class encapsulating : Server[@Name='']/Endpoint/DatabaseMirroring

DatabaseOptions

Instance class encapsulating : Server[@Name='']/Database/Option

DatabasePerformanceAdapter

The Database Performance facet implements logical properties and requires overriding Refresh and Alter Thus it is a new class.

DatabasePermission
DatabasePermissionInfo
DatabasePermissionSet
DatabaseReplicaState

This class represents the runtime state of a database that's participating in an availability group. This database may be located on any of the replicas that compose the availability group.

DatabaseReplicaStateCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their AvailabilityReplicaServerName and AvailabilityDatabaseName properties

DatabaseReplicaStateCollectionBase

this is the class that contains common features of all schema collection classes

DatabaseRestorePlanner

Database Restore Planner.

DatabaseRole

Instance class encapsulating : Server[@Name='']/Database/Role

DatabaseRoleCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

DatabaseScopedConfiguration

The partial definition of the DatabaseScopedConfiguration class. https://msdn.microsoft.com/en-us/library/mt629158.aspx

DatabaseScopedConfigurationCollection

DatabaseScopedConfigurationCollection

DatabaseScopedConfigurationOnOffConverter
DatabaseScopedCredential

Instance class encapsulating : Server[@Name='']/Database/DatabaseScopedCredential

DatabaseScopedCredentialCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

DatabaseSecurityAdapter

Database security adds properties from the children and some computed properties. It inherits from the DatabaseAdapter.

DatabaseSnapshotExtender

Extender class for Database Snapshot

DataFile

This class incapsulates a database data file

DataFileCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

DataTransferBase
DataType

The DataType object allows users to define a SQL Server data type.

DdlTriggerBase
Default

Instance class encapsulating : Server[@Name='']/Database/Default

DefaultCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

DefaultConstraint

Instance class encapsulating : Server[@Name='']/Database/Table/Column/Default

DefaultLanguage

This object manages the lcid and name properties for both the user and database SMO objects. Methods are provided to read and write both the default and fulltext properties.

DefaultRuleBase
DependencyCollection

Dependency tree returned as a result of dependency discovery phase

DependencyCollectionNode

DependencyCollectionNode class represents an individual entry in the dependency list

DependencyNode

DependencyNode is a base node class Contains the urn of the node and the dependency type (SchemaBound/NonSchemaBound) the node has with its parent

DependencyTree

Dependency tree returned as a result of dependency discovery phase

DependencyTreeNode

DependencyTreeNode class represents an individual entry in the dependency tree

DependencyWalker

Instance class encapsulating SQL Server database

DwTableDistributionConverter
DwViewDistributionConverter
EdgeConstraint

This class represents an Edge Constraint object. Edge Constraints restrict connections that can be established in an edge table between two graph nodes. Edge Constraints are creatable and droppable but not alterable. For altering the original must be dropped and new one must be created.

EdgeConstraintClause

Represents an EdgeConstraintClause object. Objects of EdgeConstraintClause types are encapsulated within an EdgeConstraint and represent allowed connections between two graph nodes.

EdgeConstraintClauseCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

EdgeConstraintCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

Endpoint

Instance class encapsulating : Server[@Name='']/Endpoint

EndpointCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

EndpointPayload
EndpointProtocol
EnumToDisplayNameConverter

Converts the specified value object to an enumeration object.

EventProperty

A name-value type of class that holds a single event property.

EventPropertyCollection

A specialized name-object collection (dictionary) used for event properties.

EventSetBase

Abstract class for all Event classes.

ExecutionManager

encapsulates ConnectionContext and isolates it from the rest of SMO

ExtendedProperty

Instance class encapsulating : Server[@Name='']/Database/Table/ExtendedProperty

ExtendedPropertyCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ExtendedStoredProcedure

Instance class encapsulating : Server[@Name='']/Database/ExtendedStoredProcedure

ExtendedStoredProcedureCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

ExternalDataSource

Represents a SQL server external data source object.

ExternalDataSourceCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ExternalDataSourcePushdownOptionConverter
ExternalDataSourceTypeConverter
ExternalFileFormat

Represents a SQL server External File Format object.

ExternalFileFormatCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ExternalFileFormatTypeConverter
ExternalLibrary

Instance class encapsulating : Server[@Name='']/Database/ExternalLibrary

ExternalLibraryCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ExternalLibraryFile

Instance class encapsulating : Server[@Name='']/Database/ExternalLibrary/ExternalLibraryFile

ExternalResourcePool

Represents a SQL server external resource pool object.

ExternalResourcePoolAffinityInfo

ExternalResourcePoolAffinityInfo

ExternalResourcePoolCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ExternalTableDistributionConverter
ExternalTableRejectTypeConverter
FailedOperationException

The exception thrown when an operation has failed.

FeatureRestriction
FeatureRestrictionCollection
FileGroup

Represents a sql server database filegroup

FileGroupCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ForeignKey

Instance class encapsulating : Server[@Name='']/Database/Table/ForeignKey

ForeignKeyCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ForeignKeyColumn

Instance class encapsulating : Server[@Name='']/Database/Table/ForeignKey/Column

ForeignKeyColumnCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

FrequencyPair
FullTextCatalog

Instance class encapsulating : Server[@Name='']/Database/FullTextCatalog

FullTextCatalogCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

FullTextIndex

Instance class encapsulating : Server[@Name='']/Database/Table/FullTextIndex

FullTextIndexColumn

Instance class encapsulating : Server[@Name='']/Database/Table/FullTextIndex/FullTextIndexColumn

FullTextIndexColumnCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

FullTextService

Instance class encapsulating : Server[@Name='']/FullTextService

FullTextStopList

Instance class encapsulating : Server[@Name='']/Database/FullTextStopList

FullTextStopListCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

HttpProtocol

Instance class encapsulating : Server[@Name='']/Endpoint/Http

Index

Instance class encapsulating : Server[@Name='']/Database/Table/Index

IndexCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

IndexedColumn

Instance class encapsulating : Server[@Name='']/Database/Table/Index/IndexedColumn

IndexedColumnCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

IndexedXmlPath

Instance class encapsulating : Server[@Name='']/Database/Table/Index/IndexedXmlPath

IndexedXmlPathCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

IndexedXmlPathNamespace

Instance class encapsulating : Server[@Name='']/Database/Table/Index/IndexedXmlPathNamespace

IndexedXmlPathNamespaceCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

IndexEvents
IndexTypeConverter
Information

Instance class encapsulating : Server[@Name='']/Information

InternalSmoErrorException

The exception thrown when there is an internal error with a T:Microsoft.SqlServer.Management.Smo object.

InvalidRestorePlanException

Exception thrown on trying to execute or verify an invalid Restore plan.

InvalidScriptingOptionException

This exception gets thrown when invalid scripting options are set

InvalidSmoOperationException

The exception thrown when an operation cannot be performed in the current object state.

InvalidVersionSmoOperationException

The exception thrown when an operation cannot be performed in the current version.

JobScheduleCollectionBase
Language

Instance class encapsulating : Server[@Name='']/Language

LanguageCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

LinkedServer

Instance class encapsulating : Server[@Name='']/LinkedServer

LinkedServerCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

LinkedServerLogin

Instance class encapsulating : Server[@Name='']/LinkedServer/Login

LinkedServerLoginCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

LogFile

This class incapsulates a database log file

LogFileCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

Login

This class represents a SqlServer login

LoginCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

LoginEvents
MasterKey

Instance class encapsulating : Server[@Name='']/Database/MasterKey

MessageCollectionBase
MessageObjectBase
MissingObjectException

The exception thrown when an object is missing from a collection or when a collection does not exist under a server version.

NamedSmoObject
NextRestoreEventArgs

Next Restore Event arguments

NumaNode

NumaNode Class

NumaNodeCollection

NumaNode collection, class containg collection of all Numas

NumberedObjectCollectionBase

base class for all generic collections

NumberedStoredProcedure

Instance class encapsulating : Server[@Name='']/Database/StoredProcedure/Numbered

NumberedStoredProcedureCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

NumberedStoredProcedureParameter

Instance class encapsulating : Server[@Name='']/Database/StoredProcedure/Numbered/Param

NumberedStoredProcedureParameterCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ObjectAlteredEventArgs

argument for ObjectAlteredEventHandler

ObjectCreatedEventArgs

argument for ObjectCreatedEventHandler

ObjectDroppedEventArgs

argument for ObjectDroppedEventHandler

ObjectEvent
ObjectEventSet
ObjectPermission
ObjectPermissionInfo
ObjectPermissionSet
ObjectRenamedEventArgs

argument for ObjectRenamedEventHandler

OleDbProviderSettings

Instance class encapsulating : Server[@Name='']/Setting/OleDbProviderSetting

OleDbProviderSettingsCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

OrderColumn

Instance class encapsulating : Server[@Name='']/Database/UserDefinedFunction/OrderColumn

OrderColumnCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

PageRestorePlanner

Page Restore Planner

Parameter

Instance class encapsulating : Server[@Name='']/Database/UserDefinedFunction/Param

ParameterBase
ParameterCollectionBase
PartitionFunction

Instance class encapsulating : Server[@Name='']/Database/PartitionFunction

PartitionFunctionCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

PartitionFunctionEvents
PartitionFunctionParameter

Instance class encapsulating : Server[@Name='']/Database/PartitionFunction/PartitionFunctionParameter

PartitionFunctionParameterCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

PartitionNumberedObjectCollectionBase
PartitionScheme

Instance class encapsulating : Server[@Name='']/Database/PartitionScheme

PartitionSchemeCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

PartitionSchemeEvents
PartitionSchemeParameter

Instance class encapsulating : Server[@Name='']/Database/Table/PartitionSchemeParameter

PartitionSchemeParameterCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

PathWrapper

Helper class to deal with Path manipulation and handles XI paths as well. We could take ServerConnection as a parameter and get the PathSeparator from it but these might be used in offline situations too

Payload
PercentCompleteEventArgs

Arguments for the event handler of the percent complete

PerformanceCounters
PermissionInfo
PermissionSetBase

Abstract class for all Permission classes.

PhysicalPartition

Instance class encapsulating : Server[@Name='']/Database/PartitionFunction

PhysicalPartitionCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

PlanGuide

Represents a sql server database plan

PlanGuideCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

PlanGuideExtender
ProgressReportEventArgs
Property
PropertyCannotBeRetrievedException

The exception thrown when the caller is asking for a property that returned null during enumeration.

PropertyCollection
PropertyMissingEventArgs

Describes the missing property which leads to either a full object initialization or to loading an expensive property separately from initialization

PropertyNotSetException

The exception thrown when an action requires a property that has not been set by the user.

PropertyReadOnlyException

The exception that is thrown when trying to set a readonly property.

PropertyTypeMismatchException

The exception thrown if a value of the wrong type is assigned to a property.

PropertyWriteException

The exception thrown when trying to set a property that has been blocked.

Protocol
QueryStoreCaptureModeConverter

type converter for QueryStoreCaptureMode

QueryStoreOperationModeConverter

type converter for QueryStoreOperationMode

QueryStoreOptions

QueryStore Options Smo Object.

QueryStoreSizeBasedCleanupModeConverter

type converter for QueryStoreSizeBasedCleanupMode

QueryStoreWaitStatsCaptureModeConverter

type converter for QueryStoreWaitStatsCaptureMode

RangeTypeConverter
RelocateFile
RemoteDataArchiveMigrationStatusReport

Status report for each batch of rows migrated to Remote Data Archive

RemoteDatabaseMigrationStatistics

Statistics about the Remote database created for Remote Data Archive

RemoteTableMigrationStatistics

Statistics about the Remote table created for Remote Data Archive

ResourceGovernor

Class that handles Altering and Scripting the current state of Resource Governor

ResourcePool

Class that handles Creating, Altering, Dropping and Scripting the Resource Pool instance

ResourcePoolAffinityInfo

ResourcePoolAffinityInfo

ResourcePoolCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

Restore
RestoreOptions
RestorePlan

Database Restore Plan is a sequence of Database Restore operations which will recover a Database to a particular state in a point in time.

ResumableIndex

The partial definition of the ResumableIndex class. https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-index-resumable-operations https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql https://docs.microsoft.com/en-us/sql/t-sql/statements/create-index-transact-sql

ResumableIndexCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ResumableOperationStateTypeConverter
Rule

Instance class encapsulating : Server[@Name='']/Database/Rule

RuleCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

Scheduler

Scheduler class

SchedulerCollection

Scheduler collection, a class containg collection of all schedulers in the system and their affinity to the parent resource pool.

Schema

Instance class encapsulating : Server[@Name='']/Database/Schema

SchemaCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SchemaCollectionBase
SchemaCustomResolver

Custom resolver for Schema We need a custom resolver as not all schema based objects live under Database For example service broker objects have an intermediate object so we cannot resolve using a fixed template

SchemaEvents
Scripter

Instance class encapsulating Scripter object

ScriptingErrorEventArgs
ScriptingOptions

Instance class encapsulating SQL Server database

ScriptingPreferences

Defines preferences for scripting

ScriptMaker

Provides methods to get SMO objects' scripts

ScriptNameObjectBase
ScriptOption

A single scripting option. It represents a single value from the above enum.

ScriptSchemaObjectBase
ScriptWriterException

The exception thrown when script writing fails.

SearchProperty

SMO class for Search Properties in a Search Property List

SearchPropertyCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SearchPropertyList

SMO class for Search Property List

SearchPropertyListCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SearchPropertyListExtender

Class which provides extended properties for a SearchPropertyList object

SecurityPolicy

Represents a sql server Security Policy object

SecurityPolicyCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

SecurityPredicate

Represents a sql server security predicate object.

SecurityPredicateCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SecurityPredicateCollectionBase

SecurityPredicateCollectionBase

SecurityPredicateOperationConverter
SecurityPredicateTypeConverter
SensitivityRankConverter
Sequence

Represents a sql server Sequence object

SequenceCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

SequenceEvents
SequenceExtender

Represents sql server SequenceExtender object

Server

Instance class encapsulating : Server[@Name='']

ServerActiveDirectory
ServerAdapter

This class is exactly the ServerAdapterBase class, but it implements IDmfAdapter

ServerAdapterBase

This class acts as the flattener for Server properties hidden in Server.Settings and Server.Configuration Facets will inherit from this class to add new logical properties, use this class's Alter and Refresh methods, or they override the Alter and Refresh methods.

This class should not implement IDmfAdapter or any facet directly. Facets must be on leaf-level classes and this class is not intended to be a leaf-level class.

ServerAuditSpecification

Instance class encapsulating : Server[@Name='']/ServerAuditSpecification

ServerAuditSpecificationCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ServerAuditSpecificationExtender
ServerConfigurationAdapter

The Server Configuration properties need to only Alter and Refresh the Server.Configuration properties. This class inherits from ServerAdapterBase and overrides those functions.

ServerDdlTrigger

Instance class encapsulating : Server[@Name='']/DdlTrigger

ServerDdlTriggerCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ServerDdlTriggerEvent

ServerDdlTriggerEvent

ServerDdlTriggerEventSet

class ServerDdlTriggerEventSet

ServerEvent
ServerEvents

Class that encapsulates all functionality related to Server Events.

ServerEventSet
ServerPermission
ServerPermissionInfo
ServerPermissionSet
ServerProxyAccount

Instance class encapsulating : Server[@Name='']/ServerProxyAccount

ServerRole

Instance class encapsulating : Server[@Name='']/Role

ServerRoleCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ServerRoleEvents
ServerRoleExtender
ServerSecurityAdapter

Relational Engine Security. This facet has some logical properties and it needs its own Refresh and Alter. It inherits from the ServerAdapterBase.

ServerSelectionAdapter

Server Selection. This facet has logical properties enabling users to chose properties to select server. It inherits from the ServerAdapterBase.

ServerSetupAdapter

Adapter for AS SAC facet

ServerSurfaceAreaAdapter

This facet is entirely a subset of configuration options, so it is just an interface on the ServerConfigurationAdapter

ServerTraceEvent
ServerTraceEventSet
ServiceBrokerPayload

Instance class encapsulating : Server[@Name='']/Endpoint/ServiceBroker

ServiceMasterKey

Instance class encapsulating : Server[@Name='']/MasterKey

ServiceQueueEvent
ServiceQueueEventSet
ServiceRequestException

This exception incapsulates a service provider error.

Settings

Instance class encapsulating : Server[@Name='']/Setting

SfcDependencyException

This exception gets thrown when a dependency operation failed TODO: this will move to SFC once we have generalized the dependency classes (see SfcDependencyDiscovery.cs).

SimpleObjectCollectionBase

base class for all generic collections

SmartAdmin

Class that handles Altering and Scripting the current state of smart admin

SmartAdminState

This is an adapter class that implements the ISmartAdminState logical facet for an Availability Group.

SmoApplication
SmoCollectionBase
SmoDependencyDiscoverer

Class to which finds referenced,refrencing objects and children

SmoDmfAdapter
SmoEventArgs

Base argument class for Smo native events

SmoException

The base class for all SMO exception classes.

SmoObjectBase
SmoObjectExtender<T>

Extender class for Smo Objects

SmoUtility

Utility and helper methods for SMO

SoapMethodCollectionBase
SoapMethodObject
SoapPayload

Instance class encapsulating : Server[@Name='']/Endpoint/Soap

SoapPayloadMethod

Instance class encapsulating : Server[@Name='']/Endpoint/Soap/Method

SoapPayloadMethodCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SortedListCollectionBase
SqlAssembly

Instance class encapsulating : Server[@Name='']/Database/SqlAssembly

SqlAssemblyCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SqlAssemblyEvent
SqlAssemblyEvents
SqlAssemblyEventSet
SqlAssemblyFile

Instance class encapsulating : Server[@Name='']/Database/SqlAssembly/SqlAssemblyFile

SqlAssemblyFileCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SqlPropertyCollection
SqlPropertyInfo

Class encapsulating metadata and version info about a sql property.

SqlSmoObject

Contains common functionality for all the instance classes

SqlSupport

Contains assorted helper functions

SqlVariantSerializationAdapter

Serializes objects that represent sql_variant instances to SFC XML

Statistic

Instance class encapsulating : Server[@Name='']/Database/Table/Statistic

StatisticCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

StatisticColumn

Instance class encapsulating : Server[@Name='']/Database/Table/Statistic/Column

StatisticColumnCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

StatisticEvents
StoredProcedure

Instance class encapsulating : Server[@Name='']/Database/StoredProcedure

StoredProcedureCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

StoredProcedureEvent
StoredProcedureEvents
StoredProcedureEventSet
StoredProcedureParameter

Instance class encapsulating : Server[@Name='']/Database/StoredProcedure/Param

StoredProcedureParameterCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SuspectPage

Database page used for Page Restore.

SymmetricKey

Instance class encapsulating : Server[@Name='']/Database/SymmetricKey

SymmetricKeyCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SymmetricKeyEncryption

This object is used to specify an encryption type.

Synonym

Instance class encapsulating : Server[@Name='']/Database/Synonym

SynonymCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

SynonymEvents
SystemDataType

Instance class encapsulating : Server[@Name='']/SystemDataType

SystemDataTypeCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

SystemMessage

Instance class encapsulating : Server[@Name='']/SystemMessage

SystemMessageCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

Table

Instance class encapsulating : Server[@Name='']/Database/Table

TableCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

TableEvent
TableEvents
TableEventSet
TableViewBase
TableViewTableTypeBase
TcpProtocol

Instance class encapsulating : Server[@Name='']/Endpoint/Tcp

TemporalHistoryRetentionPeriodUnitTypeConverter
Transfer

Instance class encapsulating Transfer object

TransferBase

Base class for transfer

Trigger

Instance class encapsulating : Server[@Name='']/Database/Table/Trigger

TriggerCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

TriggerEvents
TypeConverters
UnknownPropertyException

The exception thrown when trying to access a property that does not exist for a server version.

UnsupportedCompatLevelException

The exception gets thrown when an operation is executed with an unsupported compatability level for that operation specified.

UnsupportedEngineEditionException

This exception gets thrown when an unsupported engine edition is detected.

UnsupportedEngineTypeException

This exception gets thrown when an operation has failed

UnsupportedFeatureException

The exception thrown when an object is not supported by Sql Express

UnsupportedObjectNameException

The exception thrown when the user is trying to create an object with a name that cannot be supported, such as a null string.

UnsupportedVersionException

The exception gets thrown when an operation has failed.

UrnCollection

ArrayList of Urn objects

User

Instance class encapsulating : Server[@Name='']/Database/User

UserCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

UserDefinedAggregate

Instance class encapsulating : Server[@Name='']/Database/UserDefinedAggregate

UserDefinedAggregateCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

UserDefinedAggregateParameter

Instance class encapsulating : Server[@Name='']/Database/UserDefinedAggregate/Param

UserDefinedAggregateParameterCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

UserDefinedDataType

Instance class encapsulating : Server[@Name='']/Database/UserDefinedDataType

UserDefinedDataTypeCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

UserDefinedDataTypeResolver

Custom resolver for DataType::UserDefinedDataType TODO: implement resolvers for other types (note that the URN resolver can be generic for all data types)

UserDefinedFunction

Instance class encapsulating : Server[@Name='']/Database/UserDefinedFunction

UserDefinedFunctionCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

UserDefinedFunctionEvent
UserDefinedFunctionEvents
UserDefinedFunctionEventSet
UserDefinedFunctionParameter

Instance class encapsulating : Server[@Name='']/Database/UserDefinedFunction/Param

UserDefinedFunctionParameterCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

UserDefinedMessage

Instance class encapsulating : Server[@Name='']/UserDefinedMessage

UserDefinedMessageCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

UserDefinedTableType

Instance class encapsulating : Server[@Name='']/Database/UserDefinedTableType

UserDefinedTableTypeCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

UserDefinedTableTypeResolver

Custom resolver for DataType::UserDefinedTableType

UserDefinedType

Instance class encapsulating : Server[@Name='']/Database/UserDefinedType

UserDefinedTypeCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

UserDefinedTypeEvents
UserDefinedTypeResolver

Custom resolver for DataType::UserDefinedType

UserEvents
UserOptions

Instance class encapsulating : Server[@Name='']/UserOption

VerifyCompleteEventArgs

Event argument class for VerifyCompleteEventHandler

VersionSerializationAdapter

Serializes instances of System.Version to Sfc XML

VersionUtils

Helper class to handle various version-related checks

View

Instance class encapsulating : Server[@Name='']/Database/View

ViewCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

ViewEvent
ViewEvents
ViewEventSet
WorkloadGroup

Class that handles Creating, Altering, Dropping and Scripting the Workload group instance

WorkloadGroupCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

WrongPropertyValueException

The exception thrown during a scripting action when a property has an unusable value or there is a conflict between two or more properties.

XmlSchemaCollection

Instance class encapsulating : Server[@Name='']/Database/XmlSchemaCollection

XmlSchemaCollectionCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

Structs

AuditSpecificationDetail
DdlTextParserHeaderInfo

Interfaces

IAvailabilityGroupState

This facet aggregates various availability group state information. It is used to support SQL Server manageability tools.

IColumnPermission

Interface for column-level object permissions.

IDatabaseMaintenanceFacet
IDatabaseOptions
IDatabasePerformanceFacet
IDatabaseSecurityFacet
IExtendedProperties
ILoginOptions
IMultipartNameFacet

Identity Facet

INameFacet

Name Facet

IObjectPermission

Methods for enumerating, granting, and denying permissions on an object.

IScriptable
IServerAuditFacet
IServerConfigurationFacet
IServerInformation
IServerPerformanceFacet
IServerSecurityFacet
IServerSelectionFacet
IServerSettings
IServerSetupFacet

Server installation facet

ISmartAdminState

This facet aggregates smartadmin state information. It is used to support SQL Server manageability tools.

ISmoApplicationEvents

Defines an object that exposes application-wide SMO events

ISmoDependencyDiscoverer

Defines an interface for discovering URNs of dependent objects

ISurfaceAreaFacet
ITableOptions
ITextObject

Interface implemented by all instance classes that have all or a part of their definition as text

IUserOptions
IViewOptions

Enums

AbortAfterWait

Specifies the ABORT_AFTER_WAIT option of a DDL operation.

ActivationExecutionContext

Specifies the user context for objects activation.

AffinityType

Affinity type of Cpu Auto or Manual

AssemblyAlterOptions
AssemblySecurityLevel

Specifies the access rights for an Assembly.

AsymmetricKeyEncryptionAlgorithm

Specifies the algorithm used to encrypt a (asymmetric) key.

AsymmetricKeySourceType

Specifies the source of the certificate, when loading.

AttachOptions

List of options that may be passed to Server.AttachDatabase

AuditActionType

Specifies the type of action for sql server audit events

AuditDestinationType

Specifies the destination type of an Audit

AuditFileSizeUnit

Specifies the unit of file size

AuditLevel
AuditStatusType

Specifies the state of the Audit

AuthenticationType

Specifies the authentication type of the database principals

AvailabilityDatabaseSynchronizationState

The different synchronization states a database participating in an HADR Availability Group can be in.

AvailabilityGroupAutomatedBackupPreference

This enumeration specifies how replicas in the primary role are treated in the evaluation to pick the desired replica to perform a backup.

AvailabilityGroupClusterType

Cluster type of the Availability Group

AvailabilityGroupFailureConditionLevel

The different conditions that can trigger an automatic failover in an Availability Group. These setting are cumulative, meaning that as the setting increases in value it encompases all the previous conditions and adds extra ones.

AvailabilityGroupListenerIPState

State of the Availability Group Listener IP Address

AvailabilityGroupRollupSynchronizationState

A rollup of the synchronization states of the availability replicas in the availability group.

AvailabilityReplicaAvailabilityMode

Availability modes of Availability Replica The int value has to match the values defined by the engine, can be found here: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-availability-replicas-transact-sql

AvailabilityReplicaConnectionModeInPrimaryRole

Connection intent modes of an Availability Replica in primary role

AvailabilityReplicaConnectionModeInSecondaryRole

Connection intent modes of an Availability Replica in secondary role

AvailabilityReplicaConnectionState

The current connection state of an availability replica.

AvailabilityReplicaFailoverMode

Failover modes of Availability Replica

AvailabilityReplicaJoinState

The join state of an Availability Replica

AvailabilityReplicaOperationalState

The state of the replica's readiness to process client requests for all databases replicas in the availability group residing on it.

AvailabilityReplicaRole

The current role a replica is playing in an availability group.

AvailabilityReplicaRollupRecoveryState

Represents a rollup of the recovery state of all database replicas in the availability group that reside on this availability replica.

AvailabilityReplicaRollupSynchronizationState

The current synchronization state of the availability replica. This is based on the synchronization states of database replicas in the availaiblity group residing on the instance.

AvailabilityReplicaSeedingMode

Seeding mode of Availability Replica

BackupActionType
BackupCompressionOptions

The BackupCompressionOptions enumeration contains values that are used to specify a backup compression option

BackupDeviceType
BackupEncryptionAlgorithm

Specifies the algorithm type used for backup encryption.

BackupEncryptorType

Specifies the encryptor type used to encrypt an encryption key.

BackupRestoreBase.AsyncOperation
BackupSetFlag
BackupSetType

Backupset type : Full Database, Differential, Log, File or Filegroup

BackupTruncateLogType
CatalogCollationType

Catalog Collation Type values.

CatalogPopulationAction

Specifies catalog population action.

CatalogPopulationStatus

Specifies the population state of a Microsoft Search fulltext catalog.

CertificateSourceType
ChangeTracking
ClusterMemberState

The state of a member in a Windows Cluster.

ClusterMemberType

The type of node in the windows cluster

ClusterQuorumState

The current stat of the cluster quorum

ClusterQuorumType

The different types of ways a cluster can decide on a quorum

CollationVersion

Specifies the Collation Version

ColumnEncryptionType

EncryptionType for a column encrypted with TCE

CompatibilityLevel
ContainmentType

Enumerates the containment types of a database.

CreateDispositionType

Contains the values of CREATION_DISPOSITION option

DatabaseDdlTriggerExecutionContext

Specifies the user context in which assembly code will run.

DatabaseEncryptionAlgorithm

Specifies the algorithm used to encrypt the database encryption key

DatabaseEncryptionState

Specifies the current encryption transition state of the database

DatabaseEncryptionType

Specifies the encryption type used to encrypt the database encryption key

DatabaseEventType
DatabaseObjectTypes
DatabasePermissionSetValue

Enum containing all possible DatabasePermissions use sys.fn_builtin_permissions to see the latest values on new versions of SQL

DatabaseRecoveryState

Database recovery state.

DatabaseReplicaSuspendReason

The different reasons for a database replica to be in suspended state.

DatabaseScopedConfigurationOnOff

Database Scoped Configuration on and off states.

DatabaseStatus
DatabaseUserAccess

enum values are aranget to mach sys.databases.user_access

DataCompressionType

DataCompressionType describe about the compression status of a table/index partition. None means no compression, Row means compression row wise,Page means compression applied page wise and ColumnStore is compression columnstore wise

DelayedDurability

Specifies the delayed durability option of the database.

DependencyType
DeviceType

Backup Media Device Type

DurabilityType

The enumeration specifies the durability type of hekaton tables

DwTableDistributionType

The enumeration specifies the SQL DW distributed table distribution types.

DwViewDistributionType

The enumeration specifies the SQL DW materialized view distribution types.

EdgeConstraintDeleteAction

Enumerates possible referential actions when an EdgeConstraint object is modified. see ec syntax: | [ EdgeConstraint ] CONNECTION ([ schema_name . ] referenced_table_from_name TO [ schema_name . ] referenced_table_to_name] [ ON DELETE { NO ACTION | CASCADE } ]

Edition

the possible values returned by SERVERPROPERTY['EngineEdition']

EndpointAuthenticationOrder

The type of connection authentication required for connections to this endpoint.

EndpointEncryption

EndpointEncryption

EndpointEncryptionAlgorithm

EndpointEncryptionAlgorithm

EndpointState
EndpointType
EventType
ExecutionContext

Specifies the user context in which assembly code will run.

ExecutionStatus

An enum describing a state of asynchronous query

ExternalDataSourcePushdownOption

Enumerates possible Pushdown options on External Datasource

ExternalDataSourceType

The enumeration specifies the external data source type for external tables

ExternalFileFormatType

The enumeration specifies the external file format types

ExternalLibraryContentType

Specifies the content type for an external library installation or alteration.

ExternalTableDistributionType

The enumeration specifies the external table distribution. Valid for tables with ShardMapManager external data sources.

ExternalTableRejectType

The enumeration specifies the external table reject types

FeatureRestriction.PrincipalClass
FileGroupType

Type of a filegroup file

FileGrowthType
FilestreamAccessLevelType

List of SQL Server filestream access level types

FileStreamEffectiveLevel

The effective level for the FILESTREAM feature

FileStreamLevel

Filestream level options

FilestreamNonTransactedAccessType

Filestream non-transacted access type

ForeignKeyAction

see fk syntax: | [ FOREIGN KEY ] REFERENCES [ schema_name . ] referenced_table_name [ ( ref_column ) ] [ ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ]

FragmentationOption

specifies how index fragmentation will be retrieved

FullTextCatalogUpgradeOption

Specifies the Full Text Catalog Upgrade options

GeneratedAlwaysType

Types of temporal auto-generated columns

GraphType
HadrManagerStatus

The status of the HADR Manager Service

HttpAuthenticationModes
HttpPortTypes
ImplementationType

Specifies the implementation type of a StoredProcedure, UserDefinedFunction,, and other objects.

IndexedXmlPathType

represents the type of indexed path in Selective Xml Index

IndexEnableAction

specifies how an index should be re-enabled

IndexKeyType

The enumeration specifies the attributes of the Index object

IndexOperation

specifies what operation to perform on an index alter

IndexPopulationAction

Specifies index population action.

IndexPopulationStatus

Specifies the population state of a full-text table index.

IndexType

The enumeration specifies the type of the Index.

InDoubtTransactionResolutionType

List of SQL Server repair types

InstanceState

InstanceState values

KeyEncryptionType

Specifies the type of encryption of a key.

LinkedTableType

Types of tables that can be enumerated on the linked server

LinkFieldType

type of the field in link

LockEscalationType

The enumeration specifies the lock escalation granularity

LockRequestStatus
LoginCreateOptions

Specifies options that can be specified when creating a login

LoginType
LogReuseWaitStatus

Reuse of transaction log space is currently waiting on.

MappedClassType

Specifies the class to which a Credential is mapped

MediaTypes
MethodLoginType

LoginType of SoapPayloadMethod

MethodXsdSchemaOption
MirroringOption

The MirroringOption enum is used to change the state or a Database mirror.

MirroringRole

Role the database plays in mirroring, one of:

MirroringSafetyLevel

Safety guarantee of updates on the backup, one of:

MirroringStatus

Role the database plays in mirroring, one of:

MirroringWitnessStatus
Month
NSActivationState

This enum describes the state of a Notification Service application component.

NumaNodeAffinity

Defines Affinity Type of NumaNode

ObjectClass

see engine spec: CatalogViewsRef: Appendix Universal Entity Classes The following table represents the domain of entity classes in the system, defined in the header file cmedscan.h. Entity class usages include: sys.database_permissions sys.server_permissions sys.extended_properties included here are only securable objects

ObjectPermissionSetValue

enum containing all possible ObjectPermissions

OnFailureAction

Specifies the action that needs to be taken when the audit sink cannot perform the write

PageVerify

The PageVerify enum specifies the type of integrity check performed on page reads.

PartitioningScheme

Enumerates whether Partition Scheme is scripted for None,Table,Index or All

PasswordHashAlgorithm

Enumerates the hash algorithms that are used to authenticate SQL Login passwords.

PathType

Denotes the type of file path for PathWrapper methods

PerfMonMode

Specifies the mode in which PerfMon works

PermissionState
PlanGuideType

Type of plan guide

PrincipalType

Specifies the type of the server or database principal

PrivateKeyEncryptionType

Specifies the type of encryption of a key

PrivilegeTypes

List of object and database privileges

ProtocolType
ProviderAuthenticationType

Specifies the type of Authentication supported by Cryptographic Provider

QueryStoreCaptureMode

Capture Mode values for Query Store

QueryStoreOperationMode

Operation Mode values for Query Store

QueryStoreSizeBasedCleanupMode

Size Based Cleanup Mode values for Query Store

QueryStoreWaitStatsCaptureMode

Wait Statistics Capture Mode values for Query Store

RangeType

The RangeType enum specifies whether the boundary values specified with RangeValues are placed in the LEFT or RIGHT side of the interval. None corresponds to no boundary condition. Table with no partition is suitable example.

RecoveryModel

enum values are aranget to mach sys.databases.recovery_option

RemoteDataArchiveMigrationState

Current data migration state of a stretched table Refer remote_data_archive_migration_state in https://msdn.microsoft.com/en-us/library/ms187406.aspx

RepairOptions

Specifies the repair options

RepairStructure

Specifies the kind of repair structure

RepairType

List of SQL Server repair types

ReplicationOptions

The ReplicationOptions enum specifies the active replication settings for a database,

ResourceUsage

Specifies the available system resources for the MSSearch Service.

RestoreActionType
RestoreType
ResultFormat
ResumableOperationStateType

Resumable Operation State: Running, Paused, None.

RetentionPeriodUnits

Change Tracking Retention Period Units

RoleTypes
ScriptBehavior

Enumerates ScriptBehavior as Drop,Create,CreateOrAlter or Drop and Create

ScriptNameObjectBase.ScriptHeaderType
SecondaryXmlIndexType

represents the type of the secondary xml index

SecurityPredicateOperation

Security predicate operation types

SecurityPredicateType

Security predicate type

SensitivityRank

Specifies the sensitivity rank of a column

SequenceCacheType

Specifies the cache type of a Sequence object.

ServerDdlTriggerExecutionContext

Specifies the user context in which assembly code will run.

ServerLoginMode
ServerMirroringRole
ServerPermissionSetValue

enum containing all possible ServerPermissions

ServerStatus

the possible values of server status

ServiceStartMode

The start mode for a service

ShrinkMethod
SmoExceptionType

Enumeration of exception types defined by T:Microsoft.SqlServer.Management.Smo.SmoExceptionType.

SnapshotIsolationState
SortOrder
SpatialGeoLevelSize

The Spatial Geo Level Sizes

SpatialIndexType

The Spatial Index type for the Spatial Indices

SqlDataType

The SqlDataType specifies the type of the DataType object.

SqlServerVersion

Enumerates versions of SqlServer supported by SMO.

SqlServerVersions
SqlSmoState
SqlVerifyAction

Specifies what needs to be verified

StatisticsScanType
StatisticsTarget
StopListOption

Specifies the Stoplist options associated with a FullText Index.

SymmetricKeyEncryptionAlgorithm

Specifies the algorithm used to encrypt a (symmetric) key

SymmetricKeyEncryptionType

Specifies the type of encryption of a key.

SynonymBaseType

Specifies the type of base object of a synonym.

TableTemporalType

Types of Temporal tables

TemporalHistoryRetentionPeriodUnit

Temporal retention period unit description

TerminationClause
TransactionTypes

Specifies the types of transactions that may be active in a database

UrnIdOption
UserDefinedFunctionType
UserDefinedTypeFormat

Specifies how a UDT is stored.

UserType

Specifies the type of user in a database.

WindowsLoginAccessType
WorkloadGroupImportance

Specifies the Importance Type for Resource Governor Workload group

WsdlGeneratorOption
XmlDocumentConstraint

Specifies types of XML document constraints

XmlFormatOption
XmlTypeDerivation

Specifies the xml type derivation

XmlTypeKind

Specifies the kind of xml component

XsdSchemaOption

Specifies if an XSD schema will be returned for a SOAP method.

Delegates

DatabaseRestorePlanner.CreateRestorePlanEventHandler

Create restore plan status update delegate

NextRestoreEventHandler

the prototype of the callback method for next restore

PercentCompleteEventHandler

the prototype of the callback method for percent complete

ProgressReportEventHandler
ScriptingErrorEventHandler
ScriptingFilter
ServerEventHandler

Handler prototype for all server events.

SmoApplication.AnyObjectEventHandler

called for any of the above events. This allows handling all event types using one handler

SmoApplication.DatabaseEventHandler

called for database events

SmoApplication.ObjectAlteredEventHandler

called when an object is successfully altered

SmoApplication.ObjectCreatedEventHandler

Called when an object is successfully created

SmoApplication.ObjectDroppedEventHandler

called when an object is successfully dropped

SmoApplication.ObjectRenamedEventHandler

called when an object is successfully renamed

VerifyCompleteEventHandler

Event signature for VerifyComplete event