Namespace Microsoft.SqlServer.Management.Smo

The Microsoft.SqlServer.Management.Smo namespace contains classes that represent the core Mecanismo de banco de dados do SQL Server objects. These include instances, databases, tables, stored procedures, and views.

The Microsoft.SqlServer.Management.Smo namespace contains the instance object classes that represent Mecanismo de banco de dados do SQL Server objects and some utility classes that represent specific tasks, such as scripting. When a connection to the instance of the Mecanismo de banco de dados do SQL Server 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 Mecanismo de banco de dados do 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.

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 Mecanismo de banco de dados do SQL Server.

  • View and modify instance settings and configuration options.

  • View and modify database objects.

  • Perform DDL (data definition language) tasks on an instance of the Mecanismo de banco de dados do SQL Server.

  • Script databases dependencies.

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

  • Transfer database schemas and data.

Classes

  Classe Descrição
Classe pública AbstractCollectionBase The AbstractCollectionBase object is a base class object that is used in the construction of collection objects.
Classe pública AffinityInfo 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.
Classe pública ApplicationRole The ApplicationRole object represents a security role that is used to set access privileges from an application regardless of the user's permissions.
Classe pública ApplicationRoleCollection The ApplicationRoleCollectionclass represents a collection of ApplicationRole objects that represent all the application roles on the referenced database.
Classe pública ApplicationRoleEvents The ApplicationRoleEvents object represents the settings required for Microsoft SQL Server application role event notification.
Classe pública ArrayListCollectionBase The ArrayListCollectionBase object represents a base class that is used in the construction of collections that are based on array lists.
Classe pública AsymmetricKey The AsymmetricKey object represents a SQL Server asymmetric key.
Classe pública AsymmetricKeyCollection The AsymmetricKeyCollection class represents a collection of AsymmetricKey objects that represent all the asymmetric keys on the referenced database.
Classe pública AsyncStatus The AsyncStatus object represents the status of an asynchronous process.
Classe pública Audit The Audit object represents a SQL Server audit log.
Classe pública AuditCollection The AuditCollection class represents a collection of Audit objects that represent all the audits on the instance of SQL Server.
Classe pública AuditExtender Adds methods and properties to the Audit object.
Classe pública AuditSpecification The AuditSpecification class defines the audit groups and specifies the server audit that they belong to.
Classe pública Backup The Backup object provides programmatic access to Microsoft SQL Server backup operations.
Classe pública BackupDevice The BackupDevice object provides programmatic access to SQL Server backup devices.
Classe pública BackupDeviceCollection The BackupDeviceCollection class represents a collection of BackupDevice objects that represent all the backup devices on an instance of SQL Server.
Classe pública BackupDeviceItem The BackupDeviceItem object provides programmatic access to named SQL Server backup devices.
Classe pública BackupDeviceList The BackupDeviceList object provides programmatic access to a list backup devices.
Classe pública BackupRestoreBase The BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.
Classe pública Certificate The Certificate object represents a SQL Server certificate.
Classe pública CertificateCollection The CertificateCollection class represents a collection of Certificate objects that represent all the certificates on an instance of SQL Server.
Classe pública CertificateEvents The CertificateEvents object represents the settings that are required for SQL Server Certificate event notification.
Classe pública Check The Check object represents a SQL Server check constraint. 
Classe pública CheckCollection The CheckCollection class represents a collection of Check objects that represent all the check constraints defined on the parent object.
Classe pública CollectionNotAvailableException The CollectionNotAvailableException class is an exception that is raised when an attempt is made to retrieve a collection that is not available.
Classe pública Column O objeto Column representa uma coluna do SQL Server.
Classe pública ColumnCollection The ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.
Classe pública ConfigProperty The ConfigProperty object contains information pertaining to a Microsoft SQL Server configuration option, such as maximum, minimum, current, and new values.
Classe pública ConfigPropertyCollection The ConfigPropertyCollection class represents a collection of ConfigProperty objects that represent all the configuration properties defined on the instance of SQL Server.
Classe pública Configuration A classe Configuration contém as informações de configuração da instância do SQL Server.
Classe pública ConfigurationBase The ConfigurationBase class is a base class that represents configuration information for the instance of SQL Server.
Classe pública Cpu The Cpu class contains information about one CPU on an instance of SQL Server.
Classe pública CpuCollection The CpuCollection class represents a collection of Cpu objects that represent all the CPUs that are defined on an instance of SQL Server.
Classe pública Credential The Credential object represents a Microsoft SQL Server credential.
Classe pública CredentialCollection The CredentialCollection class represents a collection of Credential objects that represent all the credentials defined on the instance of Microsoft SQL Server.
Classe pública CryptographicProvider The CryptographicProvider object represents a SQL Server cryptographic provider.
Classe pública CryptographicProviderCollection A collection of type CryptographicProviderCollection that represents a collection of CryptographicProviderr objects.
Classe pública Database O objeto Database representa um banco de dados do SQL Server.
Classe pública DatabaseActiveDirectory The DatabaseActiveDirectory object provides programmatic access to the Active Directory settings for a database.
Classe pública DatabaseAdapter Database Adapter type to be used as a management facet.
Classe pública DatabaseAdapterBase Database adapter base.
Classe pública DatabaseAuditSpecification The DatabaseAuditSpecification object represents an auditable event on the database.
Classe pública DatabaseAuditSpecificationCollection The DatabaseAuditSpecificationCollection class represents a collection of DatabaseAuditSpecification objects that represent all the audit specifications defined on the database.
Classe pública DatabaseAuditSpecificationExtender Adds methods and properties to the DatabaseAuditSpecification object.
Classe pública DatabaseCollection The DatabaseCollection class represents a collection of Database objects that represent all the databases defined on the instance of SQL Server.
Classe pública DatabaseDdlTrigger The DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.
Classe pública DatabaseDdlTriggerCollection The DatabaseDdlTriggerCollection class represents a collection of DatabaseDdlTrigger objects that represent all the database data definition language (DDL) triggers defined on a table.
Classe pública DatabaseDdlTriggerEvent The DatabaseDdlTriggerEvent object represents the SQL Server database DDL trigger events that can be included in a database DDL trigger event set.
Classe pública DatabaseDdlTriggerEventSet The DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events.
Classe pública DatabaseEncryptionKey Creates a database encryption key.
Classe pública DatabaseEncryptionKeyExtender Extends the database encryption key class.
Classe pública DatabaseEvent The DatabaseEvent object represents the SQL Server database events that can be included in a database event set.
Classe pública DatabaseEventArgs The DatabaseEventArgs object represents the arguments passed by the event raised by the database.
Classe pública DatabaseEvents The DatabaseEvents object represents the settings required for Microsoft SQL Server database event notification.
Classe pública DatabaseEventSet The DatabaseEventSet object represents a SQL Server set of database events.
Classe pública DatabaseFile The DatabaseFile object is a base class used in the construction of DataFile objects and LogFile objects.
Classe pública 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.
Classe pública DatabaseMaintenanceAdapter The Database Maintenance facet has logical properties. It inherits from the DatabaseAdapter class.
Classe pública DatabaseMapping The DatabaseMapping object represents a SQL Server database mapping.
Classe pública DatabaseMirroringPayload The DatabaseMirroringPayload object represents database mirroring payload settings.
Classe pública DatabaseOptions The DatabaseOptions object represents SQL Server database options.
Classe pública DatabasePerformanceAdapter The Database Performance facet implements logical properties relevant to database performance management.
Classe pública 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.
Classe pública DatabasePermissionInfo The DatabasePermissionInfo object represents information about a SQL Server database permission.
Classe pública DatabasePermissionSet O objeto DatabasePermissionSet representa um conjunto de permissões de banco de dados do SQL Server.
Classe pública DatabaseRole The DatabaseRole object represents a SQL Server database security role.
Classe pública DatabaseRoleCollection The DatabaseRoleCollection class represents a collection of DatabaseRole objects that represent all the database roles defined on the parent database.
Classe pública DatabaseSecurityAdapter Includes properties and methods that are used to expose the Database Security facet.
Classe pública DatabaseSnapshotExtender Adds methods and properties to the DatabaseSnapshot object.
Classe pública DataFile The DataFile object represents a SQL Server data file.
Classe pública DataFileCollection The DataFileCollection class represents a collection of DataFile objects that represent all the data files defined on the parent object.
Classe pública DataType The DataType object represents a SQL Server data type.
Classe pública 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.
Classe pública Default The Default object represents a SQL Server default.
Classe pública DefaultCollection The DefaultCollection class represents a collection of Default objects.
Classe pública DefaultConstraint The DefaultConstraint object represents a SQL Server default constraint.
Classe pública DefaultRuleBase The DefaultRuleBase class is a base class that is inherited by the Rule class and the Default class.
Classe pública DependencyCollection The DependencyCollection class represents a collection of Dependency objects that are used to derive the node classes in SMO scripting operations.
Classe pública DependencyCollectionNode The DependencyCollectionNode class represents a node in the dependency collection that is derived during scripting operations.
Classe pública DependencyNode The DependencyNode class represents a node that is defined by a URN address.
Classe pública DependencyTree The DependencyTree object represents a tree structure that contains SQL Server objects and their hierarchical relationships to each other.
Classe pública DependencyTreeNode The DependencyTreeNode class represents the child and sibling SQL Server objects within a DependencyTree object hierarchy.
Classe pública 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.
Classe pública Endpoint The Endpoint class represents an endpoint service that can listen natively for requests.
Classe pública EndpointCollection The EndpointCollection class represents a collection of Endpoint objects that represent all the HTTP endpoints.
Classe pública EndpointPayload The EndpointPayload object represents an endpoint payload.
Classe pública EndpointProtocol The EndpointProtocol object represents an HTTP endpoint protocol.
Classe pública EventProperty The EventProperty class represents a property of an event.
Classe pública EventPropertyCollection The EventPropertyCollection object represents the properties of event objects.
Classe pública EventSetBase The EventSetBase class is a base class that is used to derive the event set objects.
Classe pública ExtendedProperty The ExtendedProperty object represents the extended properties that are defined for any object that has an ExtendedProperties collection property.
Classe pública ExtendedPropertyCollection The ExtendedPropertyCollection class represents a collection of ExtendedPropertyCollectionobjects that represent all the extended properties.
Classe pública ExtendedStoredProcedure The ExtendedStoredProcedure object represents an extended stored procedure on the instance of Microsoft SQL Server.
Classe pública ExtendedStoredProcedureCollection The ExtendedStoredProcedureCollection class represents a collection of ExtendedStoredProcedure objects that represent all the extended stored procedures defined on the parent database.
Classe pública FailedOperationException A classe FailedOperationException representa a exceção gerada quando há falha em uma operação. . As operações de banco de dados com falhas incluem CREATE, DROP, ALTER, SCRIPT, REFRESH, RENAME. Esta exceção também pode ser gerada quando há falhas em alguns dos métodos públicos no SMO.
Classe pública FileGroup O objeto FileGroup representa um grupo de arquivos do SQL Server. Para obter mais informações sobre grupos de arquivos, consulte Usando grupos de arquivos e arquivos para armazenar dados.
Classe pública FileGroupCollection The FileGroupCollection class represents a collection of FileGroup objects that represent all the filegroups defined on the parent database.
Classe pública ForeignKey The ForeignKey object represents a SQL Server foreign key.
Classe pública ForeignKeyCollection The ForeignKeyCollection class represents a collection of ForeignKey objects that represent all the foreign keys defined on the parent object.
Classe pública ForeignKeyColumn The ForeignKeyColumn object represents a SQL Server foreign key column.
Classe pública ForeignKeyColumnCollection The ForeignKeyColumnCollection class represents a collection of ForeignKeyColumn objects that represent all the foreign key columns defined on the parent object.
Classe pública FrequencyPair The FrequencyPair object is a utility that measures frequency by storing count and duration information.
Classe pública FullTextCatalog The FullTextCatalog object represents a Microsoft Search full-text catalog.
Classe pública FullTextCatalogCollection The FullTextCatalogCollection class represents a collection of FullTextCatalog objects that represent all the full-text catalogs defined on the parent object.
Classe pública FullTextIndex The FullTextIndex object represents a Microsoft Search full-text index.
Classe pública FullTextIndexColumn The FullTextIndexColumn object represents a Microsoft Search full-text index column.
Classe pública FullTextIndexColumnCollection The FullTextIndexColumnCollection class represents a collection of FullTextIndexColumn objects that represent all the full-text index columns defined on the parent object.
Classe pública FullTextService The FullTextService object allows programmatic access to the Microsoft Search full-text settings.
Classe pública FullTextStopList The FullTextStopList object represents a full-text stop list.
Classe pública 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.
Classe pública HttpProtocol The HttpProtocol object represents an HTTP protocol on an instance of Microsoft SQL Server.
Classe pública Index The Index object represents a SQL Server index.
Classe pública IndexCollection The IndexCollection class represents a collection of Index objects that represent all the indexes defined on the instance of SQL Server.
Classe pública IndexedColumn The IndexedColumn object represents a SQL Server column that is participating in an index. 
Classe pública IndexedColumnCollection The IndexedColumnCollection class represents a collection of IndexedColumn objects that represent all the indexed columns defined on the instance of SQL Server.
Classe pública IndexEvents The IndexEvents object represents the settings that are required for SQL Server index event notification.
Classe pública 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.
Classe pública InternalSmoErrorException The InternalSmoErrorException class represents the exception raised when an error occurs during the internal phase of a SMO operation.
Classe pública InvalidSmoOperationException The InvalidSmoOperationException class represents the exception raised when an SMO operation is not valid.
Classe pública InvalidVersionSmoOperationException The InvalidVersionSmoOperationException class represents the exception raised when the version is not valid on an SMO operation.
Classe pública JobScheduleCollectionBase The JobScheduleCollectionBase class represents a base class that is used in the construction of the JobScheduleCollection class.
Classe pública 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.
Classe pública LanguageCollection The LanguageCollection class represents a collection of Language objects that represent all the languages which are defined on the instance of SQL Server.
Classe pública 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.
Classe pública LinkedServerCollection The LinkedServerCollection class represents a collection of LinkedServer objects that represent all the linked servers registered on the instance of SQL Server.
Classe pública LinkedServerLogin The LinkedServerLogin object represents a SQL Server logon account that has permission to connect to the linked server.
Classe pública LinkedServerLoginCollection The LinkedServerLoginCollection class represents a collection of LinkedServerLogin objects that represent all the linked server logins defined on the linked server.
Classe pública LogFile The LogFile object represents a SQL Server log file.
Classe pública LogFileCollection The LogFileCollection class represents a collection of LogFile objects that represent all the log files defined on the instance of Microsoft SQL Server.
Classe pública 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.
Classe pública LoginCollection The LoginCollection class represents a collection of Login objects that represent all the login accounts defined on the instance of SQL Server.
Classe pública LoginEvents The LoginEvents object represents the settings required for SQL Server login event notification.
Classe pública MasterKey The MasterKey object represents a SQL Server database master key.
Classe pública MessageCollectionBase A classe MessageCollectionBase é uma classe base usada na construção de classes de coleção de mensagens.
Classe pública MessageObjectBase The MessageObjectBase class is a base class that is inherited by message classes.
Classe pública MissingObjectException The MissingObjectException class represents the exception raised when an object is missing.
Classe pública NamedSmoObject The NamedSmoObject object represents a named SMO object.
Classe pública NumaNode The NumaNode object represents the settings for a NUMA node on an instance of SQL Server.
Classe pública NumaNodeCollection The NumaNodeCollection object contains information about one NUMA node on an instance of SQL Server.
Classe pública NumberedObjectCollectionBase The NumberedObjectCollectionBase class is a base class that represents common functionality for collections of numbered objects, such as the NumberedStoredProcedure object.
Classe pública NumberedStoredProcedure The NumberedStoredProcedure class represents a Microsoft SQL Server numbered stored procedure.
Classe pública NumberedStoredProcedureCollection The NumberedStoredProcedureCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on a table.
Classe pública NumberedStoredProcedureParameter The NumberedStoredProcedureParameter object represents a SQL Server numbered stored procedure parameter.
Classe pública NumberedStoredProcedureParameterCollection A classe NumberedStoredProcedureParameterCollection representa uma coleção de objetos NumberedStoredProcedure que representam todos os procedimentos armazenados numerados definidos no objeto pai.
Classe pública ObjectAlteredEventArgs The ObjectAlteredEventArgs object represents the arguments that are passed by the event that is raised when an object is altered.
Classe pública ObjectCreatedEventArgs The ObjectCreatedEventArgs object represents the arguments that are passed by the event that is raised when an object is created.
Classe pública ObjectDroppedEventArgs The ObjectDroppedEventArgs object represents the arguments that are passed by the event that is raised when an object is dropped.
Classe pública ObjectEvent The ObjectEvent object represents the of SQL Server object events that can be included in an object event set.
Classe pública ObjectEventSet The ObjectEventSet object represents a SQL Server set of object events.
Classe pública ObjectPermission The ObjectPermission object represents a SQL Server object permission.
Classe pública ObjectPermissionInfo The ObjectPermissionInfo object represents information about a SQL Server object permission.
Classe pública ObjectPermissionSet The ObjectPermissionSet object represents a set of object permissions in Microsoft SQL Server.
Classe pública ObjectRenamedEventArgs The ObjectRenamedEventArgs object represents the arguments passed by the event raised when an object is renamed.
Classe pública OleDbProviderSettings The OleDbProviderSettings object represents the setting for a SQL Server OLE DB provider.
Classe pública OleDbProviderSettingsCollection The OleDbProviderSettingsCollection class represents a collection of OleDbProviderSettings objects that represent all the OLE DB provider settings defined on the linked server.
Classe pública OrderColumn 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.
Classe pública OrderColumnCollection Represents a collection of OrderColumn.
Classe pública Parameter 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.
Classe pública ParameterBase 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.
Classe pública ParameterCollectionBase The ParameterCollectionBase class is a base class that is used in the construction of parameter collection classes.
Classe pública PartitionFunction The PartitionFunction object provides programmatic access to partition functions.
Classe pública PartitionFunctionCollection The PartitionFunctionCollection class represents a collection of PartitionFunction objects that represent all the partition functions defined on the instance of SQL Server.
Classe pública PartitionFunctionEvents The PartitionFunctionEvents object represents the settings required for SQL Server partition function event notification.
Classe pública PartitionFunctionParameter The PartitionFunctionParameter object provides programmatic access to partition function parameters.
Classe pública PartitionFunctionParameterCollection The PartitionFunctionParameterCollection class represents a collection of PartitionFunctionParameter objects that represent all the partition function parameters defined on the partition function.
Classe pública PartitionNumberedObjectCollectionBase A classe PartitionNumberedObjectCollectionBase é uma classe base herdada pela classe PhysicalPartitionCollection.
Classe pública PartitionScheme The PartitionScheme object provides programmatic access to partition schemes.
Classe pública PartitionSchemeCollection The PartitionSchemeCollection class represents a collection of PartitionScheme objects that represent all the partition schemes defined on the instance of SQL Server.
Classe pública PartitionSchemeEvents The PartitionSchemeEvents object represents the settings required for Microsoft SQL Server partition scheme event notification.
Classe pública PartitionSchemeParameter The PartitionSchemeParameter object provides programmatic access to partition scheme parameters.
Classe pública PartitionSchemeParameterCollection The PartitionSchemeParameterCollection class represents a collection of PartitionSchemeParameter objects that represent all the partition scheme parameters defined on the partition scheme.
Classe pública Payload The Payload object represents a SQL Server HTTP endpoint payload.
Classe pública PercentCompleteEventArgs The PercentCompleteEventArgs object represents the arguments passed by the event raised when a process reaches a percent complete marker.
Classe pública PerformanceCounters A PerformanceCounters object represents a performance counter that is used to trace the performance of the instance of SQL Server.
Classe pública PermissionInfo A classe PermissionInfo representa informações referentes a privilégios concedidos ou negados.
Classe pública PermissionSetBase A classe PermissionSetBase é uma classe base herdada por classes do conjunto de permissões.
Classe pública PhysicalPartition The PhysicalPartition object represents the physical partition where the data and meta data is stored for a SQL Server object.
Classe pública PhysicalPartitionCollection The PhysicalPartitionCollection class represents a collection of PhysicalPartition objects that represent all the physical partitions that are defined on an object.
Classe pública PlanGuide Creates a plan guide object: PlanGuide
Classe pública PlanGuideCollection Collection of plan guide objects.
Classe pública PlanGuideExtender Extends the Property set for a Plan Guide
Classe pública ProgressReportEventArgs 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.
Classe pública Property O objeto Property fornece acesso programático às propriedades de todos os objetos SMO.
Classe pública PropertyCannotBeRetrievedException The PropertyCannotBeRetrievedException class represents the exception raised when a property cannot be retrieved.
Classe pública PropertyCollection The PropertyCollection class represents a collection of Property objects that represent all the properties defined on the parent object.
Classe pública PropertyNotSetException The PropertyNotSetException class represents the exception that is raised when a property value has not been set.
Classe pública PropertyReadOnlyException The PropertyReadOnlyException class represents the exception that is raised when an attempt is made to set a read-only property.
Classe pública PropertyTypeMismatchException 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.
Classe pública PropertyWriteException The PropertyWriteException class represents the exception that is raised when an error occurs when setting the value of a property.
Classe pública Protocol The Protocol object provides programmatic access to the protocols supported by SQL Server.
Classe pública RelocateFile The RelocateFile object is a programmatic tool that lets a file be relocated.
Classe pública ResourceGovernor ResourceGovernor class.
Classe pública ResourcePool Resource Pool Class
Classe pública ResourcePoolCollection Represents a collection of Resource Pools.
Classe pública Restore The Restore object provides programmatic access to restore operations.
Classe pública Rule The Rule object provides programmatic access to a SQL Server rule.
Classe pública RuleCollection The RuleCollection class represents a collection of Rule objects that represent all the rules defined on the instance of SQL Server.
Classe pública Schema The Schema object represents an ownership context for a SQL Server database object.
Classe pública SchemaCollection The SchemaCollection class represents a collection of Schema objects that represent all the schemas on the referenced database.
Classe pública SchemaCollectionBase The SchemaCollectionBase class is a base class that is inherited by the SchemaCollection class.
Classe pública SchemaCustomResolver Represents a diagram of a COM-based resolver.
Classe pública SchemaEvents The SchemaEvents object represents the settings required for SQL Server schema event notification.
Classe pública Scripter The Scripter object is the overall, top-level object for managing scripting operations.
Classe pública ScriptingErrorEventArgs The ScriptingErrorEventArgs object provides programmatic access to the arguments used to report the errors that occur during scripting operations.
Classe pública ScriptingOptions The ScriptingOptions object provides programmatic options to the options that can be set for scripting operations.
Classe pública ScriptNameObjectBase The ScriptNameObjectBase is a base class inherited by classes that can use an alternative name used in scripting operations.
Classe pública ScriptOption O objeto ScriptOption representa as opções de script SQL Server que podem ser incluídas nas opções de script definidas com o uso do objeto ScriptingOptions.
Classe pública ScriptSchemaObjectBase A ScriptSchemaObjectBase é uma classe base herdada por classes que podem usar um nome alternativo empregado em operações de script.
Classe pública Server O objeto Server representa uma instância do SQL Server.
Classe pública ServerActiveDirectory The ServerActiveDirectory object provides programmatic access to the Active Directory functionality.
Classe pública ServerAdapter This class aggregates otherwise hidden server properties.
Classe pública ServerAdapterBase A ServerAdapterBase object is a base class that is used in the construction of the ServerAdapter class.
Classe pública ServerAuditSpecification The ServerAuditSpecification object represents an auditable event on the instance of SQL Server.
Classe pública ServerAuditSpecificationCollection The ServerAuditSpecificationCollection class represents a collection of ServerAuditSpecification objects that represent all the audit specifications defined on the server.
Classe pública ServerAuditSpecificationExtender Adds methods and properties to the ServerAuditSpecification object.
Classe pública ServerConfigurationAdapter Exposes methods to refresh and alter server configuration properties.
Classe pública ServerDdlTrigger The ServerDdlTrigger object represents a SQL Server data definition language (DDL) trigger.
Classe pública ServerDdlTriggerCollection The ServerDdlTriggerCollection class represents a collection of ServerDdlTrigger objects that represent all the server data definition language (DDL) triggers defined on a table.
Classe pública ServerDdlTriggerEvent 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.
Classe pública ServerDdlTriggerEventSet The ServerDdlTriggerEventSet object represents a set of SQL Server server data definition language (DDL) trigger events.
Classe pública ServerEvent The ServerEvent object represents the SQL Server server events that can be included in a server event set.
Classe pública ServerEventArgs 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.
Classe pública ServerEvents The ServerEvents object represents the settings required for SQL Server server-level event notification.
Classe pública ServerEventSet The ServerEventSet object represents a set of server events on an instance of SQL Server.
Classe pública ServerPermission The ServerPermission object represents a SQL Server server-level permission.
Classe pública ServerPermissionInfo The ServerPermissionInfo object represents information about a SQL Server server-level permission.
Classe pública ServerPermissionSet The ServerPermissionSet object represents a set of server permissions.
Classe pública ServerProxyAccount 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.
Classe pública ServerRole The ServerRole object represents a Microsoft SQL Server security role.
Classe pública ServerRoleCollection The ServerRoleCollection class represents a collection of ServerRole objects that represent all the server roles that are defined on a table.
Classe pública ServerSecurityAdapter A security facet that extends ServerAdapterBase.
Classe pública ServerSelectionAdapter Provides selection options for an instance of SQL Server.
Classe pública ServerSetupAdapter A ServerSetupAdapter object represents a server setup adapter.
Classe pública ServerSurfaceAreaAdapter A ServerSurfaceAreaAdapter object represents a server surface area adapter.
Classe pública ServerTraceEvent The ServerTraceEvent object represents the SQL Server server trace events that can be included in a server trace event set.
Classe pública ServerTraceEventSet The ServerTraceEventSet object represents a set server trace events.
Classe pública ServiceBrokerPayload The ServiceBrokerPayload object represents a SQL Server Service Broker payload.
Classe pública ServiceMasterKey The ServiceMasterKey object represents a Microsoft SQL Server service master key.
Classe pública ServiceQueueEvent The ServiceQueueEvent object represents the Service Broker service queue events that can be included in a service queue event set.
Classe pública ServiceQueueEventSet The ServiceQueueEventSet object represents a set of SQL Server service queue events.
Classe pública ServiceRequestException The ServiceRequestException class represents the exception that is raised when an error occurs during a service request.
Classe pública Settings O objeto Settings que representa um grupo de definições configuráveis na instância do SQL Server.
Classe pública SfcDependencyException The SfcDependencyException class represents an exception thrown by an SFC dependency operation fails.
Classe pública SimpleObjectCollectionBase The SimpleObjectCollectionBase class is a base class that is used in the construction of collection objects.
Classe pública SmoApplication The SmoApplication class represents an SMO application with respect to event management.
Classe pública SmoCollectionBase The SmoCollectionBase class is a base class that is used in the construction of SMO collection classes and contains members that are common to them.
Classe pública SmoDmfAdapter Implements Evaluate(IBaseManagementFacet)
Classe pública SmoEventArgs The SmoEventArgs object provides programmatic access to the arguments used to report the events that occur in SMO applications.
Classe pública SmoException The SmoException class represents the exception that is raised when an error occurs during an SMO operation.
Classe pública SmoObjectBase The SmoObjectBase is a base class that is inherited by the SqlSmoObject class.
Classe pública SmoObjectExtender< (Of < ( <'T> ) > ) > The SmoObjectExtender<(Of <(<'T>)>)> class adds methods and properties to an SqlSmoObject class instance.
Classe pública SoapMethodCollectionBase 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.
Classe pública SoapMethodObject The SoapMethodObject class provides programmatic access to the referenced SOAP method.
Classe pública SoapPayload The SoapPayload object represents a SQL Server SOAP payload.
Classe pública SoapPayloadMethod The SoapPayloadMethod class represents a SOAP payload method for the referenced HTTP endpoint.
Classe pública SoapPayloadMethodCollection The SoapPayloadMethodCollection class represents a collection of SoapPayloadMethod objects that represent all the SOAP payload methods defined on a table.
Classe pública SortedListCollectionBase The SortedListCollectionBase class is a base class that is used in the construction of sorted list collection classes.
Classe pública SqlAssembly The SqlAssembly class represents an assembly in the Microsoft .NET environment.
Classe pública SqlAssemblyCollection The SqlAssemblyCollection class represents a collection of SqlAssembly objects that represent all the assemblies defined on a table.
Classe pública SqlAssemblyEvent O objeto SqlAssemblyEvent representa os eventos de assembly do SQL Server que podem ser incluídos em um conjunto de eventos de assembly.
Classe pública SqlAssemblyEvents The SqlAssemblyEvents object represents the settings that are required for SQL Server assembly event notification.
Classe pública SqlAssemblyEventSet The SqlAssemblyEventSet object represents a set of assembly events.
Classe pública SqlAssemblyFile The SqlAssemblyFile object represents an assembly file that stores an assembly.
Classe pública SqlAssemblyFileCollection The SqlAssemblyFileCollection class represents a collection of SqlAssemblyFile objects that represent all the assembly files that are defined on a table.
Classe pública SqlPropertyCollection The SqlPropertyCollection class is an abstract class that is used in the management of object properties.
Classe pública SqlPropertyInfo The SqlPropertyInfo class is an abstract class used to store information about properties.
Classe pública SqlServerRegistrations Obsoleto. Represents registered instances of SQL Server.
Classe pública SqlSmoObject O objeto SqlSmoObject representa todos os objetos do SQL Server.
Classe pública Statistic The Statistic class represents a SQL Server statistic counter.
Classe pública StatisticCollection The StatisticCollection class represents a collection of Statistic objects that represent all the statistic counters defined on the table or view.
Classe pública StatisticColumn The StatisticColumn object represents a column defined in a SQL Server statistics counter.
Classe pública StatisticColumnCollection The StatisticColumnCollection class represents a collection of StatisticColumn objects that represent all the statistic columns defined on a table.
Classe pública StatisticEvents The StatisticEvents object represents the settings required for SQL Server statistic counter event notification.
Classe pública StoredProcedure O objeto StoredProcedure representa um procedimento armazenado do SQL Server.
Classe pública StoredProcedureCollection The StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures that are defined on a table.
Classe pública StoredProcedureEvent The StoredProcedureEvent object represents the SQL Server stored procedure events that can be included in an stored procedure event set.
Classe pública StoredProcedureEvents The StoredProcedureEvents object represents the settings that are required for SQL Server stored procedure event notification.
Classe pública StoredProcedureEventSet The StoredProcedureEventSet object represents a set of stored procedure events.
Classe pública StoredProcedureParameter The StoredProcedureParameter object represents a SQL Server stored procedure parameter.
Classe pública StoredProcedureParameterCollection The StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
Classe pública SymmetricKey The SymmetricKey object represents a SQL Server symmetric key.
Classe pública SymmetricKeyCollection The SymmetricKeyCollection class represents a collection of SymmetricKey objects that represent all the symmetric keys on the referenced database.
Classe pública SymmetricKeyEncryption The SymmetricKeyEncryption class represents the encryption type used when encrypting symmetric keys.
Classe pública Synonym The Synonym object represents a SQL Server synonym.
Classe pública SynonymCollection The SynonymCollection class represents a collection of Synonym objects that represent all the synonyms on the referenced database.
Classe pública SynonymEvents The SynonymEvents object represents the settings that are required for SQL Server synonym event notification.
Classe pública SystemDataType The SystemDataType object represents a supported system data type. The SystemDataTypeCollection represents all the supported system data types.
Classe pública SystemDataTypeCollection The SystemDataTypeCollection class represents a collection of SystemDataType objects that represent all the system data types on the referenced database.
Classe pública SystemMessage The SystemMessage object represents messages defined by the system.
Classe pública SystemMessageCollection The SystemMessageCollection class represents a collection of SystemMessage objects that represent all the system messages on the instance of SQL Server.
Classe pública Table O objeto Table representa uma tabela do SQL Server.
Classe pública TableCollection The TableCollection class represents a collection of Table objects that represent all the tables on the referenced database.
Classe pública TableEvent The TableEvent object represents the SQL Server table events that can be included in a table event set.
Classe pública TableEvents The TableEvents object represents the settings required for SQL Server table event notification.
Classe pública TableEventSet The TableEventSet object represents a set of table events.
Classe pública TableViewBase 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.
Classe pública TableViewTableTypeBase Classe base para tipos de exibição de tabela.
Classe pública TcpProtocol The TcpProtocol object provides programmatic access to the protocols supported by Microsoft SQL Server.
Classe pública Transfer The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.
Classe pública Trigger O objeto Trigger representa um gatilho do SQL Server.
Classe pública TriggerCollection The TriggerCollection class represents a collection of Trigger objects that represent all the triggers defined on a table.
Classe pública TriggerEvents The TriggerEvents object represents the settings that are required for SQL Server trigger event notification.
Classe pública UnknownPropertyException The UnknownPropertyException class represents the exception that is raised when an SMO operation encounters an unknown property.
Classe pública UnsupportedEngineTypeException 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 Mecanismo de banco de dados do SQL Server, or SQL Azure.
Classe pública UnsupportedFeatureException The UnsupportedFeatureException class represents the exception raised when an SMO operation encounters a request for an unsupported feature.
Classe pública UnsupportedObjectNameException The UnsupportedObjectNameException class represents the exception that is raised when an SMO operation encounters an unsupported object name.
Classe pública UnsupportedVersionException The UnsupportedVersionException class represents the exception raised when an SMO operation encounters an unsupported version of SQL Server.
Classe pública UrnCollection The UrnCollection class represents a collection of Urn objects that represent Uniform Resource Name (URN) addresses.
Classe pública User The User object represents a SQL Server user.
Classe pública UserCollection The UserCollection class represents a collection of User objects that represent all the database users defined on a database.
Classe pública UserDefinedAggregate The UserDefinedAggregate object represents a SQL Server user-defined aggregate.
Classe pública UserDefinedAggregateCollection The UserDefinedAggregateCollection class represents a collection of UserDefinedAggregate objects that represent all the database user-defined aggregates that are defined on a database.
Classe pública UserDefinedAggregateParameter The UserDefinedAggregateParameter object represents the parameters that are used with a user-defined aggregate.
Classe pública UserDefinedAggregateParameterCollection The UserDefinedAggregateParameterCollection class represents a collection of UserDefinedAggregateParameter objects that represent all the user-defined aggregate parameters that are defined on a table.
Classe pública UserDefinedDataType The UserDefinedDataType object represents a SQL Server user-defined data type.
Classe pública UserDefinedDataTypeCollection The UserDefinedDataTypeCollection class represents a collection of UserDefinedDataType objects that represent all the user-defined data types defined on a table.
Classe pública UserDefinedDataTypeResolver Resolves objects of user-defined types.
Classe pública UserDefinedFunction O objeto UserDefinedFunction representa uma função definida pelo usuário do SQL Server.
Classe pública UserDefinedFunctionCollection The UserDefinedFunctionCollection class represents a collection of UserDefinedFunction objects that represent all the user-defined functions that are defined on a table.
Classe pública UserDefinedFunctionEvent O objeto UserDefinedFunctionEvent representa os eventos da função SQL Server definida pelo usuário que podem ser incluídos em um conjunto de eventos de função definida pelo usuário.
Classe pública UserDefinedFunctionEvents The UserDefinedFunctionEvents object represents the settings that are required for SQL Server user-defined function event notification.
Classe pública UserDefinedFunctionEventSet The UserDefinedFunctionEventSet object represents a SQL Server set of user-defined function events.
Classe pública UserDefinedFunctionParameter The UserDefinedFunctionParameter object represents a SQL Server user-defined function parameter.
Classe pública UserDefinedFunctionParameterCollection The UserDefinedFunctionParameterCollection class represents a collection of UserDefinedFunctionParameter objects that represent all the user-defined function parameters that are defined on a table.
Classe pública UserDefinedMessage The UserDefinedMessage object represents a user-defined message.
Classe pública UserDefinedMessageCollection The UserDefinedMessageCollection class represents a collection of UserDefinedMessage objects that represent all the user-defined messages defined on a table.
Classe pública UserDefinedTableType The UserDefinedTableType object represents a SQL Server user-defined table type data type.
Classe pública UserDefinedTableTypeCollection The UserDefinedTableTypeCollection class represents a collection of UserDefinedTableType objects that represent all the user-defined table types that are defined on a database.
Classe pública UserDefinedTableTypeResolver Resolves the type of a user defined table to an Object.
Classe pública UserDefinedType The UserDefinedType represents an alias data type that is based on .NET data types.
Classe pública UserDefinedTypeCollection The UserDefinedTypeCollection class represents a collection of UserDefinedType objects that represent all the alias data types that are defined on a table.
Classe pública UserDefinedTypeEvents The UserDefinedTypeEvents object represents the settings required for SQL Server user-defined type event notification.
Classe pública UserDefinedTypeResolver Resolves user-defined data types.
Classe pública UserEvents The UserEvents object represents the settings that are required for SQL Server database user event notification.
Classe pública UserOptions The UserOptions object represents a set configurable server options that relate specifically to users.
Classe pública VerifyCompleteEventArgs 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.
Classe pública VersionSerializationAdapter Adapts the serialization mode to the version of SQL Server in use.
Classe pública View The View object represents a SQL Server view. 
Classe pública ViewCollection The ViewCollection class represents a collection of View objects that represent all the views defined on a table.
Classe pública ViewEvent The ViewEvent object represents the SQL Server view events that can be included in a view event set.
Classe pública ViewEvents The ViewEvents object represents the settings that are required for SQL Server view event notification.
Classe pública ViewEventSet The ViewEventSet object represents a set of view events.
Classe pública WorkloadGroup 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.
Classe pública WorkloadGroupCollection Initializes a workload group.
Classe pública WrongPropertyValueException The WrongPropertyValueException class represents the exception that is raised when a property is assigned the wrong value.
Classe pública XmlSchemaCollection 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.
Classe pública XmlSchemaCollectionCollection 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.

Estruturas

  Estrutura Descrição
Estrutura pública AuditSpecificationDetail The AuditSpecificationDetail object represents a SQL Server audit specification detail required when creating an audit.
Estrutura pública DdlTextParserHeaderInfo This class supports the SMO infrastructure and is not intended to be used directly from your code.

Interfaces

  Interface Descrição
Interface pública IColumnPermission The IColumnPermission class represents the interface that manages permissions for a specified column.
Interface pública IDatabaseMaintenanceFacet Interface that defined methods and properties for the database maintenance facet.
Interface pública IDatabaseOptions Interface with properties that expose database options.
Interface pública IDatabasePerformanceFacet Defines methods and properties that can be used to measure and influence database performance.
Interface pública IDatabaseSecurityFacet Security facet interface.
Interface pública IExtendedProperties The IExtendedProperties class is an interface that represents the collection of extended properties associated with an object.
Interface pública ILoginOptions The ILoginOptions class is an interface that represents a collection of options associated with a login.
Interface pública IMultipartNameFacet Interface to deal with object names containing both the object and the schema.
Interface pública INameFacet Represents the name facet interface.
Interface pública IObjectPermission The IObjectPermission class represents the interface used to set object permissions.
Interface pública IScriptable The IScriptable class represents the interface used to create Transact-SQL scripts of SMO objects.
Interface pública IServerAuditFacet Interface that identifies audit facet members.
Interface pública IServerConfigurationFacet Contains configuration information for interfaces based on the Configuration object.
Interface pública IServerInformation An interface based on the Information type properties.
Interface pública IServerPerformanceFacet An interface for the performance facet.
Interface pública IServerSecurityFacet An interface that defines members for the SeverSecurityFacet.
Interface pública IServerSelectionFacet The IServerSelectionFacet class contains members that represent the SQL Server policy-based management server selection facet objects.
Interface pública IServerSettings An interface for SQL Server 2008 Policy-Based Management that is based on Settings.
Interface pública IServerSetupFacet Represents the Policy-Based Management facet interface for setting up an instance of SQL Server.
Interface pública ISurfaceAreaFacet An interface that defines surface area facet members.
Interface pública ITableOptions The ITableOptions class is an interface that represents a collection of options that is associated with a table.
Interface pública ITextObject The ITextObject class represents the interface that is used to implement text on objects.
Interface pública IUserOptions The IUserOptions class is an interface that represents a collection of options that is associated with a user.
Interface pública IViewOptions The IViewOptions class is an interface that represents a collection of options that is associated with a view.

Delegados

  Delegado Descrição
Delegado público PercentCompleteEventHandler The PercentCompleteEventHandler class represents the event handler that is used to handle percent complete events.
Delegado público ProgressReportEventHandler The ProgressReportEventHandler class represents the event handler that is used to handle progress report events.
Delegado público ScriptingErrorEventHandler The ScriptingErrorEventHandler class represents the event handler that is used to handle scripting errors.
Delegado público ScriptingFilter Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. Supplies filtering for scripts.
Delegado público ServerEventHandler The ServerEventHandler class represents the event handler that is used to handle server errors.
Delegado público SmoApplication. . :: . .AnyObjectEventHandler The SmoApplication..::..AnyObjectEventHandler class represents the event handler that is used to handle events from any object.
Delegado público SmoApplication. . :: . .DatabaseEventHandler The SmoApplication..::..DatabaseEventHandler class represents the event handler that handles database events.
Delegado público SmoApplication. . :: . .ObjectAlteredEventHandler The SmoApplication..::..ObjectAlteredEventHandler class represents the event handler that is used to handle events that occur when an object is altered.
Delegado público SmoApplication. . :: . .ObjectCreatedEventHandler The SmoApplication..::..ObjectCreatedEventHandler class represents the event handler that is used to handle events when an object is created.
Delegado público SmoApplication. . :: . .ObjectDroppedEventHandler The SmoApplication..::..ObjectDroppedEventHandler class represents the event handler that is used to handle events when an object is dropped.
Delegado público SmoApplication. . :: . .ObjectRenamedEventHandler The SmoApplication..::..ObjectRenamedEventHandler class represents the event handler that handles events that occur when an object is renamed.
Delegado público VerifyCompleteEventHandler The VerifyCompleteEventHandler class represents the event handler that handles completion events.

Enumerações

  Enumeração Descrição
Enumeração pública ActivationExecutionContext The ActivationExecutionContext enumeration contains values that specify the security context used by a procedure. These procedures are activated by a service queue.
Enumeração pública AffinityType The AffinityType enumeration represents the possible affinity settings for an instance of SQL Server.
Enumeração pública AssemblyAlterOptions 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.
Enumeração pública AssemblySecurityLevel The AssemblySecurityLevel enumeration contains values that are used to specify the access rights for an assembly.
Enumeração pública AsymmetricKeyEncryptionAlgorithm The AsymmetricKeyEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an asymmetric key.
Enumeração pública AsymmetricKeySourceType The AsymmetricKeySourceType enumeration contains values that are used to specify the source type used to load an asymmetric key.
Enumeração pública AttachOptions The AttachOptions enumeration contains values that are used to specify attach options.
Enumeração pública AuditActionType The AuditActionType enumeration contains values that are used to specify the audit action types.
Enumeração pública AuditDestinationType The AuditDestination enumeration contains values that are used to specify the destination, to which the results of a SQL Server Audit are sent.
Enumeração pública AuditFileSizeUnit The AuditFileSizeUnit enumeration contains values that are used to specify the unit that specifies the size of the audit file.
Enumeração pública AuditLevel The AuditLevel enumeration contains values that are used to specify the SQL Server audit level setting.
Enumeração pública AuditStatusType The AuditStatusType enumeration contains values that are used to specify the status of the audit.
Enumeração pública BackupActionType The BackupActionType enumeration contains values that are used to specify the type of backup.
Enumeração pública BackupCompressionOptions The BackupCompressionOptions enumeration contains values that are used to specify the backup compression option.
Enumeração pública BackupDeviceType The BackupDeviceType enumeration contains values that are used to specify the backup device type.
Enumeração protegida BackupRestoreBase. . :: . .AsyncOperation The BackupRestoreBase..::..AsyncOperation enumeration contains values that are used to specify which backup components are running asynchronously.
Enumeração pública BackupSetFlag The BackupSetFlag enumeration contains values that are used to specify the purpose of the backup.
Enumeração pública BackupSetType The BackupSetType enumeration contains values that are used to specify the backup type.
Enumeração pública BackupTruncateLogType The BackupTruncateLogType enumeration contains values that are used to specify the truncate action taken on the log.
Enumeração pública CatalogPopulationAction The CatalogPopulationAction enumeration contains values that are used to specify the method used to populate a full-text catalog.
Enumeração pública CatalogPopulationStatus The CatalogPopulationStatus enumeration contains values that are used to specify the status of the full-text catalog.
Enumeração pública CertificateSourceType The CertificateSourceType enumeration contains values that are used to specify the source of the certificate.
Enumeração pública ChangeTracking The ChangeTracking enumeration contains values that are used to specify change tracking in a full-text index.
Enumeração pública CollationVersion The CollationVersion enumeration contains values that specify the collation versions.
Enumeração pública CompatibilityLevel The CompatibilityLevel enumeration is a list of constant values that specify the behavior that corresponds to a version of SQL Server.
Enumeração pública CreateDispositionType The CreateDispositionType enumeration contains values that are used to specify the source of the symmetric key.
Enumeração pública DatabaseDdlTriggerExecutionContext The DatabaseDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the database DDL trigger runs.
Enumeração pública DatabaseEncryptionAlgorithm Specifies the algorithm used to encrypt the database encryption key
Enumeração pública DatabaseEncryptionState Enumerates the possible encryption states of a database.
Enumeração pública DatabaseEncryptionType The DatabaseEncryptionType enumeration contains values that are used to specify the encryption types.
Enumeração pública DatabaseEventType The DatabaseEventType enumeration is a list of constant values that specify the database event type.
Enumeração pública DatabaseObjectTypes The DatabaseObjectTypes enumeration is a list of constant values that specifies the types of database object.
Enumeração pública DatabasePermissionSetValue The DatabasePermissionSetValue enumeration is a list of constant values that specify all the database permissions.
Enumeração pública DatabaseStatus 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.
Enumeração pública DatabaseUserAccess The DatabaseUserAccess enumeration is a list of constant values that specify how user access can be restricted.
Enumeração pública DataCompressionType The DataCompressionType enumeration contains values that are used to specify the type of data compression used to store data on the physical partition.
Enumeração pública DependencyType A enumeração DependencyType é uma lista de valores de constante que especifica a direção da operação de descoberta de dependência.
Enumeração pública DeviceType The DeviceType enumeration is a list of constant values that specify the various different types of devices supported by SQL Server.
Enumeração pública Edition The Edition enumeration is a list of constant values that specify the various different types of devices that are supported by SQL Server.
Enumeração pública EndpointAuthenticationOrder The EndpointAuthenticationOrder enumeration contains values that are used to specify the authentication methods and order of preference for the endpoint connection.
Enumeração pública EndpointEncryption The EndpointEncryption enumeration contains values that are used to specify the state of encryption on the endpoint.
Enumeração pública EndpointEncryptionAlgorithm The EndpointEncryptionAlgorithm enumeration contains values that are used to specify an encryption algorithm used on an endpoint.
Enumeração pública EndpointState The EndpointState enumeration is a list of constant values that specifies the state of the HTTP endpoint.
Enumeração pública EndpointType The EndpointType enumeration is a list of constant values that specifies the type of HTTP endpoint.
Enumeração pública EventType The EventType enumeration is a list of constant values that specify the various different types of events that are supported by SQL Server.
Enumeração pública ExecutionContext 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.
Enumeração pública ExecutionStatus The ExecutionStatus enumeration is a list of constant values that specify the status of an executing process.
Enumeração pública FileGrowthType The FileGrowthType enumeration is a list of constant values that specify whether file growth is determined by percentage amount or by KB.
Enumeração pública FilestreamAccessLevelType The FilestreamAccessLevelType enumeration contains values that are used to specify the type of access permitted on file stream operations.
Enumeração pública FileStreamEffectiveLevel The FileStreamEffectiveLevel enumeration contains values that are used to specify the file stream level.
Enumeração pública FileStreamLevel The FileStreamLevel enumeration contains values that are used to specify the file stream level.
Enumeração pública ForeignKeyAction 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.
Enumeração pública FragmentationOption The FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.
Enumeração pública FullTextCatalogUpgradeOption The FullTextCatalogUpgradeOption enumeration contains values that are used to specify the action taken when the full-text catalog is upgraded.
Enumeração pública HttpAuthenticationModes The HttpAuthenticationModes enumeration contains values that specify the HTTP port for HTTP endpoints.
Enumeração pública HttpPortTypes The HttpPortTypes enumeration contains values that are used to specify the type HTTP port.
Enumeração pública ImplementationType 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.
Enumeração pública IndexEnableAction 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.
Enumeração pública IndexKeyType The IndexKeyType enumeration contains values that are used to specify the type of key on which the index is created.
Enumeração pública IndexOperation The IndexOperation enumeration contains values that are used to specify index operations.
Enumeração pública IndexPopulationAction The IndexPopulationAction enumeration contains values that are used to specify the type of Microsoft Search full-text index population.
Enumeração pública IndexPopulationStatus The IndexPopulationStatus enumeration contains values that are used to specify the type of population in progress.
Enumeração pública InDoubtTransactionResolutionType Enumerates possible responses to in-doubt transactions.
Enumeração pública KeyEncryptionType The KeyEncryptionType enumeration is a list of constant values that specify the key encryption type.
Enumeração pública LinkedTableType The LinkedTableType enumeration contains values that specify the type of table accessed on a linked server.
Enumeração pública LinkFieldType The LinkFieldType enumeration contains values that specify the type of link field.
Enumeração pública LockEscalationType An enumeration that lists lock escalation types.
Enumeração pública LockRequestStatus The LockRequestStatus enumeration contains constant values that specify the lock request status.
Enumeração pública LoginCreateOptions The LoginCreateOptions enumeration contains values that are used to specify the password options when you create a logon.
Enumeração pública LoginType The LoginType enumeration contains values that are used to specify the authentication type and the Windows account type.
Enumeração pública LogReuseWaitStatus The LogReuseWaitStatus enumeration contains values that specify the current operation on which the reuse of transaction log space is waiting.
Enumeração pública MappedClassType Enumerates credential mapping options.
Enumeração pública MediaTypes 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.
Enumeração pública MethodLoginType The MethodLoginType enumeration contains values that are used to specify the method used for logging on to the instance of SQL Server.
Enumeração pública MethodXsdSchemaOption The MethodXsdSchemaOption enumeration contains values that specify the XSD schema returned for a SOAP method.
Enumeração pública MirroringOption The MirroringOption enumeration contains values that specify the mirroring options for a database.
Enumeração pública MirroringRole The MirroringRole enumeration contains values that specify the role the database plays in mirroring.
Enumeração pública MirroringSafetyLevel The MirroringSafetyLevel enumeration contains values that specify the safety guarantee on updates to the mirrored database.
Enumeração pública MirroringStatus The MirroringStatus enumeration contains values that specify the state of a database regarding mirroring.
Enumeração pública MirroringWitnessStatus The MirroringWitnessStatus enumeration contains values that specify the state of the mirroring witness.
Enumeração pública Month The Month enumeration contains constant values that specify the twelve calendar months.
Enumeração pública NSActivationState The NSActivationState enumeration contains constant values that specify the activation state of Notification Services.
Enumeração pública NumaNodeAffinity The NumaNodeAffinity enumeration defines the affinity states for a Cpu object.
Enumeração pública ObjectClass The ObjectClass enumeration contains values that specify the SMO class type.
Enumeração pública ObjectPermissionSetValue The ObjectPermissionSetValue enumeration is a list of constant values that specify all the object permissions.
Enumeração pública OnFailureAction The OnFailureAction enumeration contains values that specify the action to be taken when an audit fails.
Enumeração pública PageVerify The PageVerify enumeration contains constant values that specify the automatic page verification options for a database.
Enumeração pública PerfMonMode The PerfMonMode enumeration contains values that are used to specify the polling behavior in Performance Monitor.
Enumeração pública PermissionState The PermissionState enumeration contains values that specify the state of a permission.
Enumeração pública PlanGuideType Enumerates the possible Plan Guide types.
Enumeração pública PrincipalType The PrincipalType enumeration contains values that specify the type of user, role, or login.
Enumeração pública PrivateKeyEncryptionType 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.
Enumeração pública PrivilegeTypes 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.
Enumeração pública ProtocolType The ProtocolType enumeration contains values that are used to specify the type of protocol.
Enumeração pública ProviderAuthenticationType Specifies the type of authentication supported by Cryptographic Provider.
Enumeração pública RangeType The RangeType enumeration contains values that are used to specify the type range.
Enumeração pública RecoveryModel The RecoveryModel enumeration contains values that are used to specify the type of recovery model.
Enumeração pública RepairOptions The RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.
Enumeração pública RepairStructure The RepairRepairStructure enumeration contains values that are used to specify the type of repair options used when checking data in a table.
Enumeração pública RepairType The RepairType enumeration contains values that are used to specify the type of repair mode used by the database consistency check (DBCC) functions.
Enumeração pública ReplicationOptions The ReplicationOptions enumeration contains values that are used to specify the replication settings for the referenced database.
Enumeração pública ResourceUsage The ResourceUsage enumeration contains values that specify the relative operating system execution priority setting for the Microsoft Search service.
Enumeração pública RestoreActionType The RestoreActionType enumeration contains values that are used to specify the type of action that is required during a data restore operation.
Enumeração pública RestoreType The RestoreType enumeration contains values that specify the type of restore operation to perform.
Enumeração pública ResultFormat The ResultFormat enumeration contains values that specify the format in which to return results for an HTTP endpoint.
Enumeração pública RetentionPeriodUnits Enumerates values that specify the units for the retention period.
Enumeração pública RoleTypes The RoleTypes enumeration contains values that are used to specify the type of role.
Enumeração pública SecondaryXmlIndexType The SecondaryXmlIndexType enumeration contains values that are used to specify the secondary XML index type.
Enumeração pública ServerDdlTriggerExecutionContext The ServerDdlTriggerExecutionContext enumeration contains values that are used to specify the execution context under which the server DDL trigger runs.
Enumeração pública ServerLoginMode The ServerLoginMode enumeration contains values that are used to specify the method used to connect to the instance of SQL Server.
Enumeração pública ServerMirroringRole The ServerMirroringRole enumeration contains values that are used to specify the role of the instance of SQL Server when participating in mirroring.
Enumeração pública ServerPermissionSetValue The ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.
Enumeração pública ServerStatus The ServerStatus enumeration contains values that are used to specify the status of the instance of SQL Server.
Enumeração pública ServiceStartMode The ServiceStartMode enumeration contains values that are used to specify the method that is used to start a service.
Enumeração pública ShrinkMethod The ShrinkMethod enumeration contains values that are used to specify the method that is used shrink a database file.
Enumeração pública SmoExceptionType The SmoExceptionType enumeration contains values that are used to specify the type of SMO exception.
Enumeração pública SnapshotIsolationState The SnapshotIsolationState enumeration contains values that are used to specify the current state of snapshot isolation.
Enumeração pública SortOrder The SortOrder enumeration contains values that specify how objects are sorted in an enumerated list.
Enumeração pública SpatialGeoLevelSize Enumerates grid density levels for spatial indexes.
Enumeração pública SpatialIndexType Enumerates possible spatial index types.
Enumeração pública SqlDataType The SqlDataType enumeration contains values that are used to specify a SQL Server data type.
Enumeração pública SqlServerVersion The SqlServerVersion enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
Enumeração pública SqlServerVersions The SqlServerVersions enumeration contains values that are used to specify the version of the referenced instance of SQL Server.
Enumeração pública SqlSmoState The SqlSmoState enumeration contains values that are used to specify the state of an SMO object.
Enumeração pública SqlVerifyAction The SqlVerifyAction enumeration contains values that are used to specify the type of backup verification.
Enumeração pública StatisticsScanType 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.
Enumeração pública StatisticsTarget The StatisticsTarget enumeration contains values that specify the type of statistic that is targeted for the update operation.
Enumeração pública StopListOption The StopListOption enumeration contains values that are used to specify the way in which a new stop list is created.
Enumeração pública SymmetricKeyEncryptionAlgorithm The SymmetricKeyEncryptionAlgorithm enumeration contains values that specify the algorithm that is used to encrypt the symmetric key.
Enumeração pública SymmetricKeyEncryptionType The SymmetricKeyEncryptionType enumeration contains constant values that specify the type of symmetric key encryption.
Enumeração pública SynonymBaseType The SynonymBaseType enumeration contains constant values that specify the type of synonym.
Enumeração pública TerminationClause The TerminationClause enumeration contains constant values that specify the action taken when transactions are terminated.
Enumeração pública TransactionTypes The TransactionTypes enumeration contains constant values that specify the method of recording transactions.
Enumeração pública UrnIdOption Enumerates URN identification options.
Enumeração pública UserDefinedFunctionType The UserDefinedFunctionType enumeration is a list of constant values that specify the types of user-defined functions that are supported by SQL Server.
Enumeração pública UserDefinedTypeFormat The UserDefinedTypeFormat enumeration is a list of constant values that specify the formats used by user-defined types.
Enumeração pública UserType The UserType enumeration contains constant values that specify the security type for the user.
Enumeração pública WindowsLoginAccessType The WindowsLoginAccessType enumeration contains constant values that specify the type of access a Windows login has to the instance of SQL Server.
Enumeração pública WorkloadGroupImportance The WorkloadGroupImportance enumeration contains values that specify the importance of workload groups.
Enumeração pública WsdlGeneratorOption The WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
Enumeração pública XmlDocumentConstraint The XmlDocumentConstraint enumeration contains constant values that specify the constraints imposed on an XML document.
Enumeração pública XmlFormatOption The WsdlGeneratorOption enumeration contains constant values that specify the Web Services Description Language (WSDL) generator options.
Enumeração pública XmlTypeDerivation The XmlTypeDerivation enumeration contains constant values that specify the XML type derivation.
Enumeração pública XmlTypeKind The XmlTypeKind enumeration contains constant values that specify the kind of XML component.
Enumeração pública XsdSchemaOption The XsdSchemaOption enumeration contains constant values that specify whether an inline schema for the method result is returned in the SOAP response.