Microsoft.SqlServer.Management.Smo Namespace
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Classes
| AbortAfterWaitConverter | |
| AbstractCollectionBase |
Base class for all SMO collections |
| AffinityInfo |
AffinityInfo |
| AffinityInfoBase |
AffinityInfoBase |
| AgentSubSystemTypeConverter | |
| ApplicationRole |
Instance class encapsulating : Server[@Name='']/Database/ApplicationRole |
| ApplicationRoleCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ApplicationRoleEvents | |
| ArrayListCollectionBase | |
| AsymmetricKey |
Instance class encapsulating : Server[@Name='']/Database/AsymmetricKey |
| AsymmetricKeyCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| AsyncStatus |
A helper class that describes status and last exception from an asynchronous operation. |
| Audit |
Instance class encapsulating : Server[@Name='']/Audit |
| AuditActionTypeConverter | |
| AuditCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| AuditDestinationTypeConverter | |
| AuditExtender | |
| AuditSpecification | |
| AvailabilityDatabase |
An Availability Database represents a database that is part of an Availability Group. |
| AvailabilityDatabaseCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| AvailabilityGroup |
An Availability Group (AG) is the unit of high availability. It represents a collection of related databases that form the business critical application that needs high availability and disaster recovery capability. |
| AvailabilityGroupCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| AvailabilityGroupListener |
this is the partial class of code-gen AvailabilityGroupListener |
| AvailabilityGroupListenerCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| AvailabilityGroupListenerIPAddress |
this is the partial class of code-gen AvailabilityGroupListenerIPAddress |
| AvailabilityGroupListenerIPAddressCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their IPAddress and SubnetMask and SubnetIP properties |
| AvailabilityGroupListenerIPAddressCollectionBase | |
| AvailabilityGroupState |
This is an adapter class that implements the IAvailabilityGroupState logical facet for an Availability Group. |
| AvailabilityReplica |
An Availability Replica is an instance of SQL Server that is part of an Availability Group. The replica hosts copies of the databases in a group. Depending on its current roles, the replica can be the primary of the Availability Group or one of many secondaries. |
| AvailabilityReplicaCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| Backup | |
| BackupDevice |
Instance class encapsulating : Server[@Name='']/BackupDevice |
| BackupDeviceCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| BackupDeviceItem |
Represents a device that will be used to backup to or restore from |
| BackupDeviceList |
Strongly typed list of BackupDeviceItem objects |
| BackupEncryptionOptions |
The BackupEncryptionOptions represents encryption options for backup operations. |
| BackupMedia |
Backup Media class |
| BackupMediaSet |
Backup Media Set |
| BackupMediaSet.IncompleteBackupMediaSetException |
Incomplete backup MediaSet Exception |
| BackupRestoreBase | |
| BackupSet |
Backupset class |
| BackupSetCollection |
Backupset collection class |
| CatalogCollationTypeConverter | |
| Certificate |
Instance class encapsulating : Server[@Name='']/Database/Certificate |
| CertificateCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| CertificateEvents | |
| Check |
Instance class encapsulating : Server[@Name='']/Database/Table/Check |
| CheckCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| CollationInfo |
Provides information about a specific database collation. |
| CollectionNotAvailableException |
The exception thrown when the user is asking for a collection not available for the current server version. |
| Column |
Instance class encapsulating : Server[@Name='']/Database/Table/Column |
| ColumnCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ColumnEncryptionKey |
Represents a sql server column encryption key object |
| ColumnEncryptionKeyCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ColumnEncryptionKeyValue |
Represents a sql server column encryption key value object. |
| ColumnEncryptionKeyValueCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ColumnEncryptionKeyValueCollectionBase |
ColumnEncryptionKeyValueCollectionBase |
| ColumnMasterKey |
Represents a sql server Column Master Key object |
| ColumnMasterKeyCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ConfigProperty |
Instance class encapsulating SQL Server database table trigger |
| ConfigPropertyCollection | |
| Configuration |
Instance class encapsulating SQL Server Configuration object |
| ConfigurationBase | |
| Cpu |
CPU class |
| CpuCollection |
CPU Collection Class |
| CreateRestorePlanEventArgs |
Create restore plan status event args |
| Credential |
Instance class encapsulating : Server[@Name='']/Credential |
| CredentialCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| CryptographicProvider |
Instance class encapsulating : Server[@Name='']/CryptographicProvider |
| CryptographicProviderCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| Database |
Instance class encapsulating : Server[@Name='']/Database |
| DatabaseActiveDirectory | |
| DatabaseAdapter | |
| DatabaseAdapterBase | |
| DatabaseAuditSpecification |
Instance class encapsulating : Server[@Name='']/Database/DatabaseAuditSpecification |
| DatabaseAuditSpecificationCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| DatabaseAuditSpecificationExtender | |
| DatabaseCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| DatabaseDdlTrigger |
Instance class encapsulating : Server[@Name='']/Database/DdlTrigger |
| DatabaseDdlTriggerCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| DatabaseDdlTriggerEvent |
DatabaseDdlTriggerEvent |
| DatabaseDdlTriggerEventSet |
class DatabaseDdlTriggerEventSet |
| DatabaseEncryptionKey |
Instance class encapsulating : Server[@Name='']/Database/DatabaseEncryptionKey |
| DatabaseEncryptionKeyExtender | |
| DatabaseEvent | |
| DatabaseEventArgs |
Provides information about a change to a Database SMO object |
| DatabaseEvents | |
| DatabaseEventSet | |
| DatabaseFile |
Base class for DataFile and LogFile |
| DatabaseFileMappingsDictionary |
This class maps database file paths (i.e. DataFiles and LogFiles paths) from the source server to the corresponding target server location specified by the user. |
| DatabaseMaintenanceAdapter |
The Database Maintenance facet has logical properties. It inherts from the DatabaseAdapter class. |
| DatabaseMapping |
this is a structure to hold database mappings |
| DatabaseMirroringPayload |
Instance class encapsulating : Server[@Name='']/Endpoint/DatabaseMirroring |
| DatabaseOptions |
Instance class encapsulating : Server[@Name='']/Database/Option |
| DatabasePerformanceAdapter |
The Database Performance facet implements logical properties and requires overriding Refresh and Alter Thus it is a new class. |
| DatabasePermission | |
| DatabasePermissionInfo | |
| DatabasePermissionSet | |
| DatabaseReplicaState |
This class represents the runtime state of a database that's participating in an availability group. This database may be located on any of the replicas that compose the availability group. |
| DatabaseReplicaStateCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their AvailabilityReplicaServerName and AvailabilityDatabaseName properties |
| DatabaseReplicaStateCollectionBase |
this is the class that contains common features of all schema collection classes |
| DatabaseRestorePlanner |
Database Restore Planner. |
| DatabaseRole |
Instance class encapsulating : Server[@Name='']/Database/Role |
| DatabaseRoleCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| DatabaseScopedConfiguration |
The partial definition of the DatabaseScopedConfiguration class. https://msdn.microsoft.com/en-us/library/mt629158.aspx |
| DatabaseScopedConfigurationCollection |
DatabaseScopedConfigurationCollection |
| DatabaseScopedConfigurationOnOffConverter | |
| DatabaseScopedCredential |
Instance class encapsulating : Server[@Name='']/Database/DatabaseScopedCredential |
| DatabaseScopedCredentialCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| DatabaseSecurityAdapter |
Database security adds properties from the children and some computed properties. It inherits from the DatabaseAdapter. |
| DatabaseSnapshotExtender |
Extender class for Database Snapshot |
| DataFile |
This class incapsulates a database data file |
| DataFileCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| DataTransferBase | |
| DataType |
The DataType object allows users to define a SQL Server data type. |
| DdlTriggerBase | |
| Default |
Instance class encapsulating : Server[@Name='']/Database/Default |
| DefaultCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| DefaultConstraint |
Instance class encapsulating : Server[@Name='']/Database/Table/Column/Default |
| DefaultLanguage |
This object manages the lcid and name properties for both the user and database SMO objects. Methods are provided to read and write both the default and fulltext properties. |
| DefaultRuleBase | |
| DependencyCollection |
Dependency tree returned as a result of dependency discovery phase |
| DependencyCollectionNode |
DependencyCollectionNode class represents an individual entry in the dependency list |
| DependencyNode |
DependencyNode is a base node class Contains the urn of the node and the dependency type (SchemaBound/NonSchemaBound) the node has with its parent |
| DependencyTree |
Dependency tree returned as a result of dependency discovery phase |
| DependencyTreeNode |
DependencyTreeNode class represents an individual entry in the dependency tree |
| DependencyWalker |
Instance class encapsulating SQL Server database |
| DwTableDistributionConverter | |
| DwViewDistributionConverter | |
| EdgeConstraint |
This class represents an Edge Constraint object. Edge Constraints restrict connections that can be established in an edge table between two graph nodes. Edge Constraints are creatable and droppable but not alterable. For altering the original must be dropped and new one must be created. |
| EdgeConstraintClause |
Represents an EdgeConstraintClause object. Objects of EdgeConstraintClause types are encapsulated within an EdgeConstraint and represent allowed connections between two graph nodes. |
| EdgeConstraintClauseCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| EdgeConstraintCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| Endpoint |
Instance class encapsulating : Server[@Name='']/Endpoint |
| EndpointCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| EndpointPayload | |
| EndpointProtocol | |
| EnumToDisplayNameConverter |
Converts the specified value object to an enumeration object. |
| EventProperty |
A name-value type of class that holds a single event property. |
| EventPropertyCollection |
A specialized name-object collection (dictionary) used for event properties. |
| EventSetBase |
Abstract class for all Event classes. |
| ExecutionManager |
encapsulates ConnectionContext and isolates it from the rest of SMO |
| ExtendedProperty |
Instance class encapsulating : Server[@Name='']/Database/Table/ExtendedProperty |
| ExtendedPropertyCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ExtendedStoredProcedure |
Instance class encapsulating : Server[@Name='']/Database/ExtendedStoredProcedure |
| ExtendedStoredProcedureCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| ExternalDataSource |
Represents a SQL server external data source object. |
| ExternalDataSourceCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ExternalDataSourcePushdownOptionConverter | |
| ExternalDataSourceTypeConverter | |
| ExternalFileFormat |
Represents a SQL server External File Format object. |
| ExternalFileFormatCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ExternalFileFormatTypeConverter | |
| ExternalLibrary |
Instance class encapsulating : Server[@Name='']/Database/ExternalLibrary |
| ExternalLibraryCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ExternalLibraryFile |
Instance class encapsulating : Server[@Name='']/Database/ExternalLibrary/ExternalLibraryFile |
| ExternalResourcePool |
Represents a SQL server external resource pool object. |
| ExternalResourcePoolAffinityInfo |
ExternalResourcePoolAffinityInfo |
| ExternalResourcePoolCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ExternalTableDistributionConverter | |
| ExternalTableRejectTypeConverter | |
| FailedOperationException |
The exception thrown when an operation has failed. |
| FeatureRestriction | |
| FeatureRestrictionCollection | |
| FileGroup |
Represents a sql server database filegroup |
| FileGroupCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ForeignKey |
Instance class encapsulating : Server[@Name='']/Database/Table/ForeignKey |
| ForeignKeyCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ForeignKeyColumn |
Instance class encapsulating : Server[@Name='']/Database/Table/ForeignKey/Column |
| ForeignKeyColumnCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| FrequencyPair | |
| FullTextCatalog |
Instance class encapsulating : Server[@Name='']/Database/FullTextCatalog |
| FullTextCatalogCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| FullTextIndex |
Instance class encapsulating : Server[@Name='']/Database/Table/FullTextIndex |
| FullTextIndexColumn |
Instance class encapsulating : Server[@Name='']/Database/Table/FullTextIndex/FullTextIndexColumn |
| FullTextIndexColumnCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| FullTextService |
Instance class encapsulating : Server[@Name='']/FullTextService |
| FullTextStopList |
Instance class encapsulating : Server[@Name='']/Database/FullTextStopList |
| FullTextStopListCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| HttpProtocol |
Instance class encapsulating : Server[@Name='']/Endpoint/Http |
| Index |
Instance class encapsulating : Server[@Name='']/Database/Table/Index |
| IndexCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| IndexedColumn |
Instance class encapsulating : Server[@Name='']/Database/Table/Index/IndexedColumn |
| IndexedColumnCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| IndexedXmlPath |
Instance class encapsulating : Server[@Name='']/Database/Table/Index/IndexedXmlPath |
| IndexedXmlPathCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| IndexedXmlPathNamespace |
Instance class encapsulating : Server[@Name='']/Database/Table/Index/IndexedXmlPathNamespace |
| IndexedXmlPathNamespaceCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| IndexEvents | |
| IndexTypeConverter | |
| Information |
Instance class encapsulating : Server[@Name='']/Information |
| InternalSmoErrorException |
The exception thrown when there is an internal error with a T:Microsoft.SqlServer.Management.Smo object. |
| InvalidRestorePlanException |
Exception thrown on trying to execute or verify an invalid Restore plan. |
| InvalidScriptingOptionException |
This exception gets thrown when invalid scripting options are set |
| InvalidSmoOperationException |
The exception thrown when an operation cannot be performed in the current object state. |
| InvalidVersionSmoOperationException |
The exception thrown when an operation cannot be performed in the current version. |
| JobScheduleCollectionBase | |
| Language |
Instance class encapsulating : Server[@Name='']/Language |
| LanguageCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| LinkedServer |
Instance class encapsulating : Server[@Name='']/LinkedServer |
| LinkedServerCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| LinkedServerLogin |
Instance class encapsulating : Server[@Name='']/LinkedServer/Login |
| LinkedServerLoginCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| LogFile |
This class incapsulates a database log file |
| LogFileCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| Login |
This class represents a SqlServer login |
| LoginCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| LoginEvents | |
| MasterKey |
Instance class encapsulating : Server[@Name='']/Database/MasterKey |
| MessageCollectionBase | |
| MessageObjectBase | |
| MissingObjectException |
The exception thrown when an object is missing from a collection or when a collection does not exist under a server version. |
| NamedSmoObject | |
| NextRestoreEventArgs |
Next Restore Event arguments |
| NumaNode |
NumaNode Class |
| NumaNodeCollection |
NumaNode collection, class containg collection of all Numas |
| NumberedObjectCollectionBase |
base class for all generic collections |
| NumberedStoredProcedure |
Instance class encapsulating : Server[@Name='']/Database/StoredProcedure/Numbered |
| NumberedStoredProcedureCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| NumberedStoredProcedureParameter |
Instance class encapsulating : Server[@Name='']/Database/StoredProcedure/Numbered/Param |
| NumberedStoredProcedureParameterCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ObjectAlteredEventArgs |
argument for ObjectAlteredEventHandler |
| ObjectCreatedEventArgs |
argument for ObjectCreatedEventHandler |
| ObjectDroppedEventArgs |
argument for ObjectDroppedEventHandler |
| ObjectEvent | |
| ObjectEventSet | |
| ObjectPermission | |
| ObjectPermissionInfo | |
| ObjectPermissionSet | |
| ObjectRenamedEventArgs |
argument for ObjectRenamedEventHandler |
| OleDbProviderSettings |
Instance class encapsulating : Server[@Name='']/Setting/OleDbProviderSetting |
| OleDbProviderSettingsCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| OrderColumn |
Instance class encapsulating : Server[@Name='']/Database/UserDefinedFunction/OrderColumn |
| OrderColumnCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| PageRestorePlanner |
Page Restore Planner |
| Parameter |
Instance class encapsulating : Server[@Name='']/Database/UserDefinedFunction/Param |
| ParameterBase | |
| ParameterCollectionBase | |
| PartitionFunction |
Instance class encapsulating : Server[@Name='']/Database/PartitionFunction |
| PartitionFunctionCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| PartitionFunctionEvents | |
| PartitionFunctionParameter |
Instance class encapsulating : Server[@Name='']/Database/PartitionFunction/PartitionFunctionParameter |
| PartitionFunctionParameterCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| PartitionNumberedObjectCollectionBase | |
| PartitionScheme |
Instance class encapsulating : Server[@Name='']/Database/PartitionScheme |
| PartitionSchemeCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| PartitionSchemeEvents | |
| PartitionSchemeParameter |
Instance class encapsulating : Server[@Name='']/Database/Table/PartitionSchemeParameter |
| PartitionSchemeParameterCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| PathWrapper |
Helper class to deal with Path manipulation and handles XI paths as well. We could take ServerConnection as a parameter and get the PathSeparator from it but these might be used in offline situations too |
| Payload | |
| PercentCompleteEventArgs |
Arguments for the event handler of the percent complete |
| PerformanceCounters | |
| PermissionInfo | |
| PermissionSetBase |
Abstract class for all Permission classes. |
| PhysicalPartition |
Instance class encapsulating : Server[@Name='']/Database/PartitionFunction |
| PhysicalPartitionCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| PlanGuide |
Represents a sql server database plan |
| PlanGuideCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| PlanGuideExtender | |
| ProgressReportEventArgs | |
| Property | |
| PropertyCannotBeRetrievedException |
The exception thrown when the caller is asking for a property that returned null during enumeration. |
| PropertyCollection | |
| PropertyMissingEventArgs |
Describes the missing property which leads to either a full object initialization or to loading an expensive property separately from initialization |
| PropertyNotSetException |
The exception thrown when an action requires a property that has not been set by the user. |
| PropertyReadOnlyException |
The exception that is thrown when trying to set a readonly property. |
| PropertyTypeMismatchException |
The exception thrown if a value of the wrong type is assigned to a property. |
| PropertyWriteException |
The exception thrown when trying to set a property that has been blocked. |
| Protocol | |
| QueryStoreCaptureModeConverter |
type converter for QueryStoreCaptureMode |
| QueryStoreOperationModeConverter |
type converter for QueryStoreOperationMode |
| QueryStoreOptions |
QueryStore Options Smo Object. |
| QueryStoreSizeBasedCleanupModeConverter |
type converter for QueryStoreSizeBasedCleanupMode |
| QueryStoreWaitStatsCaptureModeConverter |
type converter for QueryStoreWaitStatsCaptureMode |
| RangeTypeConverter | |
| RelocateFile | |
| RemoteDataArchiveMigrationStatusReport |
Status report for each batch of rows migrated to Remote Data Archive |
| RemoteDatabaseMigrationStatistics |
Statistics about the Remote database created for Remote Data Archive |
| RemoteTableMigrationStatistics |
Statistics about the Remote table created for Remote Data Archive |
| ResourceGovernor |
Class that handles Altering and Scripting the current state of Resource Governor |
| ResourcePool |
Class that handles Creating, Altering, Dropping and Scripting the Resource Pool instance |
| ResourcePoolAffinityInfo |
ResourcePoolAffinityInfo |
| ResourcePoolCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| Restore | |
| RestoreOptions | |
| RestorePlan |
Database Restore Plan is a sequence of Database Restore operations which will recover a Database to a particular state in a point in time. |
| ResumableIndex |
The partial definition of the ResumableIndex class. https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-index-resumable-operations https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql https://docs.microsoft.com/en-us/sql/t-sql/statements/create-index-transact-sql |
| ResumableIndexCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ResumableOperationStateTypeConverter | |
| Rule |
Instance class encapsulating : Server[@Name='']/Database/Rule |
| RuleCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| Scheduler |
Scheduler class |
| SchedulerCollection |
Scheduler collection, a class containg collection of all schedulers in the system and their affinity to the parent resource pool. |
| Schema |
Instance class encapsulating : Server[@Name='']/Database/Schema |
| SchemaCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SchemaCollectionBase | |
| SchemaCustomResolver |
Custom resolver for Schema We need a custom resolver as not all schema based objects live under Database For example service broker objects have an intermediate object so we cannot resolve using a fixed template |
| SchemaEvents | |
| Scripter |
Instance class encapsulating Scripter object |
| ScriptingErrorEventArgs | |
| ScriptingOptions |
Instance class encapsulating SQL Server database |
| ScriptingPreferences |
Defines preferences for scripting |
| ScriptMaker |
Provides methods to get SMO objects' scripts |
| ScriptNameObjectBase | |
| ScriptOption |
A single scripting option. It represents a single value from the above enum. |
| ScriptSchemaObjectBase | |
| ScriptWriterException |
The exception thrown when script writing fails. |
| SearchProperty |
SMO class for Search Properties in a Search Property List |
| SearchPropertyCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SearchPropertyList |
SMO class for Search Property List |
| SearchPropertyListCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SearchPropertyListExtender |
Class which provides extended properties for a SearchPropertyList object |
| SecurityPolicy |
Represents a sql server Security Policy object |
| SecurityPolicyCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| SecurityPredicate |
Represents a sql server security predicate object. |
| SecurityPredicateCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SecurityPredicateCollectionBase |
SecurityPredicateCollectionBase |
| SecurityPredicateOperationConverter | |
| SecurityPredicateTypeConverter | |
| SensitivityRankConverter | |
| Sequence |
Represents a sql server Sequence object |
| SequenceCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| SequenceEvents | |
| SequenceExtender |
Represents sql server SequenceExtender object |
| Server |
Instance class encapsulating : Server[@Name=''] |
| ServerActiveDirectory | |
| ServerAdapter |
This class is exactly the ServerAdapterBase class, but it implements IDmfAdapter |
| ServerAdapterBase |
This class acts as the flattener for Server properties hidden in Server.Settings and Server.Configuration Facets will inherit from this class to add new logical properties, use this class's Alter and Refresh methods, or they override the Alter and Refresh methods. This class should not implement IDmfAdapter or any facet directly. Facets must be on leaf-level classes and this class is not intended to be a leaf-level class. |
| ServerAuditSpecification |
Instance class encapsulating : Server[@Name='']/ServerAuditSpecification |
| ServerAuditSpecificationCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ServerAuditSpecificationExtender | |
| ServerConfigurationAdapter |
The Server Configuration properties need to only Alter and Refresh the Server.Configuration properties. This class inherits from ServerAdapterBase and overrides those functions. |
| ServerDdlTrigger |
Instance class encapsulating : Server[@Name='']/DdlTrigger |
| ServerDdlTriggerCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ServerDdlTriggerEvent |
ServerDdlTriggerEvent |
| ServerDdlTriggerEventSet |
class ServerDdlTriggerEventSet |
| ServerEvent | |
| ServerEvents |
Class that encapsulates all functionality related to Server Events. |
| ServerEventSet | |
| ServerPermission | |
| ServerPermissionInfo | |
| ServerPermissionSet | |
| ServerProxyAccount |
Instance class encapsulating : Server[@Name='']/ServerProxyAccount |
| ServerRole |
Instance class encapsulating : Server[@Name='']/Role |
| ServerRoleCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| ServerRoleEvents | |
| ServerRoleExtender | |
| ServerSecurityAdapter |
Relational Engine Security. This facet has some logical properties and it needs its own Refresh and Alter. It inherits from the ServerAdapterBase. |
| ServerSelectionAdapter |
Server Selection. This facet has logical properties enabling users to chose properties to select server. It inherits from the ServerAdapterBase. |
| ServerSetupAdapter |
Adapter for AS SAC facet |
| ServerSurfaceAreaAdapter |
This facet is entirely a subset of configuration options, so it is just an interface on the ServerConfigurationAdapter |
| ServerTraceEvent | |
| ServerTraceEventSet | |
| ServiceBrokerPayload |
Instance class encapsulating : Server[@Name='']/Endpoint/ServiceBroker |
| ServiceMasterKey |
Instance class encapsulating : Server[@Name='']/MasterKey |
| ServiceQueueEvent | |
| ServiceQueueEventSet | |
| ServiceRequestException |
This exception incapsulates a service provider error. |
| Settings |
Instance class encapsulating : Server[@Name='']/Setting |
| SfcDependencyException |
This exception gets thrown when a dependency operation failed TODO: this will move to SFC once we have generalized the dependency classes (see SfcDependencyDiscovery.cs). |
| SimpleObjectCollectionBase |
base class for all generic collections |
| SmartAdmin |
Class that handles Altering and Scripting the current state of smart admin |
| SmartAdminState |
This is an adapter class that implements the ISmartAdminState logical facet for an Availability Group. |
| SmoApplication | |
| SmoCollectionBase | |
| SmoDependencyDiscoverer |
Class to which finds referenced,refrencing objects and children |
| SmoDmfAdapter | |
| SmoEventArgs |
Base argument class for Smo native events |
| SmoException |
The base class for all SMO exception classes. |
| SmoObjectBase | |
| SmoObjectExtender<T> |
Extender class for Smo Objects |
| SmoUtility |
Utility and helper methods for SMO |
| SoapMethodCollectionBase | |
| SoapMethodObject | |
| SoapPayload |
Instance class encapsulating : Server[@Name='']/Endpoint/Soap |
| SoapPayloadMethod |
Instance class encapsulating : Server[@Name='']/Endpoint/Soap/Method |
| SoapPayloadMethodCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SortedListCollectionBase | |
| SqlAssembly |
Instance class encapsulating : Server[@Name='']/Database/SqlAssembly |
| SqlAssemblyCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SqlAssemblyEvent | |
| SqlAssemblyEvents | |
| SqlAssemblyEventSet | |
| SqlAssemblyFile |
Instance class encapsulating : Server[@Name='']/Database/SqlAssembly/SqlAssemblyFile |
| SqlAssemblyFileCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SqlPropertyCollection | |
| SqlPropertyInfo |
Class encapsulating metadata and version info about a sql property. |
| SqlSmoObject |
Contains common functionality for all the instance classes |
| SqlSupport |
Contains assorted helper functions |
| SqlVariantSerializationAdapter |
Serializes objects that represent sql_variant instances to SFC XML |
| Statistic |
Instance class encapsulating : Server[@Name='']/Database/Table/Statistic |
| StatisticCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| StatisticColumn |
Instance class encapsulating : Server[@Name='']/Database/Table/Statistic/Column |
| StatisticColumnCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| StatisticEvents | |
| StoredProcedure |
Instance class encapsulating : Server[@Name='']/Database/StoredProcedure |
| StoredProcedureCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| StoredProcedureEvent | |
| StoredProcedureEvents | |
| StoredProcedureEventSet | |
| StoredProcedureParameter |
Instance class encapsulating : Server[@Name='']/Database/StoredProcedure/Param |
| StoredProcedureParameterCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SuspectPage |
Database page used for Page Restore. |
| SymmetricKey |
Instance class encapsulating : Server[@Name='']/Database/SymmetricKey |
| SymmetricKeyCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SymmetricKeyEncryption |
This object is used to specify an encryption type. |
| Synonym |
Instance class encapsulating : Server[@Name='']/Database/Synonym |
| SynonymCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| SynonymEvents | |
| SystemDataType |
Instance class encapsulating : Server[@Name='']/SystemDataType |
| SystemDataTypeCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| SystemMessage |
Instance class encapsulating : Server[@Name='']/SystemMessage |
| SystemMessageCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| Table |
Instance class encapsulating : Server[@Name='']/Database/Table |
| TableCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| TableEvent | |
| TableEvents | |
| TableEventSet | |
| TableViewBase | |
| TableViewTableTypeBase | |
| TcpProtocol |
Instance class encapsulating : Server[@Name='']/Endpoint/Tcp |
| TemporalHistoryRetentionPeriodUnitTypeConverter | |
| Transfer |
Instance class encapsulating Transfer object |
| TransferBase |
Base class for transfer |
| Trigger |
Instance class encapsulating : Server[@Name='']/Database/Table/Trigger |
| TriggerCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| TriggerEvents | |
| TypeConverters | |
| UnknownPropertyException |
The exception thrown when trying to access a property that does not exist for a server version. |
| UnsupportedCompatLevelException |
The exception gets thrown when an operation is executed with an unsupported compatability level for that operation specified. |
| UnsupportedEngineEditionException |
This exception gets thrown when an unsupported engine edition is detected. |
| UnsupportedEngineTypeException |
This exception gets thrown when an operation has failed |
| UnsupportedFeatureException |
The exception thrown when an object is not supported by Sql Express |
| UnsupportedObjectNameException |
The exception thrown when the user is trying to create an object with a name that cannot be supported, such as a null string. |
| UnsupportedVersionException |
The exception gets thrown when an operation has failed. |
| UrnCollection |
ArrayList of Urn objects |
| User |
Instance class encapsulating : Server[@Name='']/Database/User |
| UserCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| UserDefinedAggregate |
Instance class encapsulating : Server[@Name='']/Database/UserDefinedAggregate |
| UserDefinedAggregateCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| UserDefinedAggregateParameter |
Instance class encapsulating : Server[@Name='']/Database/UserDefinedAggregate/Param |
| UserDefinedAggregateParameterCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| UserDefinedDataType |
Instance class encapsulating : Server[@Name='']/Database/UserDefinedDataType |
| UserDefinedDataTypeCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| UserDefinedDataTypeResolver |
Custom resolver for DataType::UserDefinedDataType TODO: implement resolvers for other types (note that the URN resolver can be generic for all data types) |
| UserDefinedFunction |
Instance class encapsulating : Server[@Name='']/Database/UserDefinedFunction |
| UserDefinedFunctionCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| UserDefinedFunctionEvent | |
| UserDefinedFunctionEvents | |
| UserDefinedFunctionEventSet | |
| UserDefinedFunctionParameter |
Instance class encapsulating : Server[@Name='']/Database/UserDefinedFunction/Param |
| UserDefinedFunctionParameterCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| UserDefinedMessage |
Instance class encapsulating : Server[@Name='']/UserDefinedMessage |
| UserDefinedMessageCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| UserDefinedTableType |
Instance class encapsulating : Server[@Name='']/Database/UserDefinedTableType |
| UserDefinedTableTypeCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| UserDefinedTableTypeResolver |
Custom resolver for DataType::UserDefinedTableType |
| UserDefinedType |
Instance class encapsulating : Server[@Name='']/Database/UserDefinedType |
| UserDefinedTypeCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| UserDefinedTypeEvents | |
| UserDefinedTypeResolver |
Custom resolver for DataType::UserDefinedType |
| UserEvents | |
| UserOptions |
Instance class encapsulating : Server[@Name='']/UserOption |
| VerifyCompleteEventArgs |
Event argument class for VerifyCompleteEventHandler |
| VersionSerializationAdapter |
Serializes instances of System.Version to Sfc XML |
| VersionUtils |
Helper class to handle various version-related checks |
| View |
Instance class encapsulating : Server[@Name='']/Database/View |
| ViewCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
| ViewEvent | |
| ViewEvents | |
| ViewEventSet | |
| WorkloadGroup |
Class that handles Creating, Altering, Dropping and Scripting the Workload group instance |
| WorkloadGroupCollection |
Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class |
| WrongPropertyValueException |
The exception thrown during a scripting action when a property has an unusable value or there is a conflict between two or more properties. |
| XmlSchemaCollection |
Instance class encapsulating : Server[@Name='']/Database/XmlSchemaCollection |
| XmlSchemaCollectionCollection |
Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties |
Structs
| AuditSpecificationDetail | |
| DdlTextParserHeaderInfo |
Interfaces
| IAvailabilityGroupState |
This facet aggregates various availability group state information. It is used to support SQL Server manageability tools. |
| IColumnPermission |
Interface for column-level object permissions. |
| IDatabaseMaintenanceFacet | |
| IDatabaseOptions | |
| IDatabasePerformanceFacet | |
| IDatabaseSecurityFacet | |
| IExtendedProperties | |
| ILoginOptions | |
| IMultipartNameFacet |
Identity Facet |
| INameFacet |
Name Facet |
| IObjectPermission |
Methods for enumerating, granting, and denying permissions on an object. |
| IScriptable | |
| IServerAuditFacet | |
| IServerConfigurationFacet | |
| IServerInformation | |
| IServerPerformanceFacet | |
| IServerSecurityFacet | |
| IServerSelectionFacet | |
| IServerSettings | |
| IServerSetupFacet |
Server installation facet |
| ISmartAdminState |
This facet aggregates smartadmin state information. It is used to support SQL Server manageability tools. |
| ISmoApplicationEvents |
Defines an object that exposes application-wide SMO events |
| ISmoDependencyDiscoverer |
Defines an interface for discovering URNs of dependent objects |
| ISurfaceAreaFacet | |
| ITableOptions | |
| ITextObject |
Interface implemented by all instance classes that have all or a part of their definition as text |
| IUserOptions | |
| IViewOptions | |
Enums
| AbortAfterWait |
Specifies the ABORT_AFTER_WAIT option of a DDL operation. |
| ActivationExecutionContext |
Specifies the user context for objects activation. |
| AffinityType |
Affinity type of Cpu Auto or Manual |
| AssemblyAlterOptions | |
| AssemblySecurityLevel |
Specifies the access rights for an Assembly. |
| AsymmetricKeyEncryptionAlgorithm |
Specifies the algorithm used to encrypt a (asymmetric) key. |
| AsymmetricKeySourceType |
Specifies the source of the certificate, when loading. |
| AttachOptions |
List of options that may be passed to Server.AttachDatabase |
| AuditActionType |
Specifies the type of action for sql server audit events |
| AuditDestinationType |
Specifies the destination type of an Audit |
| AuditFileSizeUnit |
Specifies the unit of file size |
| AuditLevel | |
| AuditStatusType |
Specifies the state of the Audit |
| AuthenticationType |
Specifies the authentication type of the database principals |
| AvailabilityDatabaseSynchronizationState |
The different synchronization states a database participating in an HADR Availability Group can be in. |
| AvailabilityGroupAutomatedBackupPreference |
This enumeration specifies how replicas in the primary role are treated in the evaluation to pick the desired replica to perform a backup. |
| AvailabilityGroupClusterType |
Cluster type of the Availability Group |
| AvailabilityGroupFailureConditionLevel |
The different conditions that can trigger an automatic failover in an Availability Group. These setting are cumulative, meaning that as the setting increases in value it encompases all the previous conditions and adds extra ones. |
| AvailabilityGroupListenerIPState |
State of the Availability Group Listener IP Address |
| AvailabilityGroupRollupSynchronizationState |
A rollup of the synchronization states of the availability replicas in the availability group. |
| AvailabilityReplicaAvailabilityMode |
Availability modes of Availability Replica The int value has to match the values defined by the engine, can be found here: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-availability-replicas-transact-sql |
| AvailabilityReplicaConnectionModeInPrimaryRole |
Connection intent modes of an Availability Replica in primary role |
| AvailabilityReplicaConnectionModeInSecondaryRole |
Connection intent modes of an Availability Replica in secondary role |
| AvailabilityReplicaConnectionState |
The current connection state of an availability replica. |
| AvailabilityReplicaFailoverMode |
Failover modes of Availability Replica |
| AvailabilityReplicaJoinState |
The join state of an Availability Replica |
| AvailabilityReplicaOperationalState |
The state of the replica's readiness to process client requests for all databases replicas in the availability group residing on it. |
| AvailabilityReplicaRole |
The current role a replica is playing in an availability group. |
| AvailabilityReplicaRollupRecoveryState |
Represents a rollup of the recovery state of all database replicas in the availability group that reside on this availability replica. |
| AvailabilityReplicaRollupSynchronizationState |
The current synchronization state of the availability replica. This is based on the synchronization states of database replicas in the availaiblity group residing on the instance. |
| AvailabilityReplicaSeedingMode |
Seeding mode of Availability Replica |
| BackupActionType | |
| BackupCompressionOptions |
The BackupCompressionOptions enumeration contains values that are used to specify a backup compression option |
| BackupDeviceType | |
| BackupEncryptionAlgorithm |
Specifies the algorithm type used for backup encryption. |
| BackupEncryptorType |
Specifies the encryptor type used to encrypt an encryption key. |
| BackupRestoreBase.AsyncOperation | |
| BackupSetFlag | |
| BackupSetType |
Backupset type : Full Database, Differential, Log, File or Filegroup |
| BackupTruncateLogType | |
| CatalogCollationType |
Catalog Collation Type values. |
| CatalogPopulationAction |
Specifies catalog population action. |
| CatalogPopulationStatus |
Specifies the population state of a Microsoft Search fulltext catalog. |
| CertificateSourceType | |
| ChangeTracking | |
| ClusterMemberState |
The state of a member in a Windows Cluster. |
| ClusterMemberType |
The type of node in the windows cluster |
| ClusterQuorumState |
The current stat of the cluster quorum |
| ClusterQuorumType |
The different types of ways a cluster can decide on a quorum |
| CollationVersion |
Specifies the Collation Version |
| ColumnEncryptionType |
EncryptionType for a column encrypted with TCE |
| CompatibilityLevel | |
| ContainmentType |
Enumerates the containment types of a database. |
| CreateDispositionType |
Contains the values of CREATION_DISPOSITION option |
| DatabaseDdlTriggerExecutionContext |
Specifies the user context in which assembly code will run. |
| DatabaseEncryptionAlgorithm |
Specifies the algorithm used to encrypt the database encryption key |
| DatabaseEncryptionState |
Specifies the current encryption transition state of the database |
| DatabaseEncryptionType |
Specifies the encryption type used to encrypt the database encryption key |
| DatabaseEventType | |
| DatabaseObjectTypes | |
| DatabasePermissionSetValue |
Enum containing all possible DatabasePermissions use sys.fn_builtin_permissions to see the latest values on new versions of SQL |
| DatabaseRecoveryState |
Database recovery state. |
| DatabaseReplicaSuspendReason |
The different reasons for a database replica to be in suspended state. |
| DatabaseScopedConfigurationOnOff |
Database Scoped Configuration on and off states. |
| DatabaseStatus | |
| DatabaseUserAccess |
enum values are aranget to mach sys.databases.user_access |
| DataCompressionType |
DataCompressionType describe about the compression status of a table/index partition. None means no compression, Row means compression row wise,Page means compression applied page wise and ColumnStore is compression columnstore wise |
| DelayedDurability |
Specifies the delayed durability option of the database. |
| DependencyType | |
| DeviceType |
Backup Media Device Type |
| DurabilityType |
The enumeration specifies the durability type of hekaton tables |
| DwTableDistributionType |
The enumeration specifies the SQL DW distributed table distribution types. |
| DwViewDistributionType |
The enumeration specifies the SQL DW materialized view distribution types. |
| EdgeConstraintDeleteAction |
Enumerates possible referential actions when an EdgeConstraint object is modified. see ec syntax: | [ EdgeConstraint ] CONNECTION ([ schema_name . ] referenced_table_from_name TO [ schema_name . ] referenced_table_to_name] [ ON DELETE { NO ACTION | CASCADE } ] |
| Edition |
the possible values returned by SERVERPROPERTY['EngineEdition'] |
| EndpointAuthenticationOrder |
The type of connection authentication required for connections to this endpoint. |
| EndpointEncryption |
EndpointEncryption |
| EndpointEncryptionAlgorithm |
EndpointEncryptionAlgorithm |
| EndpointState | |
| EndpointType | |
| EventType | |
| ExecutionContext |
Specifies the user context in which assembly code will run. |
| ExecutionStatus |
An enum describing a state of asynchronous query |
| ExternalDataSourcePushdownOption |
Enumerates possible Pushdown options on External Datasource |
| ExternalDataSourceType |
The enumeration specifies the external data source type for external tables |
| ExternalFileFormatType |
The enumeration specifies the external file format types |
| ExternalLibraryContentType |
Specifies the content type for an external library installation or alteration. |
| ExternalTableDistributionType |
The enumeration specifies the external table distribution. Valid for tables with ShardMapManager external data sources. |
| ExternalTableRejectType |
The enumeration specifies the external table reject types |
| FeatureRestriction.PrincipalClass | |
| FileGroupType |
Type of a filegroup file |
| FileGrowthType | |
| FilestreamAccessLevelType |
List of SQL Server filestream access level types |
| FileStreamEffectiveLevel |
The effective level for the FILESTREAM feature |
| FileStreamLevel |
Filestream level options |
| FilestreamNonTransactedAccessType |
Filestream non-transacted access type |
| ForeignKeyAction |
see fk syntax: | [ FOREIGN KEY ] REFERENCES [ schema_name . ] referenced_table_name [ ( ref_column ) ] [ ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] |
| FragmentationOption |
specifies how index fragmentation will be retrieved |
| FullTextCatalogUpgradeOption |
Specifies the Full Text Catalog Upgrade options |
| GeneratedAlwaysType |
Types of temporal auto-generated columns |
| GraphType | |
| HadrManagerStatus |
The status of the HADR Manager Service |
| HttpAuthenticationModes | |
| HttpPortTypes | |
| ImplementationType |
Specifies the implementation type of a StoredProcedure, UserDefinedFunction,, and other objects. |
| IndexedXmlPathType |
represents the type of indexed path in Selective Xml Index |
| IndexEnableAction |
specifies how an index should be re-enabled |
| IndexKeyType |
The enumeration specifies the attributes of the Index object |
| IndexOperation |
specifies what operation to perform on an index alter |
| IndexPopulationAction |
Specifies index population action. |
| IndexPopulationStatus |
Specifies the population state of a full-text table index. |
| IndexType |
The enumeration specifies the type of the Index. |
| InDoubtTransactionResolutionType |
List of SQL Server repair types |
| InstanceState |
InstanceState values |
| KeyEncryptionType |
Specifies the type of encryption of a key. |
| LinkedTableType |
Types of tables that can be enumerated on the linked server |
| LinkFieldType |
type of the field in link |
| LockEscalationType |
The enumeration specifies the lock escalation granularity |
| LockRequestStatus | |
| LoginCreateOptions |
Specifies options that can be specified when creating a login |
| LoginType | |
| LogReuseWaitStatus |
Reuse of transaction log space is currently waiting on. |
| MappedClassType |
Specifies the class to which a Credential is mapped |
| MediaTypes | |
| MethodLoginType |
LoginType of SoapPayloadMethod |
| MethodXsdSchemaOption | |
| MirroringOption |
The MirroringOption enum is used to change the state or a Database mirror. |
| MirroringRole |
Role the database plays in mirroring, one of: |
| MirroringSafetyLevel |
Safety guarantee of updates on the backup, one of: |
| MirroringStatus |
Role the database plays in mirroring, one of: |
| MirroringWitnessStatus | |
| Month | |
| NSActivationState |
This enum describes the state of a Notification Service application component. |
| NumaNodeAffinity |
Defines Affinity Type of NumaNode |
| ObjectClass |
see engine spec: CatalogViewsRef: Appendix Universal Entity Classes The following table represents the domain of entity classes in the system, defined in the header file cmedscan.h. Entity class usages include: sys.database_permissions sys.server_permissions sys.extended_properties included here are only securable objects |
| ObjectPermissionSetValue |
enum containing all possible ObjectPermissions |
| OnFailureAction |
Specifies the action that needs to be taken when the audit sink cannot perform the write |
| PageVerify |
The PageVerify enum specifies the type of integrity check performed on page reads. |
| PartitioningScheme |
Enumerates whether Partition Scheme is scripted for None,Table,Index or All |
| PasswordHashAlgorithm |
Enumerates the hash algorithms that are used to authenticate SQL Login passwords. |
| PathType |
Denotes the type of file path for PathWrapper methods |
| PerfMonMode |
Specifies the mode in which PerfMon works |
| PermissionState | |
| PlanGuideType |
Type of plan guide |
| PrincipalType |
Specifies the type of the server or database principal |
| PrivateKeyEncryptionType |
Specifies the type of encryption of a key |
| PrivilegeTypes |
List of object and database privileges |
| ProtocolType | |
| ProviderAuthenticationType |
Specifies the type of Authentication supported by Cryptographic Provider |
| QueryStoreCaptureMode |
Capture Mode values for Query Store |
| QueryStoreOperationMode |
Operation Mode values for Query Store |
| QueryStoreSizeBasedCleanupMode |
Size Based Cleanup Mode values for Query Store |
| QueryStoreWaitStatsCaptureMode |
Wait Statistics Capture Mode values for Query Store |
| RangeType |
The RangeType enum specifies whether the boundary values specified with RangeValues are placed in the LEFT or RIGHT side of the interval. None corresponds to no boundary condition. Table with no partition is suitable example. |
| RecoveryModel |
enum values are aranget to mach sys.databases.recovery_option |
| RemoteDataArchiveMigrationState |
Current data migration state of a stretched table Refer remote_data_archive_migration_state in https://msdn.microsoft.com/en-us/library/ms187406.aspx |
| RepairOptions |
Specifies the repair options |
| RepairStructure |
Specifies the kind of repair structure |
| RepairType |
List of SQL Server repair types |
| ReplicationOptions |
The ReplicationOptions enum specifies the active replication settings for a database, |
| ResourceUsage |
Specifies the available system resources for the MSSearch Service. |
| RestoreActionType | |
| RestoreType | |
| ResultFormat | |
| ResumableOperationStateType |
Resumable Operation State: Running, Paused, None. |
| RetentionPeriodUnits |
Change Tracking Retention Period Units |
| RoleTypes | |
| ScriptBehavior |
Enumerates ScriptBehavior as Drop,Create,CreateOrAlter or Drop and Create |
| ScriptNameObjectBase.ScriptHeaderType | |
| SecondaryXmlIndexType |
represents the type of the secondary xml index |
| SecurityPredicateOperation |
Security predicate operation types |
| SecurityPredicateType |
Security predicate type |
| SensitivityRank |
Specifies the sensitivity rank of a column |
| SequenceCacheType |
Specifies the cache type of a Sequence object. |
| ServerDdlTriggerExecutionContext |
Specifies the user context in which assembly code will run. |
| ServerLoginMode | |
| ServerMirroringRole | |
| ServerPermissionSetValue |
enum containing all possible ServerPermissions |
| ServerStatus |
the possible values of server status |
| ServiceStartMode |
The start mode for a service |
| ShrinkMethod | |
| SmoExceptionType |
Enumeration of exception types defined by T:Microsoft.SqlServer.Management.Smo.SmoExceptionType. |
| SnapshotIsolationState | |
| SortOrder | |
| SpatialGeoLevelSize |
The Spatial Geo Level Sizes |
| SpatialIndexType |
The Spatial Index type for the Spatial Indices |
| SqlDataType |
The SqlDataType specifies the type of the DataType object. |
| SqlServerVersion |
Enumerates versions of SqlServer supported by SMO. |
| SqlServerVersions | |
| SqlSmoState | |
| SqlVerifyAction |
Specifies what needs to be verified |
| StatisticsScanType | |
| StatisticsTarget | |
| StopListOption |
Specifies the Stoplist options associated with a FullText Index. |
| SymmetricKeyEncryptionAlgorithm |
Specifies the algorithm used to encrypt a (symmetric) key |
| SymmetricKeyEncryptionType |
Specifies the type of encryption of a key. |
| SynonymBaseType |
Specifies the type of base object of a synonym. |
| TableTemporalType |
Types of Temporal tables |
| TemporalHistoryRetentionPeriodUnit |
Temporal retention period unit description |
| TerminationClause | |
| TransactionTypes |
Specifies the types of transactions that may be active in a database |
| UrnIdOption | |
| UserDefinedFunctionType | |
| UserDefinedTypeFormat |
Specifies how a UDT is stored. |
| UserType |
Specifies the type of user in a database. |
| WindowsLoginAccessType | |
| WorkloadGroupImportance |
Specifies the Importance Type for Resource Governor Workload group |
| WsdlGeneratorOption | |
| XmlDocumentConstraint |
Specifies types of XML document constraints |
| XmlFormatOption | |
| XmlTypeDerivation |
Specifies the xml type derivation |
| XmlTypeKind |
Specifies the kind of xml component |
| XsdSchemaOption |
Specifies if an XSD schema will be returned for a SOAP method. |
Delegates
| DatabaseRestorePlanner.CreateRestorePlanEventHandler |
Create restore plan status update delegate |
| NextRestoreEventHandler |
the prototype of the callback method for next restore |
| PercentCompleteEventHandler |
the prototype of the callback method for percent complete |
| ProgressReportEventHandler | |
| ScriptingErrorEventHandler | |
| ScriptingFilter | |
| ServerEventHandler |
Handler prototype for all server events. |
| SmoApplication.AnyObjectEventHandler |
called for any of the above events. This allows handling all event types using one handler |
| SmoApplication.DatabaseEventHandler |
called for database events |
| SmoApplication.ObjectAlteredEventHandler |
called when an object is successfully altered |
| SmoApplication.ObjectCreatedEventHandler |
Called when an object is successfully created |
| SmoApplication.ObjectDroppedEventHandler |
called when an object is successfully dropped |
| SmoApplication.ObjectRenamedEventHandler |
called when an object is successfully renamed |
| VerifyCompleteEventHandler |
Event signature for VerifyComplete event |