The Microsoft.SqlServer.Management.Smo namespace contains classes that represent the core SMO objects. These include instances, utility classes, enumerations, event handler types, and exception types.

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 SQL Server has been established by using a Server object variable, objects on the instance of SQL Server 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. 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.

The Microsoft.SqlServer.Management.Smo namespace resides in the Microsoft.SqlServer.Smo.dll file. 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 three files to access 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 SQL Server.

• View and modify SQL Server settings and configuration options.

• View and modify SQL Server engine objects.

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

• Script databases dependencies.

• Back up and restore databases.

• Transfer database schemas and data.

 Classes

Class	Description
AbstractCollectionBase	The AbstractCollectionBase object is a base class object that is used in the construction of collection objects.
ApplicationRole	The ApplicationRole object represents a security role that is used to set access privileges from an application regardless of the user's permissions.
ApplicationRoleCollection	The ApplicationRoleCollectionclass represents a collection of ApplicationRole objects that represent all the application roles on the referenced database.
ApplicationRoleEvents	The ApplicationRoleEvents object represents the settings required for Microsoft SQL Server application role event notification.
ArrayListCollectionBase	The ArrayListCollectionBase object represents a base class that is used in the construction of collections that are based on array lists.
AsymmetricKey	The AsymmetricKey object represents a SQL Server asymmetric key.
AsymmetricKeyCollection	The AsymmetricKeyCollection class represents a collection of AsymmetricKey objects that represent all the asymmetric keys on the referenced database.
AsyncStatus	The AsyncStatus object represents the status of an asynchronous process.
Audit	The Audit object represents a SQL Server audit log.
AuditCollection	The AuditCollection class represents a collection of Audit objects that represent all the audits on the instance of SQL Server.
AuditExtender	Adds methods and properties to the Audit object.This class is not CLS-compliant.
AuditSpecification	The Column object represents a SQL Server column.
Backup	The Backup object provides programmatic access to Microsoft SQL Server backup operations.
BackupDevice	The BackupDevice object provides programmatic access to SQL Server backup devices.
BackupDeviceCollection	The BackupDeviceCollection class represents a collection of BackupDevice objects that represent all the backup devices on an instance of SQL Server.
BackupDeviceItem	The BackupDeviceItem object provides programmatic access to named SQL Server backup devices.
BackupDeviceList	The BackupDeviceList object provides programmatic access to a list backup devices. This class is not CLS-compliant.
BackupRestoreBase	The BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.
Certificate	The Certificate object represents a SQL Server certificate.
CertificateCollection	The CertificateCollection class represents a collection of Certificate objects that represent all the certificates on an instance of SQL Server.
CertificateEvents	The CertificateEvents object represents the settings that are required for SQL ServerCertificate event notification.
Check	The Check object represents a Microsoft SQL Server check constraint.
CheckCollection	The CheckCollection class represents a collection of Check objects that represent all the check constraints defined on the parent object.
CollectionNotAvailableException	The CollectionNotAvailableException class is an exception that is raised when an attempt is made to retrieve a collection that is not available.
Column	The Column object represents a SQL Server column.
ColumnCollection	The ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.
ConfigProperty	The ConfigProperty object contains information pertaining to a Microsoft SQL Server configuration option, such as maximum, minimum, current, and new values.
ConfigPropertyCollection	The ConfigPropertyCollection class represents a collection of ConfigProperty objects that represent all the configuration properties defined on the instance of SQL Server.
Configuration	The Configuration class contains the configuration information for the instance of SQL Server.
ConfigurationBase	The ConfigurationBase class is a base class that represents configuration information for the instance of SQL Server.
Credential	The Credential object represents a Microsoft SQL Server credential.
CredentialCollection	The CredentialCollection class represents a collection of Credential objects that represent all the credentials defined on the instance of Microsoft SQL Server.
CryptographicProvider	The CryptographicProvider object represents a SQL Server cryptographic provider.
CryptographicProviderCollection	A collection of type CryptographicProviderCollection that represents a collection of CryptographicProviderr objects.
Database	The Database object represents a SQL Server database.
DatabaseActiveDirectory	The DatabaseActiveDirectory object provides programmatic access to the Active Directory settings for a database.
DatabaseAdapter	Database Adapter type to be used as a management facet.
DatabaseAdapterBase	Database adapter base.
DatabaseAuditSpecification	The DatabaseAuditSpecification object represents an auditable event on the database.
DatabaseAuditSpecificationCollection	The DatabaseAuditSpecificationCollection class represents a collection of DatabaseAuditSpecification objects that represent all the audit specifications defined on the database.
DatabaseAuditSpecificationExtender	Adds methods and properties to the DatabaseAuditSpecification object.This class is not CLS-compliant.
DatabaseCollection	The DatabaseCollection class represents a collection of Database objects that represent all the databases defined on the instance of SQL Server.
DatabaseDdlTrigger	The DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.
DatabaseDdlTriggerCollection	The DatabaseDdlTriggerCollection class represents a collection of DatabaseDdlTrigger objects that represent all the database data definition language (DDL) triggers defined on a table.
DatabaseDdlTriggerEvent	The DatabaseDdlTriggerEvent object represents the SQL Server database DDL trigger events that can be included in a database DDL trigger event set.
DatabaseDdlTriggerEventSet	The DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events.
DatabaseEncryptionKey	Creates a database encryption key.
DatabaseEncryptionKeyExtender	Extends the database encryption key class.This class is not CLS-compliant.
DatabaseEvent	The DatabaseEvent object represents the SQL Server database events that can be included in a database event set.
DatabaseEventArgs	The DatabaseEventArgs object represents the arguments passed by the event raised by the database.
DatabaseEvents	The DatabaseEvents object represents the settings required for Microsoft SQL Server database event notification.
DatabaseEventSet	The DatabaseEventSet object represents a SQL Server set of database events.
DatabaseFile	The DatabaseFile object is a base class used in the construction of DataFile objects and LogFile objects.
DatabaseFileMappingsDictionary	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.
DatabaseMaintenanceAdapter	The Database Maintenance facet has logical properties. It inherits from the DatabaseAdapter class.
DatabaseMapping	The DatabaseMapping object represents a SQL Server database mapping.
DatabaseMirroringPayload	The DatabaseMirroringPayload object represents database mirroring payload settings.
DatabaseOptions	The DatabaseOptions object represents SQL Server database options.
DatabasePerformanceAdapter	The Database Performance facet implements logical properties relevant to database performance management.
DatabasePermission	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.
DatabasePermissionInfo	The DatabasePermissionInfo object represents information about a SQL Server database permission.
DatabasePermissionSet	The DatabasePermissionSet object represents a SQL Server set of database permissions.
DatabaseRole	The DatabaseRole object represents a SQL Server database security role.
DatabaseRoleCollection	The DatabaseRoleCollection class represents a collection of DatabaseRole objects that represent all the database roles defined on the parent database.
DatabaseSecurityAdapter	Includes properties and methods that are used to expose the Database Security facet.
DatabaseSnapshotExtender	Adds methods and properties to the DatabaseSnapshot object.This class is not CLS-compliant.
DataFile	The DataFile object represents a Microsoft SQL Server data file.
DataFileCollection	The DataFileCollection class represents a collection of DataFile objects that represent all the data files defined on the parent object.
DataType	The DataType object represents a SQL Server data type.
DdlTriggerBase	The DdlTriggerBase is a base class that is inherited by the DatabaseDdlTrigger object. This represents a SQL Server database data definition language (DDL) trigger.
Default	The Default object represents a Microsoft SQL Server default.
DefaultCollection	The DefaultCollection class represents a collection of Default objects.
DefaultConstraint	The DefaultConstraint object represents a SQL Server default constraint.
DefaultRuleBase	The DefaultRuleBase class is a base class that is inherited by the Rule class and the Default class.
DependencyCollection	The DependencyCollection class represents a collection of Dependency objects that are used to derive the node classes in SMO scripting operations.
DependencyCollectionNode	The DependencyCollectionNode class represents a node in the dependency collection that is derived during scripting operations.
DependencyNode	The DependencyNode class represents a node that is defined by a URN address.
DependencyTree	The DependencyTree object represents a tree structure that contains SQL Server objects and their hierarchical relationships to each other.
DependencyTreeNode	The DependencyTreeNode class represents the child and sibling SQL Server objects within a DependencyTree object hierarchy.
DependencyWalker	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.
Endpoint	The Endpoint class represents an endpoint service that can listen natively for requests.
EndpointCollection	The EndpointCollection class represents a collection of Endpoint objects that represent all the HTTP endpoints.
EndpointPayload	The EndpointPayload object represents an endpoint payload.
EndpointProtocol	The EndpointProtocol object represents an HTTP endpoint protocol.
EventProperty	The EventProperty class represents a property of an event.
EventPropertyCollection	The EventPropertyCollection object represents the properties of event objects.
EventSetBase	The EventSetBase class is a base class that is used to derive the event set objects.
ExtendedProperty	The ExtendedProperty object represents the extended properties that are defined for any object that has an ExtendedProperties collection property.
ExtendedPropertyCollection	The ExtendedPropertyCollection class represents a collection of ExtendedPropertyCollectionobjects that represent all the extended properties.
ExtendedStoredProcedure	The ExtendedStoredProcedure object represents an extended stored procedure on the instance of Microsoft SQL Server.
ExtendedStoredProcedureCollection	The ExtendedStoredProcedureCollection class represents a collection of ExtendedStoredProcedure objects that represent all the extended stored procedures defined on the parent database.
FailedOperationException	The FailedOperationException class represents the exception raised when an operation fails.
FileGroup	The FileGroup object represents a SQL Server file group.
FileGroupCollection	The FileGroupCollection class represents a collection of FileGroup objects that represent all the filegroups defined on the parent database.
ForeignKey	The ForeignKey object represents a SQL Server foreign key.
ForeignKeyCollection	The ForeignKeyCollection class represents a collection of ForeignKey objects that represent all the foreign keys defined on the parent object.
ForeignKeyColumn	The ForeignKeyColumn object represents a SQL Server foreign key column.
ForeignKeyColumnCollection	The ForeignKeyColumnCollection class represents a collection of ForeignKeyColumn objects that represent all the foreign key columns defined on the parent object.
FrequencyPair	The FrequencyPair object is a utility that measures frequency by storing count and duration information.
FullTextCatalog	The FullTextCatalog object represents a Microsoft Search full-text catalog.
FullTextCatalogCollection	The FullTextCatalogCollection class represents a collection of FullTextCatalog objects that represent all the full-text catalogs defined on the parent object.
FullTextIndex	The FullTextIndex object represents a Microsoft Search full-text index.
FullTextIndexColumn	The FullTextIndexColumn object represents a Microsoft Search full-text index column.
FullTextIndexColumnCollection	The FullTextIndexColumnCollection class represents a collection of FullTextIndexColumn objects that represent all the full-text index columns defined on the parent object.
FullTextService	The FullTextService object allows programmatic access to the Microsoft Search full-text settings.
FullTextStopList	The FullTextStopList object represents a full-text stop list.
FullTextStopListCollection	The FullTextStopListCollection class represents a collection of FullTextStopList objects that represent all the full-text stop lists that are defined on the parent database.
HttpProtocol	The HttpProtocol object represents an HTTP protocol on an instance of Microsoft SQL Server.
Index	The Index object represents a SQL Server index.
IndexCollection	The IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of SQL Server.
IndexedColumn	The IndexedColumn object represents a SQL Server column that is participating in an index.
IndexedColumnCollection	The IndexedColumnCollection class represents a collection of IndexedColumn objects that represent all the indexed columns defined on the instance of SQL Server.
IndexEvents	The IndexEvents object represents the settings that are required for SQL Server index event notification.
Information	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.
InternalSmoErrorException	The InternalSmoErrorException class represents the exception raised when an error occurs during the internal phase of a SMO operation.
InvalidSmoOperationException	The InvalidSmoOperationException class represents the exception raised when an SMO operation is not valid.
InvalidVersionSmoOperationException	The InvalidVersionSmoOperationException class represents the exception raised when the version is not valid on an SMO operation.
JobScheduleCollectionBase	The JobScheduleCollectionBase class represents a base class that is used in the construction of the JobScheduleCollection class.
Language	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.
LanguageCollection	The LanguageCollection class represents a collection of Language objects that represent all the languages which are defined on the instance of SQL Server.
LinkedServer	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.
LinkedServerCollection	The LinkedServerCollection class represents a collection of LinkedServer objects that represent all the linked servers registered on the instance of SQL Server.
LinkedServerLogin	The LinkedServerLogin object represents a SQL Server logon account that has permission to connect to the linked server.
LinkedServerLoginCollection	The LinkedServerLoginCollection class represents a collection of LinkedServerLogin objects that represent all the linked server logins defined on the linked server.
LogFile	The LogFile object represents a SQL Server log file.
LogFileCollection	The LogFileCollection class represents a collection of LogFile objects that represent all the log files defined on the instance of Microsoft SQL Server.
Login	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.
LoginCollection	The LoginCollection class represents a collection of Login objects that represent all the login accounts defined on the instance of SQL Server.
LoginEvents	The LoginEvents object represents the settings required for SQL Server login event notification.
MasterKey	The MasterKey object represents a SQL Server database master key.
MessageCollectionBase	The MessageCollectionBase class is a base class that is used in the construction of message collection classes.