TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Microsoft.SqlServer.Management.Smo Namespace

 

The Microsoft.SqlServer.Management.Smo namespace contains classes that represent the core SQL Server Database Engine objects. These include instances, databases, tables, stored procedures, and views.

ClassDescription
System_CAPS_pubclassAbstractCollectionBase

The AbstractCollectionBase object is a base class object that is used in the construction of collection objects.

System_CAPS_pubclassAffinityInfo

The AffinityInfo object represents the Affinity settings for all CPUs and NUMA nodes on an Instance of SQL Server. Access to the AffinityInfo object is provided though the Server object.

System_CAPS_pubclassAffinityInfoBase

Represents a base class of AffinityInfo.

System_CAPS_pubclassApplicationRole

The ApplicationRole object represents a security role that is used to set access privileges from an application regardless of the user's permissions.

System_CAPS_pubclassApplicationRoleCollection

The ApplicationRoleCollectionclass represents a collection of ApplicationRole objects that represent all the application roles on the referenced database.

System_CAPS_pubclassApplicationRoleEvents

The ApplicationRoleEvents object represents the settings required for Microsoft SQL Server application role event notification.

System_CAPS_pubclassArrayListCollectionBase

The ArrayListCollectionBase object represents a base class that is used in the construction of collections that are based on array lists.

System_CAPS_pubclassAsymmetricKey

The AsymmetricKey object represents a SQL Server asymmetric key.

System_CAPS_pubclassAsymmetricKeyCollection

The AsymmetricKeyCollection class represents a collection of AsymmetricKey objects that represent all the asymmetric keys on the referenced database.

System_CAPS_pubclassAsyncStatus

The AsyncStatus object represents the status of an asynchronous process.

System_CAPS_pubclassAudit

The Audit object represents a SQL Server audit log.

System_CAPS_pubclassAuditCollection

The AuditCollection class represents a collection of Audit objects that represent all the audits on the instance of SQL Server.

System_CAPS_pubclassAuditExtender

Adds methods and properties to the Audit object.

System_CAPS_pubclassAuditSpecification

The AuditSpecification class defines the audit groups and specifies the server audit that they belong to.

System_CAPS_pubclassAvailabilityDatabase

Represents the availability database.

System_CAPS_pubclassAvailabilityDatabaseCollection

Represents the collection of databases contained in the availability group.

System_CAPS_pubclassAvailabilityGroup

Displays the availability group that contains the databases and replicas.

System_CAPS_pubclassAvailabilityGroupCollection

Displays a collection of specified objects in the availability group.

System_CAPS_pubclassAvailabilityGroupListener

Represents the object of the availability group listener.

System_CAPS_pubclassAvailabilityGroupListenerCollection

Represents a collection of AvailabilityGroupListener objects.

System_CAPS_pubclassAvailabilityGroupListenerIPAddress

Represents an availability group listener IP address.

System_CAPS_pubclassAvailabilityGroupListenerIPAddressCollection

Represents a collection of AvailabilityGroupListenerIPAddress objects.

System_CAPS_pubclassAvailabilityGroupListenerIPAddressCollectionBase

Represents a class that contains common features of all schema collection classes.

System_CAPS_pubclassAvailabilityGroupState

Represents an adapter class that implements the IAvailabilityGroupState logical facet for an availability group.

System_CAPS_pubclassAvailabilityReplica

Displays the availability replica and its properties.

System_CAPS_pubclassAvailabilityReplicaCollection

Represents the AvailabilityReplicaCollection objects.

System_CAPS_pubclassBackup

The Backup object provides programmatic access to Microsoft SQL Server backup operations.

System_CAPS_pubclassBackupDevice

The BackupDevice object provides programmatic access to SQL Server backup devices.

System_CAPS_pubclassBackupDeviceCollection

The BackupDeviceCollection class represents a collection of BackupDevice objects that represent all the backup devices on an instance of SQL Server.

System_CAPS_pubclassBackupDeviceItem

The BackupDeviceItem object provides programmatic access to named SQL Server backup devices.

System_CAPS_pubclassBackupDeviceList

The BackupDeviceList object provides programmatic access to a list backup devices.

System_CAPS_pubclassBackupEncryptionOptions

Specifies backup encryption option.

System_CAPS_pubclassBackupMedia

Represents a backup media.

System_CAPS_pubclassBackupMediaSet

Represents a Backup media set.

System_CAPS_pubclassBackupRestoreBase

The BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.

System_CAPS_pubclassBackupSet

Represents the backup set.

System_CAPS_pubclassBackupSetCollection

Represents a collection of backup set.

System_CAPS_pubclassCertificate

The Certificate object represents a SQL Server certificate.

System_CAPS_pubclassCertificateCollection

The CertificateCollection class represents a collection of Certificate objects that represent all the certificates on an instance of SQL Server.

System_CAPS_pubclassCertificateEvents

The CertificateEvents object represents the settings that are required for SQL Server Certificate event notification.

System_CAPS_pubclassCheck

The Check object represents a SQL Server check constraint. 

System_CAPS_pubclassCheckCollection

The CheckCollection class represents a collection of Check objects that represent all the check constraints defined on the parent object.

System_CAPS_pubclassCollectionNotAvailableException

The CollectionNotAvailableException class is an exception that is raised when an attempt is made to retrieve a collection that is not available.

System_CAPS_pubclassColumn

The Column object represents a SQL Server column.

System_CAPS_pubclassColumnCollection

The ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.

System_CAPS_pubclassColumnEncryptionKey

System_CAPS_pubclassColumnEncryptionKeyCollection

System_CAPS_pubclassColumnEncryptionKeyValue

System_CAPS_pubclassColumnEncryptionKeyValueCollection

System_CAPS_pubclassColumnEncryptionKeyValueCollectionBase

System_CAPS_pubclassColumnMasterKey

System_CAPS_pubclassColumnMasterKeyCollection

System_CAPS_pubclassConfigProperty

The ConfigProperty object contains information pertaining to a Microsoft SQL Server configuration option, such as maximum, minimum, current, and new values.

System_CAPS_pubclassConfigPropertyCollection

The ConfigPropertyCollection class represents a collection of ConfigProperty objects that represent all the configuration properties defined on the instance of SQL Server.

System_CAPS_pubclassConfiguration

Represents the Configuration class that contains the configuration information for the instance of SQL Server.

System_CAPS_pubclassConfigurationBase

The ConfigurationBase class is a base class that represents configuration information for the instance of SQL Server.

System_CAPS_pubclassCpu

The Cpu class contains information about one CPU on an instance of SQL Server.

System_CAPS_pubclassCpuCollection

The CpuCollection class represents a collection of Cpu objects that represent all the CPUs that are defined on an instance of SQL Server.

System_CAPS_pubclassCreateRestorePlanEventArgs

Provides data for the create restore plan event.

System_CAPS_pubclassCredential

The Credential object represents a Microsoft SQL Server credential.

System_CAPS_pubclassCredentialCollection

The CredentialCollection class represents a collection of Credential objects that represent all the credentials defined on the instance of Microsoft SQL Server.

System_CAPS_pubclassCryptographicProvider

The CryptographicProvider object represents a SQL Server cryptographic provider.

System_CAPS_pubclassCryptographicProviderCollection

A collection of type CryptographicProviderCollection that represents a collection of CryptographicProviderr objects.

System_CAPS_pubclassDatabase

Represents an SQL Server database.

System_CAPS_pubclassDatabaseActiveDirectory

Obsolete.The DatabaseActiveDirectory object provides programmatic access to the Active Directory settings for a database.

System_CAPS_pubclassDatabaseAdapter

Database Adapter type to be used as a management facet.

System_CAPS_pubclassDatabaseAdapterBase

Represents a database adapter base.

System_CAPS_pubclassDatabaseAuditSpecification

The DatabaseAuditSpecification object represents an auditable event on the database.

System_CAPS_pubclassDatabaseAuditSpecificationCollection

The DatabaseAuditSpecificationCollection class represents a collection of DatabaseAuditSpecification objects that represent all the audit specifications defined on the database.

System_CAPS_pubclassDatabaseAuditSpecificationExtender

Adds methods and properties to the DatabaseAuditSpecification object.

System_CAPS_pubclassDatabaseCollection

The DatabaseCollection class represents a collection of Database objects that represent all the databases defined on the instance of SQL Server.

System_CAPS_pubclassDatabaseDdlTrigger

The DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.

System_CAPS_pubclassDatabaseDdlTriggerCollection

The DatabaseDdlTriggerCollection class represents a collection of DatabaseDdlTrigger objects that represent all the database data definition language (DDL) triggers defined on a table.

System_CAPS_pubclassDatabaseDdlTriggerEvent

Represents the DatabaseDdlTriggerEvent object represents the SQL Server database DDL trigger events that can be included in a database DDL trigger event set.

System_CAPS_pubclassDatabaseDdlTriggerEventSet

The DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events. 

System_CAPS_pubclassDatabaseEncryptionKey

Creates a database encryption key.

System_CAPS_pubclassDatabaseEncryptionKeyExtender

Extends the database encryption key class.

System_CAPS_pubclassDatabaseEvent

The DatabaseEvent object represents the SQL Server database events that can be included in a database event set.

System_CAPS_pubclassDatabaseEventArgs

The DatabaseEventArgs object represents the arguments passed by the event raised by the database.

System_CAPS_pubclassDatabaseEvents

The DatabaseEvents object represents the settings required for Microsoft SQL Server database event notification.

System_CAPS_pubclassDatabaseEventSet

The DatabaseEventSet object represents a SQL Server set of database events. 

System_CAPS_pubclassDatabaseFile

The DatabaseFile object is a base class used in the construction of DataFile objects and LogFile objects.

System_CAPS_pubclassDatabaseFileMappingsDictionary

This class, which is inherited from Dictionary, maps database file paths from the source server to the corresponding target server location that the user specifies.

System_CAPS_pubclassDatabaseMaintenanceAdapter

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

System_CAPS_pubclassDatabaseMapping

The DatabaseMapping object represents a SQL Server database mapping.

System_CAPS_pubclassDatabaseMirroringPayload

The DatabaseMirroringPayload object represents database mirroring payload settings.

System_CAPS_pubclassDatabaseOptions

The DatabaseOptions object represents SQL Server database options.

System_CAPS_pubclassDatabasePerformanceAdapter

The Database Performance facet implements logical properties relevant to database performance management.

System_CAPS_pubclassDatabasePermission

The DatabasePermission object represents a SQL Server database permission. The database permission can be added to a database permission set, and then granted, revoked, or denied to a user.

System_CAPS_pubclassDatabasePermissionInfo

The DatabasePermissionInfo object represents information about a SQL Server database permission.

System_CAPS_pubclassDatabasePermissionSet

The DatabasePermissionSet object represents a SQL Server set of database permissions.

System_CAPS_pubclassDatabaseReplicaState

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.

System_CAPS_pubclassDatabaseReplicaStateCollection

Represents a collection of objects that represent all the database replica state defined on the parent database.

System_CAPS_pubclassDatabaseReplicaStateCollectionBase

Represents a collection of DatabaseReplicaState objects that represent all the database replica states defined on the parent database.

System_CAPS_pubclassDatabaseRestorePlanner

Represents the Database Restore Planner.

System_CAPS_pubclassDatabaseRole

The DatabaseRole object represents a SQL Server database security role.

System_CAPS_pubclassDatabaseRoleCollection

The DatabaseRoleCollection class represents a collection of DatabaseRole objects that represent all the database roles defined on the parent database.

System_CAPS_pubclassDatabaseScopedCredential

System_CAPS_pubclassDatabaseScopedCredentialCollection

System_CAPS_pubclassDatabaseSecurityAdapter

Includes properties and methods that are used to expose the Database Security facet.

System_CAPS_pubclassDatabaseSnapshotExtender

Adds methods and properties to the DatabaseSnapshot object.

System_CAPS_pubclassDataFile

The DataFile object represents a SQL Server data file.

System_CAPS_pubclassDataFileCollection

The DataFileCollection class represents a collection of DataFile objects that represent all the data files defined on the parent object.

System_CAPS_pubclassDataTransferBase

Represents the data transfer base.

System_CAPS_pubclassDataType

The DataType object represents a SQL Server data type.

System_CAPS_pubclassDdlTriggerBase

The DdlTriggerBase is a base class that is inherited by the DatabaseDdlTrigger object. This represents a SQL Server database data definition language (DDL) trigger.

System_CAPS_pubclassDefault

The Default object represents a SQL Server default.

System_CAPS_pubclassDefaultCollection

The DefaultCollection class represents a collection of Default objects.

System_CAPS_pubclassDefaultConstraint

The DefaultConstraint object represents a SQL Server default constraint.

System_CAPS_pubclassDefaultLanguage

Represents the list of all the default languages supported by Microsoft Search service.

System_CAPS_pubclassDefaultRuleBase

The DefaultRuleBase class is a base class that is inherited by the Rule class and the Default class.

System_CAPS_pubclassDependencyCollection

The DependencyCollection class represents a collection of T:Microsoft.SqlServer.Management.Smo.Dependency objects that are used to derive the node classes in SMO scripting operations.

System_CAPS_pubclassDependencyCollectionNode

The DependencyCollectionNode class represents a node in the dependency collection that is derived during scripting operations.

System_CAPS_pubclassDependencyNode

The DependencyNode class represents a node that is defined by a URN address.

System_CAPS_pubclassDependencyTree

The DependencyTree object represents a tree structure that contains SQL Server objects and their hierarchical relationships to each other.

System_CAPS_pubclassDependencyTreeNode

The DependencyTreeNode class represents the child and sibling SQL Server objects within a DependencyTree object hierarchy.

System_CAPS_pubclassDependencyWalker

The DependencyWalker object is a tool to perform scripting operations that involve dependencies such as identifying dependent relationships. The tool and converts this output to a list.

System_CAPS_pubclassEndpoint

The Endpoint class represents an endpoint service that can listen natively for requests.

System_CAPS_pubclassEndpointCollection

The EndpointCollection class represents a collection of Endpoint objects that represent all the HTTP endpoints.

System_CAPS_pubclassEndpointPayload

The EndpointPayload object represents an endpoint payload.

System_CAPS_pubclassEndpointProtocol

The EndpointProtocol object represents an HTTP endpoint protocol.

System_CAPS_pubclassEnumToDisplayNameConverter

System_CAPS_pubclassEventProperty

The EventProperty class represents a property of an event.

System_CAPS_pubclassEventPropertyCollection

The EventPropertyCollection object represents the properties of event objects.

System_CAPS_pubclassEventSetBase

The EventSetBase class is a base class that is used to derive the event set objects.

System_CAPS_pubclassExecutionManager

System_CAPS_pubclassExtendedProperty

The ExtendedProperty object represents the extended properties that are defined for any object that has an ExtendedProperties collection property.

System_CAPS_pubclassExtendedPropertyCollection

The ExtendedPropertyCollection class represents a collection of ExtendedPropertyCollectionobjects that represent all the extended properties.

System_CAPS_pubclassExtendedStoredProcedure

The ExtendedStoredProcedure object represents an extended stored procedure on the instance of Microsoft SQL Server.

System_CAPS_pubclassExtendedStoredProcedureCollection

The ExtendedStoredProcedureCollection class represents a collection of ExtendedStoredProcedure objects that represent all the extended stored procedures defined on the parent database.

System_CAPS_pubclassExternalDataSource

System_CAPS_pubclassExternalDataSourceCollection

System_CAPS_pubclassExternalDataSourceTypeConverter

System_CAPS_pubclassExternalFileFormat

System_CAPS_pubclassExternalFileFormatCollection

System_CAPS_pubclassExternalFileFormatTypeConverter

System_CAPS_pubclassExternalTableDistributionConverter

System_CAPS_pubclassExternalTableRejectTypeConverter

System_CAPS_pubclassFailedOperationException

The FailedOperationException class represents the exception raised when an operation fails. Failed database operations include CREATE, DROP, ALTER, SCRIPT, REFRESH, RENAME. This exception can also be raised when some of the public methods in SMO fail.

System_CAPS_pubclassFederation

Represents a federation object on the SQL Azure database.

System_CAPS_pubclassFederationCollection

Represents a collection of federation objects.

System_CAPS_pubclassFileGroup

The FileGroup object represents a SQL Server file group. For more information about file groups, see Using Filegroups and Files to Store Data.

System_CAPS_pubclassFileGroupCollection

The FileGroupCollection class represents a collection of FileGroup objects that represent all the filegroups defined on the parent database.

System_CAPS_pubclassForeignKey

The ForeignKey object represents a SQL Server foreign key.

System_CAPS_pubclassForeignKeyCollection

The ForeignKeyCollection class represents a collection of ForeignKey objects that represent all the foreign keys defined on the parent object.

System_CAPS_pubclassForeignKeyColumn

The ForeignKeyColumn object represents a SQL Server foreign key column.

System_CAPS_pubclassForeignKeyColumnCollection

The ForeignKeyColumnCollection class represents a collection of ForeignKeyColumn objects that represent all the foreign key columns defined on the parent object.

System_CAPS_pubclassFrequencyPair

The FrequencyPair object is a utility that measures frequency by storing count and duration information.

System_CAPS_pubclassFullTextCatalog

The FullTextCatalog object represents a Microsoft Search full-text catalog.

System_CAPS_pubclassFullTextCatalogCollection

The FullTextCatalogCollection class represents a collection of FullTextCatalog objects that represent all the full-text catalogs defined on the parent object.

System_CAPS_pubclassFullTextIndex

The FullTextIndex object represents a Microsoft Search full-text index.

System_CAPS_pubclassFullTextIndexColumn

The FullTextIndexColumn object represents a Microsoft Search full-text index column. 

System_CAPS_pubclassFullTextIndexColumnCollection

The FullTextIndexColumnCollection class represents a collection of FullTextIndexColumn objects that represent all the full-text index columns defined on the parent object.

System_CAPS_pubclassFullTextService

The FullTextService object allows programmatic access to the Microsoft Search full-text settings.

System_CAPS_pubclassFullTextStopList

The FullTextStopList object represents a full-text stop list.

System_CAPS_pubclassFullTextStopListCollection

The FullTextStopListCollection class represents a collection of FullTextStopList objects that represent all the full-text stop lists that are defined on the parent database.

System_CAPS_pubclassHttpProtocol

The HttpProtocol object represents an HTTP protocol on an instance of Microsoft SQL Server.

System_CAPS_pubclassBackupMediaSet.IncompleteBackupMediaSetException

The exception that is thrown when the backup media set is not complete.

System_CAPS_pubclassIndex

The Index object represents a SQL Server index.

System_CAPS_pubclassIndexCollection

The IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of SQL Server.

System_CAPS_pubclassIndexedColumn

The IndexedColumn object represents a SQL Server column that is participating in an index. 

System_CAPS_pubclassIndexedColumnCollection

The IndexedColumnCollection class represents a collection of IndexedColumn objects that represent all the indexed columns defined on the instance of SQL Server.

System_CAPS_pubclassIndexedXmlPath

Represents an indexed XML path.

System_CAPS_pubclassIndexedXmlPathCollection

Represents the collection of indexed XML paths.

System_CAPS_pubclassIndexedXmlPathNamespace

Represents the indexed Xml path namespace.

System_CAPS_pubclassIndexedXmlPathNamespaceCollection

Represents a collection of indexed XML path namespace.

System_CAPS_pubclassIndexEvents

The IndexEvents object represents the settings that are required for SQL Server index event notification.

System_CAPS_pubclassInformation

The Information class contains nonconfigurable information about the instance of SQL Server. These include system information and options that are set during Setup, such as the collation.

System_CAPS_pubclassInternalSmoErrorException

The InternalSmoErrorException class represents the exception raised when an error occurs during the internal phase of a SMO operation.

System_CAPS_pubclassInvalidRestorePlanException

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

System_CAPS_pubclassInvalidScriptingOptionException

The InvalidScriptingOptionException represents an exception due to an invalid scripting option.

System_CAPS_pubclassInvalidSmoOperationException

The InvalidSmoOperationException class represents the exception raised when an SMO operation is not valid.

System_CAPS_pubclassInvalidVersionSmoOperationException

The InvalidVersionSmoOperationException class represents the exception raised when the version is not valid on an SMO operation.

System_CAPS_pubclassJobScheduleCollectionBase

The JobScheduleCollectionBase class represents a base class that is used in the construction of the JobScheduleCollection class.

System_CAPS_pubclassLanguage

A Language object represents a language supported by SQL Server. The SQL Server language determines the date and time formats and the language in which the system messages are displayed.

System_CAPS_pubclassLanguageCollection

The LanguageCollection class represents a collection of Language objects that represent all the languages which are defined on the instance of SQL Server.

System_CAPS_pubclassLinkedServer

A LinkedServer object represents a database system other than SQL Server and is linked to the current instance of SQL Server by using an OLE DB driver.

System_CAPS_pubclassLinkedServerCollection

The LinkedServerCollection class represents a collection of LinkedServer objects that represent all the linked servers registered on the instance of SQL Server.

System_CAPS_pubclassLinkedServerLogin

The LinkedServerLogin object represents a SQL Server logon account that has permission to connect to the linked server.

System_CAPS_pubclassLinkedServerLoginCollection

The LinkedServerLoginCollection class represents a collection of LinkedServerLogin objects that represent all the linked server logins defined on the linked server.

System_CAPS_pubclassLogFile

The LogFile object represents a SQL Server log file.

System_CAPS_pubclassLogFileCollection

The LogFileCollection class represents a collection of LogFile objects that represent all the log files defined on the instance of Microsoft SQL Server.

System_CAPS_pubclassLogin

The Login object represents a SQL Server login account that has been granted access to the instance of SQL Server through Windows Authentication or SQL Server Authentication.

System_CAPS_pubclassLoginCollection

The LoginCollection class represents a collection of Login objects that represent all the login accounts defined on the instance of SQL Server.

System_CAPS_pubclassLoginEvents

The LoginEvents object represents the settings required for SQL Server login event notification.

System_CAPS_pubclassMasterKey

The MasterKey object represents a SQL Server database master key.

System_CAPS_pubclassMessageCollectionBase

The MessageCollectionBase class is a base class that is used in the construction of message collection classes.

System_CAPS_pubclassMessageObjectBase

The MessageObjectBase class is a base class that is inherited by message classes.

System_CAPS_pubclassMissingObjectException

The MissingObjectException class represents the exception raised when an object is missing.

System_CAPS_pubclassNamedSmoObject

Represents the NamedSmoObject object represents a named SMO object.

System_CAPS_pubclassNextRestoreEventArgs

Represents the next restore event arguments.

System_CAPS_pubclassNumaNode

The NumaNode object represents the settings for a NUMA node on an instance of SQL Server.

System_CAPS_pubclassNumaNodeCollection

The NumaNodeCollection object contains information about one NUMA node on an instance of SQL Server.

System_CAPS_pubclassNumberedObjectCollectionBase

The NumberedObjectCollectionBase class is a base class that represents common functionality for collections of numbered objects, such as the NumberedStoredProcedure object.

System_CAPS_pubclassNumberedStoredProcedure

The NumberedStoredProcedure class represents a Microsoft SQL Server numbered stored procedure.

System_CAPS_pubclassNumberedStoredProcedureCollection

The NumberedStoredProcedureCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on a table.

System_CAPS_pubclassNumberedStoredProcedureParameter

The NumberedStoredProcedureParameter object represents a SQL Server numbered stored procedure parameter.

System_CAPS_pubclassNumberedStoredProcedureParameterCollection

The NumberedStoredProcedureParameterCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on the parent object.

System_CAPS_pubclassObjectAlteredEventArgs

The ObjectAlteredEventArgs object represents the arguments that are passed by the event that is raised when an object is altered.

System_CAPS_pubclassObjectCreatedEventArgs

The ObjectCreatedEventArgs object represents the arguments that are passed by the event that is raised when an object is created.

System_CAPS_pubclassObjectDroppedEventArgs

The ObjectDroppedEventArgs object represents the arguments that are passed by the event that is raised when an object is dropped.

System_CAPS_pubclassObjectEvent

The ObjectEvent object represents the of SQL Server object events that can be included in an object event set.

System_CAPS_pubclassObjectEventSet

The ObjectEventSet object represents a SQL Server set of object events.

System_CAPS_pubclassObjectPermission

The ObjectPermission object represents a SQL Server object permission.

System_CAPS_pubclassObjectPermissionInfo

The ObjectPermissionInfo object represents information about a SQL Server object permission.

System_CAPS_pubclassObjectPermissionSet

The ObjectPermissionSet object represents a set of object permissions in Microsoft SQL Server.

System_CAPS_pubclassObjectRenamedEventArgs

The ObjectRenamedEventArgs object represents the arguments passed by the event raised when an object is renamed.

System_CAPS_pubclassOleDbProviderSettings

Represents the settings for an SQL Server OLE DB provider.

System_CAPS_pubclassOleDbProviderSettingsCollection

The OleDbProviderSettingsCollection class represents a collection of OleDbProviderSettings objects that represent all the OLE DB provider settings defined on the linked server.

System_CAPS_pubclassOrderColumn

OrderColumn points to a column with an order that is specified within a table-valued function that was created by using CREATE FUNCTION and the ORDER BY clause.

System_CAPS_pubclassOrderColumnCollection

Represents a collection of OrderColumn.

System_CAPS_pubclassPageRestorePlanner

Represents the page restore planner.

System_CAPS_pubclassParameter

The Parameter class represents a parameter. It is a base class that is inherited by the StoredProcedureParameter class and the UserDefinedFunctionParameter class and contains common features of both classes.

System_CAPS_pubclassParameterBase

The ParameterBase class is a base class that is inherited by the Parameter class and the UserDefinedAggregate class. It contains common features of both classes.

System_CAPS_pubclassParameterCollectionBase

The ParameterCollectionBase class is a base class that is used in the construction of parameter collection classes.

System_CAPS_pubclassPartitionFunction

The PartitionFunction object provides programmatic access to partition functions.

System_CAPS_pubclassPartitionFunctionCollection

The PartitionFunctionCollection class represents a collection of PartitionFunction objects that represent all the partition functions defined on the instance of SQL Server.

System_CAPS_pubclassPartitionFunctionEvents

The PartitionFunctionEvents object represents the settings required for SQL Server partition function event notification.

System_CAPS_pubclassPartitionFunctionParameter

The PartitionFunctionParameter object provides programmatic access to partition function parameters.

System_CAPS_pubclassPartitionFunctionParameterCollection

The PartitionFunctionParameterCollection class represents a collection of PartitionFunctionParameter objects that represent all the partition function parameters defined on the partition function.

System_CAPS_pubclassPartitionNumberedObjectCollectionBase

The PartitionNumberedObjectCollectionBase is a base class that is inherited by the PhysicalPartitionCollection class.

System_CAPS_pubclassPartitionScheme

The PartitionScheme object provides programmatic access to partition schemes.

System_CAPS_pubclassPartitionSchemeCollection

The PartitionSchemeCollection class represents a collection of PartitionScheme objects that represent all the partition schemes defined on the instance of SQL Server.

System_CAPS_pubclassPartitionSchemeEvents

The PartitionSchemeEvents object represents the settings required for Microsoft SQL Server partition scheme event notification.

System_CAPS_pubclassPartitionSchemeParameter

The PartitionSchemeParameter object provides programmatic access to partition scheme parameters.

System_CAPS_pubclassPartitionSchemeParameterCollection

The PartitionSchemeParameterCollection class represents a collection of PartitionSchemeParameter objects that represent all the partition scheme parameters defined on the partition scheme.

System_CAPS_pubclassPathWrapper

Represents a path wrapper.

System_CAPS_pubclassPayload

The Payload object represents a SQL Server HTTP endpoint payload.

System_CAPS_pubclassPercentCompleteEventArgs

Represents the arguments passed by the event raised when a process reaches a percent complete marker.

System_CAPS_pubclassPerformanceCounters

A PerformanceCounters object represents a performance counter that is used to trace the performance of the instance of SQL Server.

System_CAPS_pubclassPermissionInfo

The PermissionInfo class represents information regarding granted or denied privileges.

System_CAPS_pubclassPermissionSetBase

The PermissionSetBase class is a base class that is inherited by permission set classes.

System_CAPS_pubclassPhysicalPartition

The PhysicalPartition object represents the physical partition where the data and meta data is stored for a SQL Server object.

System_CAPS_pubclassPhysicalPartitionCollection

The PhysicalPartitionCollection class represents a collection of PhysicalPartition objects that represent all the physical partitions that are defined on an object.

System_CAPS_pubclassPlanGuide

Creates a plan guide object: PlanGuide

System_CAPS_pubclassPlanGuideCollection

Represents a collection of plan guide objects.

System_CAPS_pubclassPlanGuideExtender

Extends the Property set for a Plan Guide

System_CAPS_pubclassProgressReportEventArgs

The ProgressReportEventArgs object provides programmatic access to the arguments used to report the progress of an operation that works through an object hierarchy, such as discovering dependencies in scripting operations.

System_CAPS_pubclassProperty

The Property object provides programmatic access to the properties of all the SMO objects.

System_CAPS_pubclassPropertyCannotBeRetrievedException

The PropertyCannotBeRetrievedException class represents the exception raised when a property cannot be retrieved.

System_CAPS_pubclassPropertyCollection

The PropertyCollection class represents a collection of Property objects that represent all the properties defined on the parent object.

System_CAPS_pubclassPropertyNotSetException

The PropertyNotSetException class represents the exception that is raised when a property value has not been set.

System_CAPS_pubclassPropertyReadOnlyException

The PropertyReadOnlyException class represents the exception that is raised when an attempt is made to set a read-only property.

System_CAPS_pubclassPropertyTypeMismatchException

The PropertyTypeMismatchException class represents the exception raised when an attempt is made to set the property with a value that has the incorrect data type.

System_CAPS_pubclassPropertyWriteException

The PropertyWriteException class represents the exception that is raised when an error occurs when setting the value of a property.

System_CAPS_pubclassProtocol

The Protocol object provides programmatic access to the protocols supported by SQL Server.

System_CAPS_pubclassQueryStoreOptions

System_CAPS_pubclassRelocateFile

The RelocateFile object is a programmatic tool that lets a file be relocated.

System_CAPS_pubclassRemoteDataArchiveMigrationStatusReport

System_CAPS_pubclassRemoteDatabaseMigrationStatistics

System_CAPS_pubclassRemoteTableMigrationStatistics

System_CAPS_pubclassResourceGovernor

Represents ResourceGovernor class.

System_CAPS_pubclassResourcePool

Resource Pool Class

System_CAPS_pubclassResourcePoolAffinityInfo

Represents information about the resource pool affinity.

System_CAPS_pubclassResourcePoolCollection

Represents a collection of Resource Pools.

System_CAPS_pubclassRestore

The Restore object provides programmatic access to restore operations.

System_CAPS_pubclassRestoreOptions

Represents the restore options.

System_CAPS_pubclassRestorePlan

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

System_CAPS_pubclassRule

The Rule object provides programmatic access to a SQL Server rule.

System_CAPS_pubclassRuleCollection

The RuleCollection class represents a collection of Rule objects that represent all the rules defined on the instance of SQL Server.

System_CAPS_pubclassScheduler

Represents the scheduler associated with the Server Management Object.

System_CAPS_pubclassSchedulerCollection

Represents a collection of scheduler.

System_CAPS_pubclassSchema

The Schema object represents an ownership context for a SQL Server database object.

System_CAPS_pubclassSchemaCollection

The SchemaCollection class represents a collection of Schema objects that represent all the schemas on the referenced database.

System_CAPS_pubclassSchemaCollectionBase

The SchemaCollectionBase class is a base class that is inherited by the SchemaCollection class.

System_CAPS_pubclassSchemaCustomResolver

Represents a diagram of a COM-based resolver.

System_CAPS_pubclassSchemaEvents

The SchemaEvents object represents the settings required for SQL Server schema event notification.

System_CAPS_pubclassScripter

The Scripter object is the overall, top-level object for managing scripting operations.

System_CAPS_pubclassScriptingErrorEventArgs

The ScriptingErrorEventArgs object provides programmatic access to the arguments used to report the errors that occur during scripting operations.

System_CAPS_pubclassScriptingOptions

The ScriptingOptions object provides programmatic options to the options that can be set for scripting operations.

System_CAPS_pubclassScriptNameObjectBase

Represents a base class inherited by classes that can use an alternative name used in scripting operations.

System_CAPS_pubclassScriptOption

The ScriptOption object represents the SQL Server script options that can be included in scripting options that are set by using the ScriptingOptions object.

System_CAPS_pubclassScriptSchemaObjectBase

The ScriptSchemaObjectBase is a base class that is inherited by classes that can use an alternative name used in scripting operations.

System_CAPS_pubclassScriptWriterException

Represents an exception which occurred when trying to write a script.

System_CAPS_pubclassSearchProperty

The SearchProperty object represents a search property on a SQL Server database object.

System_CAPS_pubclassSearchPropertyCollection

The SearchPropertyCollection class represents a collection of search properties on a SQL Server database object.

System_CAPS_pubclassSearchPropertyList
System_CAPS_pubclassSearchPropertyListCollection

The SearchPropertyListCollection class represents a collection of type SearchPropertyList associated with a database.

System_CAPS_pubclassSecurityPolicy

System_CAPS_pubclassSecurityPolicyCollection

System_CAPS_pubclassSecurityPredicate

System_CAPS_pubclassSecurityPredicateCollection

System_CAPS_pubclassSecurityPredicateCollectionBase

System_CAPS_pubclassSecurityPredicateOperationConverter

System_CAPS_pubclassSecurityPredicateTypeConverter

System_CAPS_pubclassSequence

This class represents the SQL Server Sequence. A sequence is a user-defined schema bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of numeric values is generated in an ascending or descending order at a defined interval and can be configured to restart (cycle) when exhausted. Sequences, unlike identity columns, are not associated with specific tables. Applications refer to a sequence object to retrieve its next value. The relationship between sequences and tables is controlled by the application. User applications can reference a sequence object and coordinate the values across multiple rows and tables.

System_CAPS_pubclassSequenceCollection

The SequenceCollection class represents a collection of Sequence objects that represent all the Sequences on the referenced database.

System_CAPS_pubclassSequenceEvents

The SequenceEvents object represents the settings required for Microsoft SQL Server Sequence event notification.

System_CAPS_pubclassSequenceExtender

Contains additional functionality for the Sequence object.

System_CAPS_pubclassServer

The Server object represents an instance of SQL Server.

System_CAPS_pubclassServerActiveDirectory

Obsolete.The ServerActiveDirectory object provides programmatic access to the Active Directory functionality.

System_CAPS_pubclassServerAdapter

This class aggregates otherwise hidden server properties.

System_CAPS_pubclassServerAdapterBase

A ServerAdapterBase object is a base class that is used in the construction of the ServerAdapter class.

System_CAPS_pubclassServerAuditSpecification

The ServerAuditSpecification object represents an auditable event on the instance of SQL Server.

System_CAPS_pubclassServerAuditSpecificationCollection

The ServerAuditSpecificationCollection class represents a collection of ServerAuditSpecification objects that represent all the audit specifications defined on the server.

System_CAPS_pubclassServerAuditSpecificationExtender

Adds methods and properties to the ServerAuditSpecification object.

System_CAPS_pubclassServerConfigurationAdapter

Exposes methods to refresh and alter server configuration properties.

System_CAPS_pubclassServerDdlTrigger

The ServerDdlTrigger object represents a SQL Server data definition language (DDL) trigger.

System_CAPS_pubclassServerDdlTriggerCollection

The ServerDdlTriggerCollection class represents a collection of ServerDdlTrigger objects that represent all the server data definition language (DDL) triggers defined on a table.

System_CAPS_pubclassServerDdlTriggerEvent

The ServerDdlTriggerEvent object represents the Microsoft SQL Server data definition language (DDL) trigger events that can be included in a server DDL trigger event set.

System_CAPS_pubclassServerDdlTriggerEventSet

The ServerDdlTriggerEventSet object represents a set of SQL Server server data definition language (DDL) trigger events.

System_CAPS_pubclassServerEvent

The ServerEvent object represents the SQL Server server events that can be included in a server event set.

System_CAPS_pubclassServerEventArgs

The ServerEventArgs object provides programmatic access to the arguments that are used to report all types of events that occur on an instance of SQL Server.

System_CAPS_pubclassServerEvents

The ServerEvents object represents the settings required for SQL Server server-level event notification.

System_CAPS_pubclassServerEventSet

The ServerEventSet object represents a set of server events on an instance of SQL Server.

System_CAPS_pubclassServerPermission

The ServerPermission object represents a SQL Server server-level permission.

System_CAPS_pubclassServerPermissionInfo

The ServerPermissionInfo object represents information about a SQL Server server-level permission.

System_CAPS_pubclassServerPermissionSet

The ServerPermissionSet object represents a set of server permissions.

System_CAPS_pubclassServerProxyAccount

The ServerProxyAccount class represents the implementation of a proxy account on an instance of SQL Server. The ProxyAccount object allows for impersonation of job step execution. Created by the system administrator, it can be further be assigned to a login or a server role or a database role and one of the subsystems, except for Transact-SQL.

System_CAPS_pubclassServerRole

The ServerRole object represents a Microsoft SQL Server security role.

System_CAPS_pubclassServerRoleCollection

The ServerRoleCollection class represents a collection of ServerRole objects that represent all the server roles that are defined on a table.

System_CAPS_pubclassServerRoleEvents

The ServerRoleEvents object represents the settings required for Microsoft SQL Server ServerRole event notification.

System_CAPS_pubclassServerRoleExtender

Adds methods and properties to the ServerRole object.

System_CAPS_pubclassServerSecurityAdapter

A security facet that extends ServerAdapterBase.

System_CAPS_pubclassServerSelectionAdapter

Provides selection options for an instance of SQL Server.

System_CAPS_pubclassServerSetupAdapter

A ServerSetupAdapter object represents a server setup adapter.

System_CAPS_pubclassServerSurfaceAreaAdapter

A ServerSurfaceAreaAdapter object represents a server surface area adapter.

System_CAPS_pubclassServerTraceEvent

The ServerTraceEvent object represents the SQL Server server trace events that can be included in a server trace event set.

System_CAPS_pubclassServerTraceEventSet

The ServerTraceEventSet object represents a set server trace events.

System_CAPS_pubclassServiceBrokerPayload

The ServiceBrokerPayload object represents a SQL Server Service Broker payload.

System_CAPS_pubclassServiceMasterKey

The ServiceMasterKey object represents a Microsoft SQL Server service master key.

System_CAPS_pubclassServiceQueueEvent

The ServiceQueueEvent object represents the Service Broker service queue events that can be included in a service queue event set.

System_CAPS_pubclassServiceQueueEventSet

The ServiceQueueEventSet object represents a set of SQL Server service queue events.

System_CAPS_pubclassServiceRequestException

The ServiceRequestException class represents the exception that is raised when an error occurs during a service request.

System_CAPS_pubclassSettings

The Settings object represents a group of configurable settings on the instance of SQL Server.

System_CAPS_pubclassSfcDependencyException

The SfcDependencyException class represents an exception thrown by an SFC dependency operation fails.

System_CAPS_pubclassSimpleObjectCollectionBase

The SimpleObjectCollectionBase class is a base class that is used in the construction of collection objects.

System_CAPS_pubclassSmartAdmin

Represents a class that handles Altering and Scripting the current state of smart admin.

System_CAPS_pubclassSmartAdminState

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

System_CAPS_pubclassSmoApplication

The SmoApplication class represents an SMO application with respect to event management.

System_CAPS_pubclassSmoCollectionBase

Represents a base class that is used in the construction of SMO collection classes and contains members that are common to them.

System_CAPS_pubclassSmoDmfAdapter
System_CAPS_pubclassSmoEventArgs

The SmoEventArgs object provides programmatic access to the arguments used to report the events that occur in SMO applications.

System_CAPS_pubclassSmoException

The SmoException class represents the exception that is raised when an error occurs during an SMO operation.

System_CAPS_pubclassSmoObjectBase

The SmoObjectBase is a base class that is inherited by the SqlSmoObject class.

System_CAPS_pubclassSmoObjectExtender<T>

Represents the SmoObjectExtender<T> class that adds methods and properties to an SqlSmoObject class instance.

System_CAPS_pubclassSoapMethodCollectionBase

The SoapMethodCollectionBase class is a base class that is inherited by SOAP method collection objects and provides programmatic access to the collection of SOAP methods that exist in the SOAP configuration.

System_CAPS_pubclassSoapMethodObject

The SoapMethodObject class provides programmatic access to the referenced SOAP method.

System_CAPS_pubclassSoapPayload

The SoapPayload object represents a SQL Server SOAP payload.

System_CAPS_pubclassSoapPayloadMethod

The SoapPayloadMethod class represents a SOAP payload method for the referenced HTTP endpoint.

System_CAPS_pubclassSoapPayloadMethodCollection

The SoapPayloadMethodCollection class represents a collection of SoapPayloadMethod objects that represent all the SOAP payload methods defined on a table.

System_CAPS_pubclassSortedListCollectionBase

The SortedListCollectionBase class is a base class that is used in the construction of sorted list collection classes.

System_CAPS_pubclassSqlAssembly

The SqlAssembly class represents an assembly in the Microsoft .NET environment.

System_CAPS_pubclassSqlAssemblyCollection

The SqlAssemblyCollection class represents a collection of SqlAssembly objects that represent all the assemblies defined on a table.

System_CAPS_pubclassSqlAssemblyEvent

The SqlAssemblyEvent object represents the SQL Server assembly events that can be included in an assembly event set.

System_CAPS_pubclassSqlAssemblyEvents

The SqlAssemblyEvents object represents the settings that are required for SQL Server assembly event notification.

System_CAPS_pubclassSqlAssemblyEventSet

The SqlAssemblyEventSet object represents a set of assembly events.

System_CAPS_pubclassSqlAssemblyFile

The SqlAssemblyFile object represents an assembly file that stores an assembly.

System_CAPS_pubclassSqlAssemblyFileCollection

The SqlAssemblyFileCollection class represents a collection of SqlAssemblyFile objects that represent all the assembly files that are defined on a table.

System_CAPS_pubclassSqlPropertyCollection

The SqlPropertyCollection class is an abstract class that is used in the management of object properties.

System_CAPS_pubclassSqlPropertyInfo

The SqlPropertyInfo class is an abstract class used to store information about properties.

System_CAPS_pubclassSqlServerRegistrations

Obsolete.Represents registered instances of SQL Server.

System_CAPS_pubclassSqlSmoObject

The SqlSmoObject object represents all SQL Server objects.

System_CAPS_pubclassStatistic

The Statistic class represents a SQL Server statistic counter.

System_CAPS_pubclassStatisticCollection

The StatisticCollection class represents a collection of Statistic objects that represent all the statistic counters defined on the table or view.

System_CAPS_pubclassStatisticColumn

The StatisticColumn object represents a column defined in a SQL Server statistics counter.

System_CAPS_pubclassStatisticColumnCollection

The StatisticColumnCollection class represents a collection of StatisticColumn objects that represent all the statistic columns defined on a table.

System_CAPS_pubclassStatisticEvents

The StatisticEvents object represents the settings required for SQL Server statistic counter event notification.

System_CAPS_pubclassStoredProcedure

The StoredProcedure object represents a SQL Server stored procedure.

System_CAPS_pubclassStoredProcedureCollection

The StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures that are defined on a table.

System_CAPS_pubclassStoredProcedureEvent

The StoredProcedureEvent object represents the SQL Server stored procedure events that can be included in an stored procedure event set.

System_CAPS_pubclassStoredProcedureEvents

The StoredProcedureEvents object represents the settings that are required for SQL Server stored procedure event notification.

System_CAPS_pubclassStoredProcedureEventSet

The StoredProcedureEventSet object represents a set of stored procedure events.

System_CAPS_pubclassStoredProcedureParameter

The StoredProcedureParameter object represents a SQL Server stored procedure parameter.

System_CAPS_pubclassStoredProcedureParameterCollection

The StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.

System_CAPS_pubclassSuspectPage

Represents the database page used for Page Restore.

System_CAPS_pubclassSymmetricKey

The SymmetricKey object represents a SQL Server symmetric key.

System_CAPS_pubclassSymmetricKeyCollection

The SymmetricKeyCollection class represents a collection of SymmetricKey objects that represent all the symmetric keys on the referenced database.

System_CAPS_pubclassSymmetricKeyEncryption

The SymmetricKeyEncryption class represents the encryption type used when encrypting symmetric keys.

System_CAPS_pubclassSynonym

The Synonym object represents a SQL Server synonym.

System_CAPS_pubclassSynonymCollection

The SynonymCollection class represents a collection of Synonym objects that represent all the synonyms on the referenced database.

System_CAPS_pubclassSynonymEvents

The SynonymEvents object represents the settings that are required for SQL Server synonym event notification.

System_CAPS_pubclassSystemDataType

The SystemDataType object represents a supported system data type. The SystemDataTypeCollection represents all the supported system data types.

System_CAPS_pubclassSystemDataTypeCollection

The SystemDataTypeCollection class represents a collection of SystemDataType objects that represent all the system data types on the referenced database.

System_CAPS_pubclassSystemMessage

The SystemMessage object represents messages defined by the system.

System_CAPS_pubclassSystemMessageCollection

The SystemMessageCollection class represents a collection of SystemMessage objects that represent all the system messages on the instance of SQL Server.

System_CAPS_pubclassTable

The Table object represents a SQL Server table.

System_CAPS_pubclassTableCollection

The TableCollection class represents a collection of Table objects that represent all the tables on the referenced database.

System_CAPS_pubclassTableEvent

Represents the SQL Server table events that can be included in a table event set.

System_CAPS_pubclassTableEvents

The TableEvents object represents the settings required for SQL Server table event notification.

System_CAPS_pubclassTableEventSet

The TableEventSet object represents a set of table events.

System_CAPS_pubclassTableViewBase

The TableViewBase class is a base class that is used in the construction of the Table class and View class. It contains functionality that is common to both classes.

System_CAPS_pubclassTableViewTableTypeBase

Base class for table view types.

System_CAPS_pubclassTcpProtocol

The TcpProtocol object provides programmatic access to the protocols supported by Microsoft SQL Server.

System_CAPS_pubclassTransfer

The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.

System_CAPS_pubclassTransferBase

Represents the base class for transfer.

System_CAPS_pubclassTrigger

The Trigger object represents a SQL Server trigger.

System_CAPS_pubclassTriggerCollection

The TriggerCollection class represents a collection of Trigger objects that represent all the triggers defined on a table.

System_CAPS_pubclassTriggerEvents

The TriggerEvents object represents the settings that are required for SQL Server trigger event notification.

System_CAPS_pubclassUnknownPropertyException

The UnknownPropertyException class represents the exception that is raised when an SMO operation encounters an unknown property.

System_CAPS_pubclassUnsupportedCompatLevelException

System_CAPS_pubclassUnsupportedEngineTypeException

The UnsupportedEngineTypeException class represents the exception raised when an SMO operation is attempted on a Database Engine type that does not support that operation. A Database Engine type is either an instance of the SQL Server Database Engine, or SQL Azure.

System_CAPS_pubclassUnsupportedFeatureException

The UnsupportedFeatureException class represents the exception raised when an SMO operation encounters a request for an unsupported feature.

System_CAPS_pubclassUnsupportedObjectNameException

The UnsupportedObjectNameException class represents the exception that is raised when an SMO operation encounters an unsupported object name.

System_CAPS_pubclassUnsupportedVersionException

The UnsupportedVersionException class represents the exception raised when an SMO operation encounters an unsupported version of SQL Server.

System_CAPS_pubclassUrnCollection

Represents a collection of T:Microsoft.SqlServer.Management.Smo.Urn objects that represent Uniform Resource Name (URN) addresses.

System_CAPS_pubclassUser

The User object represents a SQL Server user.

System_CAPS_pubclassUserCollection

The UserCollection class represents a collection of User objects that represent all the database users defined on a database.

System_CAPS_pubclassUserDefinedAggregate

The UserDefinedAggregate object represents a SQL Server user-defined aggregate.

System_CAPS_pubclassUserDefinedAggregateCollection

The UserDefinedAggregateCollection class represents a collection of UserDefinedAggregate objects that represent all the database user-defined aggregates that are defined on a database.

System_CAPS_pubclassUserDefinedAggregateParameter

The UserDefinedAggregateParameter object represents the parameters that are used with a user-defined aggregate.

System_CAPS_pubclassUserDefinedAggregateParameterCollection

The UserDefinedAggregateParameterCollection class represents a collection of UserDefinedAggregateParameter objects that represent all the user-defined aggregate parameters that are defined on a table.

System_CAPS_pubclassUserDefinedDataType

The UserDefinedDataType object represents a SQL Server user-defined data type.

System_CAPS_pubclassUserDefinedDataTypeCollection

The UserDefinedDataTypeCollection class represents a collection of UserDefinedDataType objects that represent all the user-defined data types defined on a table.

System_CAPS_pubclassUserDefinedDataTypeResolver

Resolves objects of user-defined types.

System_CAPS_pubclassUserDefinedFunction

The UserDefinedFunction object represents a SQL Server user-defined function.

System_CAPS_pubclassUserDefinedFunctionCollection

The UserDefinedFunctionCollection class represents a collection of UserDefinedFunction objects that represent all the user-defined functions that are defined on a table.

System_CAPS_pubclassUserDefinedFunctionEvent

Represents the SQL Server user-defined function events that can be included in a user-defined function event set.

System_CAPS_pubclassUserDefinedFunctionEvents

The UserDefinedFunctionEvents object represents the settings that are required for SQL Server user-defined function event notification.

System_CAPS_pubclassUserDefinedFunctionEventSet

The UserDefinedFunctionEventSet object represents a SQL Server set of user-defined function events.

System_CAPS_pubclassUserDefinedFunctionParameter

The UserDefinedFunctionParameter object represents a SQL Server user-defined function parameter.

System_CAPS_pubclassUserDefinedFunctionParameterCollection

The UserDefinedFunctionParameterCollection class represents a collection of UserDefinedFunctionParameter objects that represent all the user-defined function parameters that are defined on a table.

System_CAPS_pubclassUserDefinedMessage

The UserDefinedMessage object represents a user-defined message.

System_CAPS_pubclassUserDefinedMessageCollection

The UserDefinedMessageCollection class represents a collection of UserDefinedMessage objects that represent all the user-defined messages defined on a table.

System_CAPS_pubclassUserDefinedTableType

The UserDefinedTableType object represents a SQL Server user-defined table type data type.

System_CAPS_pubclassUserDefinedTableTypeCollection

The UserDefinedTableTypeCollection class represents a collection of UserDefinedTableType objects that represent all the user-defined table types that are defined on a database.

System_CAPS_pubclassUserDefinedTableTypeResolver

Resolves the type of a user defined table to an Object.

System_CAPS_pubclassUserDefinedType

The UserDefinedType represents an alias data type that is based on .NET data types.

System_CAPS_pubclassUserDefinedTypeCollection

The UserDefinedTypeCollection class represents a collection of UserDefinedType objects that represent all the alias data types that are defined on a table.

System_CAPS_pubclassUserDefinedTypeEvents

The UserDefinedTypeEvents object represents the settings required for SQL Server user-defined type event notification.

System_CAPS_pubclassUserDefinedTypeResolver

Resolves user-defined data types.

System_CAPS_pubclassUserEvents

The UserEvents object represents the settings that are required for SQL Server database user event notification.

System_CAPS_pubclassUserOptions

The UserOptions object represents a set configurable server options that relate specifically to users.

System_CAPS_pubclassVerifyCompleteEventArgs

The VerifyCompleteEventArgs object provides programmatic access to the arguments used to report the details of the event that occurs when a backup verification operation completes.

System_CAPS_pubclassVersionSerializationAdapter

Adapts the serialization mode to the version of SQL Server in use.

System_CAPS_pubclassVersionUtils

System_CAPS_pubclassView

The View object represents a SQL Server view. 

System_CAPS_pubclassViewCollection

The ViewCollection class represents a collection of View objects that represent all the views defined on a table.

System_CAPS_pubclassViewEvent

Represents the SQL Server view events that can be included in a view event set.

System_CAPS_pubclassViewEvents

The ViewEvents object represents the settings that are required for SQL Server view event notification.

System_CAPS_pubclassViewEventSet

Represents a set of view events.

System_CAPS_pubclassWorkloadGroup

The WorkloadGroup class is represents a SQL Server workgroup, which contains a group of session requests. Workload groups allow aggregate monitoring of resource consumption and application of uniform policies to all requests in the group.

System_CAPS_pubclassWorkloadGroupCollection

Represents a workload group collection.

System_CAPS_pubclassWrongPropertyValueException

The WrongPropertyValueException class represents the exception that is raised when a property is assigned the wrong value.

System_CAPS_pubclassXmlSchemaCollection

The XmlSchemaCollection object represents a collection of XML namespaces. The collection of XML namespaces behave a composite object though the namespaces can be enumerated within the collection.

System_CAPS_pubclassXmlSchemaCollectionCollection

The XmlSchemaCollectionCollection class represents a collection of XmlSchemaCollection objects that represent all the XML schema collections defined on a table. The XmlSchemaCollection object represents a collection of XML namespaces.

StructureDescription
System_CAPS_pubstructureAuditSpecificationDetail

The AuditSpecificationDetail object represents a SQL Server audit specification detail required when creating an audit.

System_CAPS_pubstructureDdlTextParserHeaderInfo

This class supports the SMO infrastructure and is not intended to be used directly from your code.

InterfaceDescription
System_CAPS_pubinterfaceIAvailabilityGroupState

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

System_CAPS_pubinterfaceIColumnPermission

The IColumnPermission class represents the interface that manages permissions for a specified column.

System_CAPS_pubinterfaceIDatabaseMaintenanceFacet

Represents an interface that defined methods and properties for the database maintenance facet.

System_CAPS_pubinterfaceIDatabaseOptions

Represents an interface with properties that expose database options.

System_CAPS_pubinterfaceIDatabasePerformanceFacet

Defines methods and properties that can be used to measure and influence database performance.

System_CAPS_pubinterfaceIDatabaseSecurityFacet

Security facet interface.

System_CAPS_pubinterfaceIExtendedProperties

The IExtendedProperties class is an interface that represents the collection of extended properties associated with an object.

System_CAPS_pubinterfaceILoginOptions

The ILoginOptions class is an interface that represents a collection of options associated with a login.

System_CAPS_pubinterfaceIMultipartNameFacet

Interface to deal with object names containing both the object and the schema.

System_CAPS_pubinterfaceINameFacet

Represents the name facet interface.

System_CAPS_pubinterfaceIObjectPermission

The IObjectPermission class represents the interface used to set object permissions.

System_CAPS_pubinterfaceIScriptable

The IScriptable class represents the interface used to create Transact-SQL scripts of SMO objects.

System_CAPS_pubinterfaceIServerAuditFacet

Interface that identifies audit facet members.

System_CAPS_pubinterfaceIServerConfigurationFacet

Contains configuration information for interfaces based on the Configuration object.

System_CAPS_pubinterfaceIServerInformation

An interface based on the Information type properties.

System_CAPS_pubinterfaceIServerPerformanceFacet

An interface for the performance facet.

System_CAPS_pubinterfaceIServerSecurityFacet

An interface that defines members for the SeverSecurityFacet.

System_CAPS_pubinterfaceIServerSelectionFacet

The T:Microsoft.SqlServer.Management.IServerSelectionFacet class contains members that represent the SQL Server policy-based management server selection facet objects.

System_CAPS_pubinterfaceIServerSettings

Represents an interface for SQL Server 2016 Policy-Based Management that is based on Settings.

System_CAPS_pubinterfaceIServerSetupFacet

Represents the Policy-Based Management facet interface for setting up an instance of SQL Server.

System_CAPS_pubinterfaceISmartAdminState

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

System_CAPS_pubinterfaceISurfaceAreaFacet

An interface that defines surface area facet members.

System_CAPS_pubinterfaceITableOptions

The ITableOptions class is an interface that represents a collection of options that is associated with a table.

System_CAPS_pubinterfaceITextObject

The ITextObject class represents the interface that is used to implement text on objects.

System_CAPS_pubinterfaceIUserOptions

The IUserOptions class is an interface that represents a collection of options that is associated with a user.

System_CAPS_pubinterfaceIViewOptions

The IViewOptions class is an interface that represents a collection of options that is associated with a view.

DelegateDescription
System_CAPS_pubdelegateSmoApplication.AnyObjectEventHandler

The SmoApplication.AnyObjectEventHandler class represents the event handler that is used to handle events from any object.

System_CAPS_pubdelegateDatabaseRestorePlanner.CreateRestorePlanEventHandler

System_CAPS_pubdelegateSmoApplication.DatabaseEventHandler

The SmoApplication.DatabaseEventHandler class represents the event handler that handles database events.

System_CAPS_pubdelegateNextRestoreEventHandler

Handles the NextRestoreEvent class.

System_CAPS_pubdelegateSmoApplication.ObjectAlteredEventHandler

The SmoApplication.ObjectAlteredEventHandler class represents the event handler that is used to handle events that occur when an object is altered.

System_CAPS_pubdelegateSmoApplication.ObjectCreatedEventHandler

The SmoApplication.ObjectCreatedEventHandler class represents the event handler that is used to handle events when an object is created.

System_CAPS_pubdelegateSmoApplication.ObjectDroppedEventHandler

The SmoApplication.ObjectDroppedEventHandler class represents the event handler that is used to handle events when an object is dropped.

System_CAPS_pubdelegateSmoApplication.ObjectRenamedEventHandler

The SmoApplication.ObjectRenamedEventHandler class represents the event handler that handles events that occur when an object is renamed.

System_CAPS_pubdelegatePercentCompleteEventHandler

The PercentCompleteEventHandler class represents the event handler that is used to handle percent complete events.

System_CAPS_pubdelegateProgressReportEventHandler

The ProgressReportEventHandler class represents the event handler that is used to handle progress report events.

System_CAPS_pubdelegateScriptingErrorEventHandler

The ScriptingErrorEventHandler class represents the event handler that is used to handle scripting errors.

System_CAPS_pubdelegateScriptingFilter

Do not reference this member directly in your code. It supports the SQL Server infrastructure. Supplies filtering for scripts.

System_CAPS_pubdelegateServerEventHandler

The ServerEventHandler class represents the event handler that is used to handle server errors.

System_CAPS_pubdelegateVerifyCompleteEventHandler

The VerifyCompleteEventHandler class represents the event handler that handles completion events.

EnumerationDescription
System_CAPS_pubenumAbortAfterWait

Describes the various actions to take after the Low Priority expires during an online index build/switch partition operation.

System_CAPS_pubenumActivationExecutionContext

The ActivationExecutionContext enumeration contains values that specify the security context used by a procedure. These procedures are activated by a service queue.

System_CAPS_pubenumAffinityType

The AffinityType enumeration represents the possible affinity settings for an instance of SQL Server.

System_CAPS_pubenumAssemblyAlterOptions

The AssemblyAlterOptions enumeration contains values that are used to specify the addition options when modifying an assembly. The values are bit flag values, and they can be combined by adding the values.

System_CAPS_pubenumAssemblySecurityLevel

The AssemblySecurityLevel enumeration contains values that are used to specify the access rights for an assembly.

System_CAPS_pubenumAsymmetricKeyEncryptionAlgorithm

The AsymmetricKeyEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an asymmetric key.

System_CAPS_pubenumAsymmetricKeySourceType

The AsymmetricKeySourceType enumeration contains values that are used to specify the source type used to load an asymmetric key.

System_CAPS_protenumBackupRestoreBase.AsyncOperation

The BackupRestoreBase.AsyncOperation enumeration contains values that are used to specify which backup components are running asynchronously.

System_CAPS_pubenumAttachOptions

The AttachOptions enumeration contains values that are used to specify attach options.

System_CAPS_pubenumAuditActionType

Specifies the type of action for SQL Server audit events.

System_CAPS_pubenumAuditDestinationType

The T:Microsoft.SqlServer.Management.Smo.AuditDestination enumeration contains values that are used to specify the destination, to which the results of a SQL Server Audit are sent.

System_CAPS_pubenumAuditFileSizeUnit

The AuditFileSizeUnit enumeration contains values that are used to specify the unit that specifies the size of the audit file.

System_CAPS_pubenumAuditLevel

The AuditLevel enumeration contains values that are used to specify the SQL Server audit level setting.

System_CAPS_pubenumAuditStatusType

The AuditStatusType enumeration contains values that are used to specify the status of the audit.

System_CAPS_pubenumAuthenticationType

Specifies the Sql server authentication type.

System_CAPS_pubenumAvailabilityDatabaseSynchronizationState

Represents the current state of the availability database synchronization.

System_CAPS_pubenumAvailabilityGroupAutomatedBackupPreference

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

System_CAPS_pubenumAvailabilityGroupFailureConditionLevel

Specifies the different conditions that can trigger an automatic failover in Availability Group.

System_CAPS_pubenumAvailabilityGroupListenerIPState

Specifies the state of the Availability Group Listener IP Address.

System_CAPS_pubenumAvailabilityGroupRollupSynchronizationState

Specifies a rollup of the synchronization states of the availability replicas in the availability group.

System_CAPS_pubenumAvailabilityReplicaAvailabilityMode

Specifies the availability modes of Availability Replica.

System_CAPS_pubenumAvailabilityReplicaConnectionModeInPrimaryRole

Specifies the connection intent modes of an Availability Replica in primary role.

System_CAPS_pubenumAvailabilityReplicaConnectionModeInSecondaryRole

Specifies the connection modes of an Availability Replica in secondary role.

System_CAPS_pubenumAvailabilityReplicaConnectionState

Represents the current availability replica connection state.

System_CAPS_pubenumAvailabilityReplicaFailoverMode

Specifies the failover modes of Availability Replica.

System_CAPS_pubenumAvailabilityReplicaJoinState

Specifies the availability replica join state.

System_CAPS_pubenumAvailabilityReplicaOperationalState

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

System_CAPS_pubenumAvailabilityReplicaRole

Represents the availability replica role.

System_CAPS_pubenumAvailabilityReplicaRollupRecoveryState

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

System_CAPS_pubenumAvailabilityReplicaRollupSynchronizationState

Specifies the current synchronization state of the availability replica.

System_CAPS_pubenumBackupActionType

The BackupActionType enumeration contains values that are used to specify the type of backup.

System_CAPS_pubenumBackupCompressionOptions

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

System_CAPS_pubenumBackupDeviceType

The BackupDeviceType enumeration contains values that are used to specify the backup device type.

System_CAPS_pubenumBackupEncryptionAlgorithm

Specifies the algorithm type used for backup encryption.

System_CAPS_pubenumBackupEncryptorType

Specifies the encryptor type used to encrypt an encryption key.

System_CAPS_pubenumBackupSetFlag

The BackupSetFlag enumeration contains values that are used to specify the purpose of the backup.

System_CAPS_pubenumBackupSetType

The BackupSetType enumeration contains values that are used to specify the backup type.

System_CAPS_pubenumBackupTruncateLogType

The BackupTruncateLogType enumeration contains values that are used to specify the truncate action taken on the log.

System_CAPS_pubenumCatalogPopulationAction

The CatalogPopulationAction enumeration contains values that are used to specify the method used to populate a full-text catalog.

System_CAPS_pubenumCatalogPopulationStatus

The CatalogPopulationStatus enumeration contains values that are used to specify the status of the full-text catalog.

System_CAPS_pubenumCertificateSourceType

The CertificateSourceType enumeration contains values that are used to specify the source of the certificate.

System_CAPS_pubenumChangeTracking

The ChangeTracking enumeration contains values that are used to specify change tracking in a full-text index.

System_CAPS_pubenumClusterMemberState

Specifies the state of a member in a Windows Cluster.

System_CAPS_pubenumClusterMemberType

Specifies the type of node in the windows cluster.

System_CAPS_pubenumClusterQuorumState

Specifies the current stat of the cluster quorum.

System_CAPS_pubenumClusterQuorumType

Specifies the different types of ways a cluster can decide on a quorum.

System_CAPS_pubenumCollationVersion

The CollationVersion enumeration contains values that specify the collation versions.

System_CAPS_pubenumColumnEncryptionType

System_CAPS_pubenumCompatibilityLevel

The CompatibilityLevel enumeration is a list of constant values that specify the behavior that corresponds to a version of SQL Server.

System_CAPS_pubenumContainmentType

Specifies the containment types of a database.

System_CAPS_pubenumCreateDispositionType

The CreateDispositionType enumeration contains values that are used to specify the source of the symmetric key.

System_CAPS_pubenumDatabaseDdlTriggerExecutionContext

The DatabaseDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the database DDL trigger runs.

System_CAPS_pubenumDatabaseEncryptionAlgorithm

Specifies the algorithm used to encrypt the database encryption key

System_CAPS_pubenumDatabaseEncryptionState

Enumerates the possible encryption states of a database.

System_CAPS_pubenumDatabaseEncryptionType

The DatabaseEncryptionType enumeration contains values that are used to specify the encryption types.

System_CAPS_pubenumDatabaseEventType

The DatabaseEventType enumeration is a list of constant values that specify the database event type.

System_CAPS_pubenumDatabaseObjectTypes

Specifies the types of database object.

System_CAPS_pubenumDatabasePermissionSetValue

The DatabasePermissionSetValue enumeration is a list of constant values that specify all the database permissions.

System_CAPS_pubenumDatabaseRecoveryState

Specifies the state of the database restore operation.

System_CAPS_pubenumDatabaseReplicaSuspendReason

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

System_CAPS_pubenumDatabaseStatus

The DatabaseStatus enumeration is a list of constant values that specify the status of a database, whether it be loading, recovering, or normal, for example. This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

System_CAPS_pubenumDatabaseUserAccess

The DatabaseUserAccess enumeration is a list of constant values that specify how user access can be restricted.

System_CAPS_pubenumDataCompressionType

Specifies the DataCompressionType enumeration contains values that are used to specify the type of data compression used to store data on the physical partition.

System_CAPS_pubenumDelayedDurability

Specifies an enumeration of delayed durability setting.

System_CAPS_pubenumDependencyType

The DependencyType enumeration is a list of constant values that specifies the direction of the dependency discovery operation.

System_CAPS_pubenumDeviceType

The DeviceType enumeration is a list of constant values that specify the various different types of devices supported by SQL Server.

System_CAPS_pubenumDistributionType

Specifies how the scale out system distributes a federated (Federation) table.

System_CAPS_pubenumDurabilityType

Lists durability types of a table.

For more information, see In-Memory OLTP (In-Memory Optimization).

System_CAPS_pubenumEdition

The Edition enumeration is a list of constant values that specify the various different types of devices that are supported by SQL Server.

System_CAPS_pubenumEndpointAuthenticationOrder

The EndpointAuthenticationOrder enumeration contains values that are used to specify the authentication methods and order of preference for the endpoint connection.

System_CAPS_pubenumEndpointEncryption

The EndpointEncryption enumeration contains values that are used to specify the state of encryption on the endpoint.

System_CAPS_pubenumEndpointEncryptionAlgorithm

The EndpointEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an endpoint.

System_CAPS_pubenumEndpointState

The EndpointState enumeration is a list of constant values that specifies the state of the HTTP endpoint.

System_CAPS_pubenumEndpointType

The EndpointType enumeration is a list of constant values that specifies the type of HTTP endpoint.

System_CAPS_pubenumEventType

Specifies the various different types of events that are supported by SQL Server.

System_CAPS_pubenumExecutionContext

The ExecutionContext enumeration is a list of constant values that specify the different types of context (or which role is assumed) when executing a process represented by an object.

System_CAPS_pubenumExecutionStatus

The ExecutionStatus enumeration is a list of constant values that specify the status of an executing process.

System_CAPS_pubenumExternalDataSourceType

System_CAPS_pubenumExternalFileFormatType

System_CAPS_pubenumExternalTableDistributionType

System_CAPS_pubenumExternalTableRejectType

System_CAPS_pubenumFileGroupType

FileGroupType is an enumeration that lists types of filegroups in a database.

System_CAPS_pubenumFileGrowthType

The FileGrowthType enumeration is a list of constant values that specify whether file growth is determined by percentage amount or by KB.

System_CAPS_pubenumFilestreamAccessLevelType

The FilestreamAccessLevelType enumeration contains values that are used to specify the type of access permitted on file stream operations.

System_CAPS_pubenumFileStreamEffectiveLevel

The FileStreamEffectiveLevel enumeration contains values that are used to specify the file stream level.

System_CAPS_pubenumFileStreamLevel

The FileStreamLevel enumeration contains values that are used to specify the file stream level.

System_CAPS_pubenumFilestreamNonTransactedAccessType

Enumerates the file stream non-transacted access types.

System_CAPS_pubenumForeignKeyAction

The ForeignKeyAction enumeration is a list of constant values that specify the action that is taken when the primary key reference by a foreign key is updated.

System_CAPS_pubenumFragmentationOption

The FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.

System_CAPS_pubenumFullTextCatalogUpgradeOption

The FullTextCatalogUpgradeOption enumeration contains values that are used to specify the action taken when the full-text catalog is upgraded.

System_CAPS_pubenumGeneratedAlwaysType

System_CAPS_pubenumHadrManagerStatus

Enumeration to represent the status of the Hadr manager.

System_CAPS_pubenumHttpAuthenticationModes

The HttpAuthenticationModes enumeration contains values that specify the HTTP port for HTTP endpoints.

System_CAPS_pubenumHttpPortTypes

The HttpPortTypes enumeration contains values that are used to specify the type HTTP port.

System_CAPS_pubenumImplementationType

The ImplementationType enumeration contains values that are used to specify the type of implementation for a stored procedure, a user-defined function, and other objects.

System_CAPS_pubenumIndexedXmlPathType

Specifies an enumeration of type of indexed XML path.

System_CAPS_pubenumIndexEnableAction

The IndexEnableAction enumeration contains values that are used to specify the action that is taken on an index when it is enabled after having been disabled.

System_CAPS_pubenumIndexKeyType

The IndexKeyType enumeration contains values that are used to specify the type of key on which the index is created.

System_CAPS_pubenumIndexOperation

The IndexOperation enumeration contains values that are used to specify index operations.

System_CAPS_pubenumIndexPopulationAction

The IndexPopulationAction enumeration contains values that are used to specify the type of Microsoft Search full-text index population.

System_CAPS_pubenumIndexPopulationStatus

The IndexPopulationStatus enumeration contains values that are used to specify the type of population in progress.

System_CAPS_pubenumIndexType

Specifies the type of an index.

For an In-Memory OLTP code sample, see SQL Server Management Objects Support for In-Memory OLTP.

System_CAPS_pubenumInDoubtTransactionResolutionType

Enumerates possible responses to in-doubt transactions.

System_CAPS_pubenumInstanceState

The InstanceState enumeration contains values that are used to specify the possible states of an instance of SQL Server.

System_CAPS_pubenumKeyEncryptionType

The KeyEncryptionType enumeration is a list of constant values that specify the key encryption type.

System_CAPS_pubenumLinkedTableType

The LinkedTableType enumeration contains values that specify the type of table accessed on a linked server.

System_CAPS_pubenumLinkFieldType

The LinkFieldType enumeration contains values that specify the type of link field.

System_CAPS_pubenumLockEscalationType

An enumeration that lists lock escalation types.

System_CAPS_pubenumLockRequestStatus

The LockRequestStatus enumeration contains constant values that specify the lock request status.

System_CAPS_pubenumLoginCreateOptions

The LoginCreateOptions enumeration contains values that are used to specify the password options when you create a logon.

System_CAPS_pubenumLoginType

The LoginType enumeration contains values that are used to specify the authentication type and the Windows account type.

System_CAPS_pubenumLogReuseWaitStatus

The LogReuseWaitStatus enumeration contains values that specify the current operation on which the reuse of transaction log space is waiting.

System_CAPS_pubenumMappedClassType

Enumerates credential mapping options.

System_CAPS_pubenumMediaTypes

The MediaTypes enumeration contains values that are used to specify the type of media used to store data. This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

System_CAPS_pubenumMethodLoginType

The MethodLoginType enumeration contains values that are used to specify the method used for logging on to the instance of SQL Server.

System_CAPS_pubenumMethodXsdSchemaOption

The MethodXsdSchemaOption enumeration contains values that specify the XSD schema returned for a SOAP method.

System_CAPS_pubenumMirroringOption

The MirroringOption enumeration contains values that specify the mirroring options for a database.

System_CAPS_pubenumMirroringRole

The MirroringRole enumeration contains values that specify the role the database plays in mirroring.

System_CAPS_pubenumMirroringSafetyLevel

The MirroringSafetyLevel enumeration contains values that specify the safety guarantee on updates to the mirrored database.

System_CAPS_pubenumMirroringStatus

The MirroringStatus enumeration contains values that specify the state of a database regarding mirroring.

System_CAPS_pubenumMirroringWitnessStatus

The MirroringWitnessStatus enumeration contains values that specify the state of the mirroring witness.

System_CAPS_pubenumMonth

The Month enumeration contains constant values that specify the twelve calendar months.

System_CAPS_pubenumNSActivationState

The NSActivationState enumeration contains constant values that specify the activation state of Notification Services.

System_CAPS_pubenumNumaNodeAffinity

The NumaNodeAffinity enumeration defines the affinity states for a Cpu object.

System_CAPS_pubenumObjectClass

The ObjectClass enumeration contains values that specify the SMO class type.

System_CAPS_pubenumObjectPermissionSetValue

The ObjectPermissionSetValue enumeration is a list of constant values that specify all the object permissions.

System_CAPS_pubenumOnFailureAction

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

System_CAPS_pubenumPageVerify

The PageVerify enumeration contains constant values that specify the automatic page verification options for a database.

System_CAPS_pubenumPasswordHashAlgorithm

Displays the password hash algorithm in the Server Management Objects.

System_CAPS_pubenumPerfMonMode

The PerfMonMode enumeration contains values that are used to specify the polling behavior in Performance Monitor.

System_CAPS_pubenumPermissionState

The PermissionState enumeration contains values that specify the state of a permission.

System_CAPS_pubenumPlanGuideType

Enumerates the possible Plan Guide types.

System_CAPS_pubenumPrincipalType

The PrincipalType enumeration contains values that specify the type of user, role, or login.

System_CAPS_pubenumPrivateKeyEncryptionType

The PrivateKeyEncryptionType enumeration contains values that are used to specify the encryption types for a private key associated with a certificate or an asymmetric key.

System_CAPS_pubenumPrivilegeTypes

The PrivilegeTypes enumeration contains values that are used to specify the operations that the grantee can perform on the specified object when permission is granted.

System_CAPS_pubenumProtocolType

The ProtocolType enumeration contains values that are used to specify the type of protocol.

System_CAPS_pubenumProviderAuthenticationType

Specifies the type of authentication supported by Cryptographic Provider.

System_CAPS_pubenumQueryStoreCaptureMode

System_CAPS_pubenumQueryStoreOperationMode

System_CAPS_pubenumQueryStoreSizeBasedCleanupMode

System_CAPS_pubenumRangeType

The RangeType enumeration contains values that are used to specify the type range.

System_CAPS_pubenumRecoveryModel

The RecoveryModel enumeration contains values that are used to specify the type of recovery model.

System_CAPS_pubenumRemoteDataArchiveMigrationState

System_CAPS_pubenumRepairOptions

The RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.

System_CAPS_pubenumRepairStructure

The T:Microsoft.SqlServer.Management.Smo.RepairRepairStructure enumeration contains values that are used to specify the type of repair options used when checking data in a table.

System_CAPS_pubenumRepairType

The RepairType enumeration contains values that are used to specify the type of repair mode used by the database consistency check (DBCC) functions.

System_CAPS_pubenumReplicationOptions

The ReplicationOptions enumeration contains values that are used to specify the replication settings for the referenced database.

System_CAPS_pubenumResourceUsage

The ResourceUsage enumeration contains values that specify the relative operating system execution priority setting for the Microsoft Search service.

System_CAPS_pubenumRestoreActionType

The RestoreActionType enumeration contains values that are used to specify the type of action that is required during a data restore operation.

System_CAPS_pubenumRestoreType

The RestoreType enumeration contains values that specify the type of restore operation to perform.

System_CAPS_pubenumResultFormat

The ResultFormat enumeration contains values that specify the format in which to return results for an HTTP endpoint.

System_CAPS_pubenumRetentionPeriodUnits

Enumerates values that specify the units for the retention period.

System_CAPS_pubenumRoleTypes

The RoleTypes enumeration contains values that are used to specify the type of role.

System_CAPS_pubenumSecondaryXmlIndexType

The SecondaryXmlIndexType enumeration contains values that are used to specify the secondary XML index type.

System_CAPS_pubenumSecurityPredicateOperation

System_CAPS_pubenumSecurityPredicateType

System_CAPS_pubenumSequenceCacheType

The SequenceCacheType enumeration contains constant values that specify the type of caching used by a Sequence.

System_CAPS_pubenumServerDdlTriggerExecutionContext

The ServerDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the server DDL trigger runs.

System_CAPS_pubenumServerLoginMode

The ServerLoginMode enumeration contains values that are used to specify the method used to connect to the instance of SQL Server.

System_CAPS_pubenumServerMirroringRole

The ServerMirroringRole enumeration contains values that are used to specify the role of the instance of SQL Server when participating in mirroring.

System_CAPS_pubenumServerPermissionSetValue

The ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.

System_CAPS_pubenumServerStatus

The ServerStatus enumeration contains values that are used to specify the status of the instance of SQL Server. 

System_CAPS_pubenumServiceStartMode

The ServiceStartMode enumeration contains values that are used to specify the method that is used to start a service.

System_CAPS_pubenumShrinkMethod

The ShrinkMethod enumeration contains values that are used to specify the method that is used shrink a database file.

System_CAPS_pubenumSmoExceptionType

The SmoExceptionType enumeration contains values that are used to specify the type of SMO exception.

System_CAPS_pubenumSnapshotIsolationState

The SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.

System_CAPS_pubenumSortOrder

The SortOrder enumeration contains values that specify how objects are sorted in an enumerated list.

System_CAPS_pubenumSpatialGeoLevelSize

Enumerates grid density levels for spatial indexes.

System_CAPS_pubenumSpatialIndexType

Enumerates possible spatial index types.

System_CAPS_pubenumSqlDataType

The SqlDataType enumeration contains values that are used to specify a SQL Server data type.

System_CAPS_pubenumSqlServerVersion

The SqlServerVersion enumeration contains values that are used to specify the version of the referenced instance of SQL Server.

System_CAPS_pubenumSqlServerVersions

The SqlServerVersions enumeration contains values that are used to specify the version of the referenced instance of SQL Server.

System_CAPS_pubenumSqlSmoState

The SqlSmoState enumeration contains values that are used to specify the state of an SMO object.

System_CAPS_pubenumSqlVerifyAction

The SqlVerifyAction enumeration contains values that are used to specify the type of backup verification.

System_CAPS_pubenumStatisticsScanType

The StatisticsScanType enumeration contains values that specify the ways in which statistical information is collected from tables or views during the creation or update of a statistic counter.

System_CAPS_pubenumStatisticsTarget

The StatisticsTarget enumeration contains values that specify the type of statistic that is targeted for the update operation.

System_CAPS_pubenumStopListOption

The StopListOption enumeration contains values that are used to specify the way in which a new stop list is created.

System_CAPS_pubenumSymmetricKeyEncryptionAlgorithm

The SymmetricKeyEncryptionAlgorithm enumeration contains values that specify the algorithm that is used to encrypt the symmetric key.

System_CAPS_pubenumSymmetricKeyEncryptionType

The SymmetricKeyEncryptionType enumeration contains constant values that specify the type of symmetric key encryption.

System_CAPS_pubenumSynonymBaseType

The SynonymBaseType enumeration contains constant values that specify the type of synonym.

System_CAPS_pubenumTableTemporalType

System_CAPS_pubenumTerminationClause

The TerminationClause enumeration contains constant values that specify the action taken when transactions are terminated.

System_CAPS_pubenumTransactionTypes

The TransactionTypes enumeration contains constant values that specify the method of recording transactions.

System_CAPS_pubenumUrnIdOption

Enumerates URN identification options.

System_CAPS_pubenumUserDefinedFunctionType

The UserDefinedFunctionType enumeration is a list of constant values that specify the types of user-defined functions that are supported by SQL Server.

System_CAPS_pubenumUserDefinedTypeFormat

The UserDefinedTypeFormat enumeration is a list of constant values that specify the formats used by user-defined types.

System_CAPS_pubenumUserType

The UserType enumeration contains constant values that specify the security type for the user.

System_CAPS_pubenumWindowsLoginAccessType

The WindowsLoginAccessType enumeration contains constant values that specify the type of access a Windows login has to the instance of SQL Server.

System_CAPS_pubenumWorkloadGroupImportance

The WorkloadGroupImportance enumeration contains values that specify the importance of workload groups.

System_CAPS_pubenumWsdlGeneratorOption

The WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.

System_CAPS_pubenumXmlDocumentConstraint

The XmlDocumentConstraint enumeration contains constant values that specify the constraints imposed on an XML document.

System_CAPS_pubenumXmlFormatOption

The WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.

System_CAPS_pubenumXmlTypeDerivation

The XmlTypeDerivation enumeration contains constant values that specify the XML type derivation.

System_CAPS_pubenumXmlTypeKind

The XmlTypeKind enumeration contains constant values that specify the kind of XML component.

System_CAPS_pubenumXsdSchemaOption

The XsdSchemaOption enumeration contains constant values that specify whether an inline schema for the method result is returned in the SOAP response.

The Microsoft.SqlServer.Management.Smo namespace contains the instance object classes that represent SQL Server Database Engine objects and some utility classes that represent specific tasks, such as scripting. When a connection to the instance of the SQL Server Database Engine has been established by using a Server object variable, objects on the instance can be accessed by using the SMO instance objects. For example, you can use the Database object to access databases on the connected instance of SQL Server Database Engine. All the instance classes are related to the Server class in the object hierarchy. Utility classes exist outside of the Server class object hierarchy and represent specific tasks, such as backup or scripting.

Most of the classes Microsoft.SqlServer.Management.Smo namespace resides in the Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.SmoExtended.dll files. Additionally, some of the enumeration classes are in the Microsoft.SqlServer.SqlEnum.dll and Microsoft.SqlServer.SmoEnum.dll assembly files. You will have to import all four files to access all of the classes in the Microsoft.SqlServer.Management.Smo namespace.

By using the Microsoft.SqlServer.Management.Smo namespace, you can do the following:

  • Connect to an instance of the SQL Server Database Engine.

  • View and modify instance settings and configuration options.

  • View and modify database objects.

  • Perform DDL (data definition language) tasks on an instance of the SQL Server Database Engine.

  • Script databases dependencies.

  • Perform database maintenance tasks, such as backup and restore operations.

  • Transfer database schemas and data.

Return to top
Show:
© 2016 Microsoft