Database Database Database Class

Definition

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

[Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcElement(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcElementFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcElementFlags.SqlAzureDatabase)]
[Microsoft.SqlServer.Management.Sdk.Sfc.PhysicalFacet]
public sealed class Database : Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase, Microsoft.SqlServer.Management.Common.IAlterable, Microsoft.SqlServer.Management.Common.ICreatable, Microsoft.SqlServer.Management.Common.IDropIfExists, Microsoft.SqlServer.Management.Common.IDroppable, Microsoft.SqlServer.Management.Common.ISafeRenamable, Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet, Microsoft.SqlServer.Management.Sdk.Sfc.ISfcSupportsDesignMode, Microsoft.SqlServer.Management.Smo.IDatabaseOptions, Microsoft.SqlServer.Management.Smo.IExtendedProperties, Microsoft.SqlServer.Management.Smo.IScriptable
type Database = class
    inherit ScriptNameObjectBase
    interface ISfcSupportsDesignMode
    interface ICreatable
    interface IAlterable
    interface IDroppable
    interface IDropIfExists
    interface ISafeRenamable
    interface IRenamable
    interface IExtendedProperties
    interface IScriptable
    interface IDatabaseOptions
    interface IDmfFacet
Public NotInheritable Class Database
Inherits ScriptNameObjectBase
Implements IAlterable, ICreatable, IDatabaseOptions, IDmfFacet, IDropIfExists, IDroppable, IExtendedProperties, ISafeRenamable, IScriptable, ISfcSupportsDesignMode
Inheritance
Attributes
EvaluationModeAttribute Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcElementAttribute PhysicalFacetAttribute
Implements

Constructors

Database() Database() Database()
Database(Server, String) Database(Server, String) Database(Server, String)
Database(Server, String, DatabaseEngineEdition) Database(Server, String, DatabaseEngineEdition) Database(Server, String, DatabaseEngineEdition)

Constructs a new Database object to be created with the given edition

Properties

ActiveConnections ActiveConnections ActiveConnections
ActiveDirectory ActiveDirectory ActiveDirectory
AnsiNullDefault AnsiNullDefault AnsiNullDefault
AnsiNullsEnabled AnsiNullsEnabled AnsiNullsEnabled
AnsiPaddingEnabled AnsiPaddingEnabled AnsiPaddingEnabled
AnsiWarningsEnabled AnsiWarningsEnabled AnsiWarningsEnabled
ApplicationRoles ApplicationRoles ApplicationRoles
ArithmeticAbortEnabled ArithmeticAbortEnabled ArithmeticAbortEnabled
Assemblies Assemblies Assemblies
AsymmetricKeys AsymmetricKeys AsymmetricKeys
AutoClose AutoClose AutoClose
AutoCreateIncrementalStatisticsEnabled AutoCreateIncrementalStatisticsEnabled AutoCreateIncrementalStatisticsEnabled
AutoCreateStatisticsEnabled AutoCreateStatisticsEnabled AutoCreateStatisticsEnabled
AutoShrink AutoShrink AutoShrink
AutoUpdateStatisticsAsync AutoUpdateStatisticsAsync AutoUpdateStatisticsAsync
AutoUpdateStatisticsEnabled AutoUpdateStatisticsEnabled AutoUpdateStatisticsEnabled
AvailabilityDatabaseSynchronizationState AvailabilityDatabaseSynchronizationState AvailabilityDatabaseSynchronizationState
AvailabilityGroupName AvailabilityGroupName AvailabilityGroupName
AzureEdition AzureEdition AzureEdition
AzureServiceObjective AzureServiceObjective AzureServiceObjective
BrokerEnabled BrokerEnabled BrokerEnabled
CaseSensitive CaseSensitive CaseSensitive
CatalogCollation CatalogCollation CatalogCollation

Gets or sets the MD Catalog Collation type. Only valid during creation, and we cannot specify ContainedDatabaseCollation explicitly

Certificates Certificates Certificates
ChangeTrackingAutoCleanUp ChangeTrackingAutoCleanUp ChangeTrackingAutoCleanUp
ChangeTrackingEnabled ChangeTrackingEnabled ChangeTrackingEnabled
ChangeTrackingRetentionPeriod ChangeTrackingRetentionPeriod ChangeTrackingRetentionPeriod
ChangeTrackingRetentionPeriodUnits ChangeTrackingRetentionPeriodUnits ChangeTrackingRetentionPeriodUnits
CloseCursorsOnCommitEnabled CloseCursorsOnCommitEnabled CloseCursorsOnCommitEnabled
Collation Collation Collation
ColumnEncryptionKeys ColumnEncryptionKeys ColumnEncryptionKeys
ColumnMasterKeys ColumnMasterKeys ColumnMasterKeys
CompatibilityLevel CompatibilityLevel CompatibilityLevel
ConcatenateNullYieldsNull ConcatenateNullYieldsNull ConcatenateNullYieldsNull
ContainmentType ContainmentType ContainmentType
CreateDate CreateDate CreateDate
DatabaseAuditSpecifications DatabaseAuditSpecifications DatabaseAuditSpecifications

DatabaseAuditSpecification Collection

DatabaseEncryptionKey DatabaseEncryptionKey DatabaseEncryptionKey
DatabaseEngineEdition DatabaseEngineEdition DatabaseEngineEdition
DatabaseEngineType DatabaseEngineType DatabaseEngineType
DatabaseGuid DatabaseGuid DatabaseGuid
DatabaseOptions DatabaseOptions DatabaseOptions
DatabaseOwnershipChaining DatabaseOwnershipChaining DatabaseOwnershipChaining
DatabaseScopedConfigurations DatabaseScopedConfigurations DatabaseScopedConfigurations
DatabaseScopedCredentials DatabaseScopedCredentials DatabaseScopedCredentials
DatabaseSnapshotBaseName DatabaseSnapshotBaseName DatabaseSnapshotBaseName
DataSpaceUsage DataSpaceUsage DataSpaceUsage
DateCorrelationOptimization DateCorrelationOptimization DateCorrelationOptimization
DboLogin DboLogin DboLogin
DefaultFileGroup DefaultFileGroup DefaultFileGroup
DefaultFileStreamFileGroup DefaultFileStreamFileGroup DefaultFileStreamFileGroup
DefaultFullTextCatalog DefaultFullTextCatalog DefaultFullTextCatalog
DefaultFullTextLanguage DefaultFullTextLanguage DefaultFullTextLanguage

Gets or sets the default fulltext language of this database.

DefaultLanguage DefaultLanguage DefaultLanguage

Gets or sets the default language for the users of this database.

Defaults Defaults Defaults
DefaultSchema DefaultSchema DefaultSchema
DelayedDurability DelayedDurability DelayedDurability
EncryptionEnabled EncryptionEnabled EncryptionEnabled
Events Events Events
ExecuteForScalar ExecuteForScalar ExecuteForScalar Inherited from SqlSmoObject
ExecutionManager ExecutionManager ExecutionManager
ExtendedProperties ExtendedProperties ExtendedProperties
ExtendedStoredProcedures ExtendedStoredProcedures ExtendedStoredProcedures
ExternalDataSources ExternalDataSources ExternalDataSources
ExternalFileFormats ExternalFileFormats ExternalFileFormats
ExternalLibraries ExternalLibraries ExternalLibraries
FileGroups FileGroups FileGroups
FilestreamDirectoryName FilestreamDirectoryName FilestreamDirectoryName
FilestreamNonTransactedAccess FilestreamNonTransactedAccess FilestreamNonTransactedAccess
FullTextCatalogs FullTextCatalogs FullTextCatalogs
FullTextStopLists FullTextStopLists FullTextStopLists
HasFileInCloud HasFileInCloud HasFileInCloud
HasMemoryOptimizedObjects HasMemoryOptimizedObjects HasMemoryOptimizedObjects
HonorBrokerPriority HonorBrokerPriority HonorBrokerPriority
ID ID ID
IndexSpaceUsage IndexSpaceUsage IndexSpaceUsage
IsAccessible IsAccessible IsAccessible
IsDatabaseSnapshot IsDatabaseSnapshot IsDatabaseSnapshot
IsDatabaseSnapshotBase IsDatabaseSnapshotBase IsDatabaseSnapshotBase
IsDbAccessAdmin IsDbAccessAdmin IsDbAccessAdmin
IsDbBackupOperator IsDbBackupOperator IsDbBackupOperator
IsDbDatareader IsDbDatareader IsDbDatareader
IsDbDatawriter IsDbDatawriter IsDbDatawriter
IsDbDdlAdmin IsDbDdlAdmin IsDbDdlAdmin
IsDbDenyDatareader IsDbDenyDatareader IsDbDenyDatareader
IsDbDenyDatawriter IsDbDenyDatawriter IsDbDenyDatawriter
IsDbManager IsDbManager IsDbManager
IsDbOwner IsDbOwner IsDbOwner
IsDbSecurityAdmin IsDbSecurityAdmin IsDbSecurityAdmin
IsFullTextEnabled IsFullTextEnabled IsFullTextEnabled
IsLoginManager IsLoginManager IsLoginManager
IsMailHost IsMailHost IsMailHost
IsManagementDataWarehouse IsManagementDataWarehouse IsManagementDataWarehouse
IsMirroringEnabled IsMirroringEnabled IsMirroringEnabled
IsParameterizationForced IsParameterizationForced IsParameterizationForced
IsReadCommittedSnapshotOn IsReadCommittedSnapshotOn IsReadCommittedSnapshotOn
IsSqlDw IsSqlDw IsSqlDw
IsSqlDwEdition IsSqlDwEdition IsSqlDwEdition
IsSystemObject IsSystemObject IsSystemObject
IsTouched IsTouched IsTouched

Whether the object has been touched for unconditional scripting of Alter

(Inherited from SqlSmoObject)
IsUpdateable IsUpdateable IsUpdateable
IsVarDecimalStorageFormatEnabled IsVarDecimalStorageFormatEnabled IsVarDecimalStorageFormatEnabled

Whether vardecimal compression is enabled

LastBackupDate LastBackupDate LastBackupDate
LastDifferentialBackupDate LastDifferentialBackupDate LastDifferentialBackupDate
LastLogBackupDate LastLogBackupDate LastLogBackupDate
LegacyCardinalityEstimation LegacyCardinalityEstimation LegacyCardinalityEstimation

Get or set the Legacy_Cardinality_Estimation of the database scoped configuration.

LegacyCardinalityEstimationForSecondary LegacyCardinalityEstimationForSecondary LegacyCardinalityEstimationForSecondary

Get or set the Legacy_Cardinality_Estimation for secondary of the database scoped configuration.

LocalCursorsDefault LocalCursorsDefault LocalCursorsDefault
LogFiles LogFiles LogFiles
LogReuseWaitStatus LogReuseWaitStatus LogReuseWaitStatus
MasterKey MasterKey MasterKey
MaxDop MaxDop MaxDop

Gets or sets the MaxDop of the database scoped configuration.

MaxDopForSecondary MaxDopForSecondary MaxDopForSecondary

Get or set the MaxDop for secondary of the database scoped configuration special accounting for nulls.

MaxSizeInBytes MaxSizeInBytes MaxSizeInBytes
MemoryAllocatedToMemoryOptimizedObjectsInKB MemoryAllocatedToMemoryOptimizedObjectsInKB MemoryAllocatedToMemoryOptimizedObjectsInKB
MemoryUsedByMemoryOptimizedObjectsInKB MemoryUsedByMemoryOptimizedObjectsInKB MemoryUsedByMemoryOptimizedObjectsInKB
MirroringFailoverLogSequenceNumber MirroringFailoverLogSequenceNumber MirroringFailoverLogSequenceNumber
MirroringID MirroringID MirroringID
MirroringPartner MirroringPartner MirroringPartner
MirroringPartnerInstance MirroringPartnerInstance MirroringPartnerInstance
MirroringRedoQueueMaxSize MirroringRedoQueueMaxSize MirroringRedoQueueMaxSize
MirroringRoleSequence MirroringRoleSequence MirroringRoleSequence
MirroringSafetyLevel MirroringSafetyLevel MirroringSafetyLevel
MirroringSafetySequence MirroringSafetySequence MirroringSafetySequence
MirroringStatus MirroringStatus MirroringStatus
MirroringTimeout MirroringTimeout MirroringTimeout
MirroringWitness MirroringWitness MirroringWitness
MirroringWitnessStatus MirroringWitnessStatus MirroringWitnessStatus
Name Name Name
NestedTriggersEnabled NestedTriggersEnabled NestedTriggersEnabled
NumericRoundAbortEnabled NumericRoundAbortEnabled NumericRoundAbortEnabled
ObjectInSpace ObjectInSpace ObjectInSpace Inherited from SqlSmoObject
Owner Owner Owner
PageVerify PageVerify PageVerify
ParameterSniffing ParameterSniffing ParameterSniffing

Get or set the Parameter_Sniffing of the database scoped configuration.

ParameterSniffingForSecondary ParameterSniffingForSecondary ParameterSniffingForSecondary

Get or set the Parameter_Sniffing for secondary of the database scoped configuration.

Parent Parent Parent
PartitionFunctions PartitionFunctions PartitionFunctions
PartitionSchemes PartitionSchemes PartitionSchemes
PlanGuides PlanGuides PlanGuides
PrimaryFilePath PrimaryFilePath PrimaryFilePath
Properties Properties Properties Inherited from SqlSmoObject
QueryOptimizerHotfixes QueryOptimizerHotfixes QueryOptimizerHotfixes

Get or set the Query_Optimizer_Hotfixes of the database scoped configuration.

QueryOptimizerHotfixesForSecondary QueryOptimizerHotfixesForSecondary QueryOptimizerHotfixesForSecondary

Get or set the Query_Optimizer_Hotfixes for secondary of the database scoped configuration.

QueryStoreOptions QueryStoreOptions QueryStoreOptions
QuotedIdentifiersEnabled QuotedIdentifiersEnabled QuotedIdentifiersEnabled
ReadOnly ReadOnly ReadOnly
RecoveryForkGuid RecoveryForkGuid RecoveryForkGuid
RecoveryModel RecoveryModel RecoveryModel
RecursiveTriggersEnabled RecursiveTriggersEnabled RecursiveTriggersEnabled
RemoteDataArchiveCredential RemoteDataArchiveCredential RemoteDataArchiveCredential
RemoteDataArchiveEnabled RemoteDataArchiveEnabled RemoteDataArchiveEnabled
RemoteDataArchiveEndpoint RemoteDataArchiveEndpoint RemoteDataArchiveEndpoint
RemoteDataArchiveLinkedServer RemoteDataArchiveLinkedServer RemoteDataArchiveLinkedServer
RemoteDataArchiveUseFederatedServiceAccount RemoteDataArchiveUseFederatedServiceAccount RemoteDataArchiveUseFederatedServiceAccount
RemoteDatabaseName RemoteDatabaseName RemoteDatabaseName
ReplicationOptions ReplicationOptions ReplicationOptions
Roles Roles Roles
Rules Rules Rules
ScalarResult ScalarResult ScalarResult Inherited from SqlSmoObject
Schemas Schemas Schemas
SearchPropertyLists SearchPropertyLists SearchPropertyLists
SecurityPolicies SecurityPolicies SecurityPolicies
Sequences Sequences Sequences
ServiceBroker ServiceBroker ServiceBroker
ServiceBrokerGuid ServiceBrokerGuid ServiceBrokerGuid
Size Size Size
SnapshotIsolationState SnapshotIsolationState SnapshotIsolationState
SpaceAvailable SpaceAvailable SpaceAvailable
State State State

Returns the state of the object

(Inherited from SmoObjectBase)
Status Status Status
StoredProcedures StoredProcedures StoredProcedures
SymmetricKeys SymmetricKeys SymmetricKeys
Synonyms Synonyms Synonyms
Tables Tables Tables
TargetRecoveryTime TargetRecoveryTime TargetRecoveryTime
TemporalHistoryRetentionEnabled TemporalHistoryRetentionEnabled TemporalHistoryRetentionEnabled
TransformNoiseWords TransformNoiseWords TransformNoiseWords
Triggers Triggers Triggers
Trustworthy Trustworthy Trustworthy
TwoDigitYearCutoff TwoDigitYearCutoff TwoDigitYearCutoff
Urn Urn Urn

Returns the Urn of the object, computed on the fly

(Inherited from SqlSmoObject)
UserAccess UserAccess UserAccess
UserData UserData UserData Inherited from SmoObjectBase
UserDefinedAggregates UserDefinedAggregates UserDefinedAggregates
UserDefinedDataTypes UserDefinedDataTypes UserDefinedDataTypes
UserDefinedFunctions UserDefinedFunctions UserDefinedFunctions
UserDefinedTableTypes UserDefinedTableTypes UserDefinedTableTypes
UserDefinedTypes UserDefinedTypes UserDefinedTypes
UserName UserName UserName
Users Users Users
Version Version Version
Views Views Views
WarnOnRename WarnOnRename WarnOnRename

Renaming a database should ask for confirmation

XmlSchemaCollections XmlSchemaCollections XmlSchemaCollections

Methods

AddDatabaseContext(StringCollection) AddDatabaseContext(StringCollection) AddDatabaseContext(StringCollection)

method get called from the create script related method (from derived classes like Table, Index etc..)

(Inherited from SqlSmoObject)
Alter() Alter() Alter()
Alter(TerminationClause) Alter(TerminationClause) Alter(TerminationClause)
Alter(TimeSpan) Alter(TimeSpan) Alter(TimeSpan)
AlterImpl() AlterImpl() AlterImpl() Inherited from SqlSmoObject
AlterImplWorker() AlterImplWorker() AlterImplWorker() Inherited from SqlSmoObject
AppendCommaText(StringBuilder, String, Boolean, String) AppendCommaText(StringBuilder, String, Boolean, String) AppendCommaText(StringBuilder, String, Boolean, String) Inherited from ScriptNameObjectBase
AppendWithCommaText(StringBuilder, String, Boolean) AppendWithCommaText(StringBuilder, String, Boolean) AppendWithCommaText(StringBuilder, String, Boolean) Inherited from ScriptNameObjectBase
AppendWithOption(StringBuilder, String, String, Boolean) AppendWithOption(StringBuilder, String, String, Boolean) AppendWithOption(StringBuilder, String, String, Boolean) Inherited from ScriptNameObjectBase
AutoGenerateName() AutoGenerateName() AutoGenerateName() Inherited from ScriptNameObjectBase
BindDefaultImpl(String, String, Boolean) BindDefaultImpl(String, String, Boolean) BindDefaultImpl(String, String, Boolean) Inherited from SqlSmoObject
BindRuleImpl(String, String, Boolean) BindRuleImpl(String, String, Boolean) BindRuleImpl(String, String, Boolean) Inherited from SqlSmoObject
ChangeMirroringState(MirroringOption) ChangeMirroringState(MirroringOption) ChangeMirroringState(MirroringOption)

Alters the database mirroring status

CheckAllocations(RepairType) CheckAllocations(RepairType) CheckAllocations(RepairType)

CheckAllocations

CheckAllocationsDataOnly() CheckAllocationsDataOnly() CheckAllocationsDataOnly()
CheckCatalog() CheckCatalog() CheckCatalog()
CheckIdentityValues() CheckIdentityValues() CheckIdentityValues()
CheckObjectDirty() CheckObjectDirty() CheckObjectDirty()

If there are some properties which are respected in special cases then use this function. currently applicable for DatabaseDdltriggers

(Inherited from ScriptNameObjectBase)
CheckObjectState() CheckObjectState() CheckObjectState() Inherited from SqlSmoObject
CheckObjectState(Boolean) CheckObjectState(Boolean) CheckObjectState(Boolean)

This is a virtual function, so that derived classes can override it if they want to do additional checks on the state of the object

(Inherited from SqlSmoObject)
CheckObjectStateImpl(Boolean) CheckObjectStateImpl(Boolean) CheckObjectStateImpl(Boolean)

Checks object state Because it is not recusrive, this function can be called directly and which means derived classes can't supply their own validation

(Inherited from SqlSmoObject)
Checkpoint() Checkpoint() Checkpoint()
CheckTables(RepairType) CheckTables(RepairType) CheckTables(RepairType)
CheckTables(RepairType, RepairOptions) CheckTables(RepairType, RepairOptions) CheckTables(RepairType, RepairOptions)
CheckTables(RepairType, RepairOptions, RepairStructure, Nullable<Int64>) CheckTables(RepairType, RepairOptions, RepairStructure, Nullable<Int64>) CheckTables(RepairType, RepairOptions, RepairStructure, Nullable<Int64>)
CheckTables(RepairType, RepairStructure) CheckTables(RepairType, RepairStructure) CheckTables(RepairType, RepairStructure)
CheckTablesDataOnly() CheckTablesDataOnly() CheckTablesDataOnly()
CheckTablesDataOnly(RepairOptions) CheckTablesDataOnly(RepairOptions) CheckTablesDataOnly(RepairOptions)
CheckTablesDataOnly(RepairOptions, RepairStructure, Nullable<Int64>) CheckTablesDataOnly(RepairOptions, RepairStructure, Nullable<Int64>) CheckTablesDataOnly(RepairOptions, RepairStructure, Nullable<Int64>)
CheckTablesDataOnly(RepairStructure) CheckTablesDataOnly(RepairStructure) CheckTablesDataOnly(RepairStructure)
CheckTextCorrectness(String, Boolean, Boolean, Boolean, String[], DdlTextParserHeaderInfo) CheckTextCorrectness(String, Boolean, Boolean, Boolean, String[], DdlTextParserHeaderInfo) CheckTextCorrectness(String, Boolean, Boolean, Boolean, String[], DdlTextParserHeaderInfo)

checks text syntax, that it manipulates the right type of object ( PROC, TRIGGER, etc )

(Inherited from ScriptNameObjectBase)
CheckTextCorrectness(String, Boolean, Boolean, String[], DdlTextParserHeaderInfo) CheckTextCorrectness(String, Boolean, Boolean, String[], DdlTextParserHeaderInfo) CheckTextCorrectness(String, Boolean, Boolean, String[], DdlTextParserHeaderInfo)

checks text syntax, that it manipulates the right type of object ( PROC, TRIGGER, etc )

(Inherited from ScriptNameObjectBase)
CheckTextModeSupport() CheckTextModeSupport() CheckTextModeSupport() Inherited from ScriptNameObjectBase
CleanObject() CleanObject() CleanObject() Inherited from ScriptNameObjectBase
Create() Create() Create()

Creates the database on the instance of SQL Server.

Create(Boolean) Create(Boolean) Create(Boolean)
CreateImpl() CreateImpl() CreateImpl() Inherited from SqlSmoObject
CreateOrAlterImpl() CreateOrAlterImpl() CreateOrAlterImpl() Inherited from SqlSmoObject
Deny(DatabasePermissionSet, String) Deny(DatabasePermissionSet, String) Deny(DatabasePermissionSet, String)
Deny(DatabasePermissionSet, String, Boolean) Deny(DatabasePermissionSet, String, Boolean) Deny(DatabasePermissionSet, String, Boolean)
Deny(DatabasePermissionSet, String[]) Deny(DatabasePermissionSet, String[]) Deny(DatabasePermissionSet, String[])
Deny(DatabasePermissionSet, String[], Boolean) Deny(DatabasePermissionSet, String[], Boolean) Deny(DatabasePermissionSet, String[], Boolean)
DisableAllPlanGuides() DisableAllPlanGuides() DisableAllPlanGuides()

DISABLE all the planguides

Discover() Discover() Discover()

Best Effort Discovery mechanism : This method reflects upon metadata and gets all available objects

(Inherited from SqlSmoObject)
Drop() Drop() Drop()
DropAllPlanGuides() DropAllPlanGuides() DropAllPlanGuides()

DROP all the planguides

DropBackupHistory() DropBackupHistory() DropBackupHistory()

Deletes the entries in the backup and restore history tables for database

DropIfExists() DropIfExists() DropIfExists()

Drops the object with IF EXISTS option. If object is invalid for drop function will return without exception.

DropImpl(Boolean) DropImpl(Boolean) DropImpl(Boolean)

drops the object

(Inherited from SqlSmoObject)
DropImplWorker(Urn, Boolean) DropImplWorker(Urn, Boolean) DropImplWorker(Urn, Boolean)

drops the object

(Inherited from SqlSmoObject)
EnableAllPlanGuides() EnableAllPlanGuides() EnableAllPlanGuides()

ENABLE all the planguides

EnumBackupSetFiles() EnumBackupSetFiles() EnumBackupSetFiles()
EnumBackupSetFiles(Int32) EnumBackupSetFiles(Int32) EnumBackupSetFiles(Int32)
EnumBackupSets() EnumBackupSets() EnumBackupSets()
EnumCandidateKeys() EnumCandidateKeys() EnumCandidateKeys()

The EnumCandidateKeys method returns a QueryResults object that enumerates the user tables of a Microsoft® SQL Server™ 2000 database and the constraints on those tables that could define primary keys.

EnumDatabasePermissions() EnumDatabasePermissions() EnumDatabasePermissions()
EnumDatabasePermissions(DatabasePermissionSet) EnumDatabasePermissions(DatabasePermissionSet) EnumDatabasePermissions(DatabasePermissionSet)
EnumDatabasePermissions(String) EnumDatabasePermissions(String) EnumDatabasePermissions(String)
EnumDatabasePermissions(String, DatabasePermissionSet) EnumDatabasePermissions(String, DatabasePermissionSet) EnumDatabasePermissions(String, DatabasePermissionSet)
EnumLocks() EnumLocks() EnumLocks()

EnumLocks

EnumLocks(Int32) EnumLocks(Int32) EnumLocks(Int32)

EnumLocks

EnumLoginMappings() EnumLoginMappings() EnumLoginMappings()

EnumLoginMappings

EnumMatchingSPs(String) EnumMatchingSPs(String) EnumMatchingSPs(String)

The EnumMatchingSPs method returns a QueryResults object that enumerates the stored procedures that contain the specified search text

EnumMatchingSPs(String, Boolean) EnumMatchingSPs(String, Boolean) EnumMatchingSPs(String, Boolean)

The EnumMatchingSPs method returns a QueryResults object that enumerates the stored procedures that contain the specified search text

EnumObjectPermissions() EnumObjectPermissions() EnumObjectPermissions()
EnumObjectPermissions(ObjectPermissionSet) EnumObjectPermissions(ObjectPermissionSet) EnumObjectPermissions(ObjectPermissionSet)
EnumObjectPermissions(String) EnumObjectPermissions(String) EnumObjectPermissions(String)
EnumObjectPermissions(String, ObjectPermissionSet) EnumObjectPermissions(String, ObjectPermissionSet) EnumObjectPermissions(String, ObjectPermissionSet)
EnumObjects() EnumObjects() EnumObjects()
EnumObjects(DatabaseObjectTypes) EnumObjects(DatabaseObjectTypes) EnumObjects(DatabaseObjectTypes)
EnumObjects(DatabaseObjectTypes, SortOrder) EnumObjects(DatabaseObjectTypes, SortOrder) EnumObjects(DatabaseObjectTypes, SortOrder)

The ListObjects method returns a SQLObjectList object that enumerates the system and user-defined objects defining the database referenced.

EnumTransactions() EnumTransactions() EnumTransactions()

Returns a set of active transactions

EnumTransactions(TransactionTypes) EnumTransactions(TransactionTypes) EnumTransactions(TransactionTypes)

Returns a set of active transactions

EnumWindowsGroups() EnumWindowsGroups() EnumWindowsGroups()

EnumWindowsGroups

EnumWindowsGroups(String) EnumWindowsGroups(String) EnumWindowsGroups(String)

EnumWindowsGroups

ExecuteNonQuery(String) ExecuteNonQuery(String) ExecuteNonQuery(String)
ExecuteNonQuery(String, ExecutionTypes) ExecuteNonQuery(String, ExecutionTypes) ExecuteNonQuery(String, ExecutionTypes)
ExecuteNonQuery(StringCollection) ExecuteNonQuery(StringCollection) ExecuteNonQuery(StringCollection)
ExecuteNonQuery(StringCollection, Boolean, Boolean) ExecuteNonQuery(StringCollection, Boolean, Boolean) ExecuteNonQuery(StringCollection, Boolean, Boolean)

Executes sql statements

(Inherited from SqlSmoObject)
ExecuteNonQuery(StringCollection, ExecutionTypes) ExecuteNonQuery(StringCollection, ExecutionTypes) ExecuteNonQuery(StringCollection, ExecutionTypes)
ExecuteRenameQuery(String) ExecuteRenameQuery(String) ExecuteRenameQuery(String)

Creates the Rename query for a SqlSmoObject and Executes it on the Server.

(Inherited from NamedSmoObject)
ExecuteWithModes(SqlExecutionModes, Action) ExecuteWithModes(SqlExecutionModes, Action) ExecuteWithModes(SqlExecutionModes, Action)

Executes the given action under the given execution modes.

Resets the original modes after the action completes or fails.

(Inherited from SqlSmoObject)
ExecuteWithResults(String) ExecuteWithResults(String) ExecuteWithResults(String)
ExecuteWithResults(StringCollection) ExecuteWithResults(StringCollection) ExecuteWithResults(StringCollection)
ForceTextModeOnTextBody() ForceTextModeOnTextBody() ForceTextModeOnTextBody() Inherited from ScriptNameObjectBase
FormatSqlVariant(Object) FormatSqlVariant(Object) FormatSqlVariant(Object) Inherited from SqlSmoObject
GenerateAlterEvent() GenerateAlterEvent() GenerateAlterEvent() Inherited from SqlSmoObject
GenerateAlterEvent(Urn, Object) GenerateAlterEvent(Urn, Object) GenerateAlterEvent(Urn, Object) Inherited from SqlSmoObject
GetBraketNameForText() GetBraketNameForText() GetBraketNameForText() Inherited from ScriptNameObjectBase
GetContextDB() GetContextDB() GetContextDB() Inherited from SqlSmoObject
GetDBName() GetDBName() GetDBName() Inherited from SqlSmoObject
GetFragOptionString(FragmentationOption) GetFragOptionString(FragmentationOption) GetFragOptionString(FragmentationOption) Inherited from SqlSmoObject
GetIsSystemNamed() GetIsSystemNamed() GetIsSystemNamed() Inherited from ScriptNameObjectBase
GetIsTextDirty() GetIsTextDirty() GetIsTextDirty() Inherited from ScriptNameObjectBase
GetPropValue(String) GetPropValue(String) GetPropValue(String)

Retrieve the property value from :

  • The property bag directly if property is available (dirty or retrieved)
  • A call to our OnPropertyMissing method otherwise

    Will throw an exception if the property value is NULL in either case.

(Inherited from SqlSmoObject)
GetPropValueOptional(String) GetPropValueOptional(String) GetPropValueOptional(String)

Retrieve the property value from :

  • The property bag if the state is creating or we're in Design Mode (possible NULL value)
  • A call to our OnPropertyMissing method otherwise (will throw exception if value is NULL)
(Inherited from SqlSmoObject)
GetPropValueOptionalAllowNull(String) GetPropValueOptionalAllowNull(String) GetPropValueOptionalAllowNull(String)

Retrieve the property value from :

  • The property bag if the state is creating or we're in Design Mode (possible NULL)
  • A call to our OnPropertyMissing method otherwise (possible NULL)
(Inherited from SqlSmoObject)
GetRealValue(Property, Object) GetRealValue(Property, Object) GetRealValue(Property, Object)

Returns the real value for the property.

(Inherited from SqlSmoObject)
GetRemoteDataArchiveMigrationStatusReports(DateTime, Int32, String) GetRemoteDataArchiveMigrationStatusReports(DateTime, Int32, String) GetRemoteDataArchiveMigrationStatusReports(DateTime, Int32, String)

Gets a list of remote data archive migration status reports

GetRemoteDatabaseMigrationStatistics() GetRemoteDatabaseMigrationStatistics() GetRemoteDatabaseMigrationStatistics()

Get remote database migration statistics. Null if Remote Data Archive is not enabled for database

GetServerName() GetServerName() GetServerName() Inherited from SqlSmoObject
GetServerObject() GetServerObject() GetServerObject() Inherited from SqlSmoObject
GetSqlServerVersionName() GetSqlServerVersionName() GetSqlServerVersionName()

Gets the sqlserver public name for the current connection, e.g: will transfer "SQLTOOLS2008-2" to "SQL Server 2008".

(Inherited from SqlSmoObject)
GetTextBody() GetTextBody() GetTextBody() Inherited from ScriptNameObjectBase
GetTextBody(Boolean) GetTextBody(Boolean) GetTextBody(Boolean) Inherited from ScriptNameObjectBase
GetTextHeader(Boolean) GetTextHeader(Boolean) GetTextHeader(Boolean) Inherited from ScriptNameObjectBase
GetTextHeader(ScriptNameObjectBase+ScriptHeaderType) GetTextHeader(ScriptNameObjectBase+ScriptHeaderType) GetTextHeader(ScriptNameObjectBase+ScriptHeaderType) Inherited from ScriptNameObjectBase
GetTextMode() GetTextMode() GetTextMode() Inherited from ScriptNameObjectBase
GetTextProperty(String) GetTextProperty(String) GetTextProperty(String)

get the text of the object, if not available, throw apropiate exception based on the State of the object

(Inherited from ScriptNameObjectBase)
GetTransactionCount() GetTransactionCount() GetTransactionCount()

Returns the number of open transactions

GetTransactionCount(TransactionTypes) GetTransactionCount(TransactionTypes) GetTransactionCount(TransactionTypes)

Returns the number of open transactions with

GetUrnRecursive(StringBuilder) GetUrnRecursive(StringBuilder) GetUrnRecursive(StringBuilder)

Computes the Urn for the object.

(Inherited from SqlSmoObject)
GetUrnRecursive(StringBuilder, UrnIdOption) GetUrnRecursive(StringBuilder, UrnIdOption) GetUrnRecursive(StringBuilder, UrnIdOption)

Computes the Urn for the object, potentially including other fields in the definition besides the key fields.

(Inherited from SqlSmoObject)
Grant(DatabasePermissionSet, String) Grant(DatabasePermissionSet, String) Grant(DatabasePermissionSet, String)
Grant(DatabasePermissionSet, String, Boolean) Grant(DatabasePermissionSet, String, Boolean) Grant(DatabasePermissionSet, String, Boolean)
Grant(DatabasePermissionSet, String, Boolean, String) Grant(DatabasePermissionSet, String, Boolean, String) Grant(DatabasePermissionSet, String, Boolean, String)
Grant(DatabasePermissionSet, String[]) Grant(DatabasePermissionSet, String[]) Grant(DatabasePermissionSet, String[])
Grant(DatabasePermissionSet, String[], Boolean) Grant(DatabasePermissionSet, String[], Boolean) Grant(DatabasePermissionSet, String[], Boolean)
Grant(DatabasePermissionSet, String[], Boolean, String) Grant(DatabasePermissionSet, String[], Boolean, String) Grant(DatabasePermissionSet, String[], Boolean, String)
ImplInitialize(String[], OrderBy[]) ImplInitialize(String[], OrderBy[]) ImplInitialize(String[], OrderBy[]) Inherited from SqlSmoObject
Initialize() Initialize() Initialize() Inherited from SqlSmoObject
Initialize(Boolean) Initialize(Boolean) Initialize(Boolean)

Initializes the object, by reading its properties from the enumerator

(Inherited from SqlSmoObject)
IsExpressSku() IsExpressSku() IsExpressSku()

Returns whether the server containing this object is an Express SKU

(Inherited from SqlSmoObject)
IsMember(String) IsMember(String) IsMember(String)

Determines if the current user is a member of the given group or role in the current database

IsObjectDirty() IsObjectDirty() IsObjectDirty() Inherited from ScriptNameObjectBase
IsObjectInitialized() IsObjectInitialized() IsObjectInitialized() Inherited from SqlSmoObject
IsObjectInSpace() IsObjectInSpace() IsObjectInSpace() Inherited from SqlSmoObject
IsSupportedProperty(String) IsSupportedProperty(String) IsSupportedProperty(String)

Validate whether the specified property is supported in current server environment

(Inherited from SqlSmoObject)
IsVersion80SP3() IsVersion80SP3() IsVersion80SP3() Inherited from SqlSmoObject
IsVersion90AndAbove() IsVersion90AndAbove() IsVersion90AndAbove() Inherited from SqlSmoObject
MarkDropped() MarkDropped() MarkDropped() Inherited from SqlSmoObject
MarkForDropImpl(Boolean) MarkForDropImpl(Boolean) MarkForDropImpl(Boolean) Inherited from SqlSmoObject
PostAlter() PostAlter() PostAlter()

this function is meant to be overriden by derived classes, if they have to do supplimentary actions after altering the object

(Inherited from SqlSmoObject)
PostCreate() PostCreate() PostCreate()

this function is meant to be overriden by derived classes, if they have to do supplimentary actions after object creation

(Inherited from SqlSmoObject)
PostDrop() PostDrop() PostDrop()

this function is meant to be overriden by derived classes, if they have to do supplimentary actions after dropping the object

(Inherited from SqlSmoObject)
PrefetchObjects() PrefetchObjects() PrefetchObjects()

Initializes all the objects in the database

PrefetchObjects(Type) PrefetchObjects(Type) PrefetchObjects(Type)

Initializes all the objects of type t and their children

PrefetchObjects(Type, ScriptingOptions) PrefetchObjects(Type, ScriptingOptions) PrefetchObjects(Type, ScriptingOptions)

Initializes all the objects of type t and their children needed to script with so

ReauthorizeRemoteDataArchiveConnection(String, Boolean) ReauthorizeRemoteDataArchiveConnection(String, Boolean) ReauthorizeRemoteDataArchiveConnection(String, Boolean)

Reauthorize a stretched database with the SQL Azure server after the database is restored from a backup

RecalculateSpaceUsage() RecalculateSpaceUsage() RecalculateSpaceUsage()
Refresh() Refresh() Refresh()
RemoveFullTextCatalogs() RemoveFullTextCatalogs() RemoveFullTextCatalogs()
Rename(String) Rename(String) Rename(String)
RenameImpl(String) RenameImpl(String) RenameImpl(String)

change object name

(Inherited from NamedSmoObject)
RenameImplWorker(String) RenameImplWorker(String) RenameImplWorker(String) Inherited from NamedSmoObject
Revoke(DatabasePermissionSet, String) Revoke(DatabasePermissionSet, String) Revoke(DatabasePermissionSet, String)
Revoke(DatabasePermissionSet, String, Boolean, Boolean) Revoke(DatabasePermissionSet, String, Boolean, Boolean) Revoke(DatabasePermissionSet, String, Boolean, Boolean)
Revoke(DatabasePermissionSet, String, Boolean, Boolean, String) Revoke(DatabasePermissionSet, String, Boolean, Boolean, String) Revoke(DatabasePermissionSet, String, Boolean, Boolean, String)
Revoke(DatabasePermissionSet, String[]) Revoke(DatabasePermissionSet, String[]) Revoke(DatabasePermissionSet, String[])
Revoke(DatabasePermissionSet, String[], Boolean, Boolean) Revoke(DatabasePermissionSet, String[], Boolean, Boolean) Revoke(DatabasePermissionSet, String[], Boolean, Boolean)
Revoke(DatabasePermissionSet, String[], Boolean, Boolean, String) Revoke(DatabasePermissionSet, String[], Boolean, Boolean, String) Revoke(DatabasePermissionSet, String[], Boolean, Boolean, String)
Script() Script() Script()
Script(ScriptingOptions) Script(ScriptingOptions) Script(ScriptingOptions)
ScriptImpl() ScriptImpl() ScriptImpl() Inherited from SqlSmoObject
ScriptImpl(ScriptingOptions) ScriptImpl(ScriptingOptions) ScriptImpl(ScriptingOptions)

Returns a StringCollection object with the script for the object. This method throws an error if ScriptData is true

(Inherited from SqlSmoObject)
SetAccessToken(IRenewableToken) SetAccessToken(IRenewableToken) SetAccessToken(IRenewableToken)

Set the accessToken for connection.

(Inherited from SqlSmoObject)
SetCollectionTextMode(Boolean, SmoCollectionBase) SetCollectionTextMode(Boolean, SmoCollectionBase) SetCollectionTextMode(Boolean, SmoCollectionBase) Inherited from ScriptNameObjectBase
SetDefaultFileGroup(String) SetDefaultFileGroup(String) SetDefaultFileGroup(String)
SetDefaultFileStreamFileGroup(String) SetDefaultFileStreamFileGroup(String) SetDefaultFileStreamFileGroup(String)
SetDefaultFullTextCatalog(String) SetDefaultFullTextCatalog(String) SetDefaultFullTextCatalog(String)
SetIsSystemNamed(Boolean) SetIsSystemNamed(Boolean) SetIsSystemNamed(Boolean) Inherited from ScriptNameObjectBase
SetOffline() SetOffline() SetOffline()
SetOnline() SetOnline() SetOnline()
SetOwner(String) SetOwner(String) SetOwner(String)

Sets the owner of this database to the login with the specified name. Does not drop any existing user accounts mapped to the login before attempting to change the owner.

SetOwner(String, Boolean) SetOwner(String, Boolean) SetOwner(String, Boolean)

Sets the owner of this database to the login with the specified name.

SetParentImpl(SqlSmoObject) SetParentImpl(SqlSmoObject) SetParentImpl(SqlSmoObject) Inherited from SqlSmoObject
SetSchemaOwned() SetSchemaOwned() SetSchemaOwned() Inherited from NamedSmoObject
SetSnapshotIsolation(Boolean) SetSnapshotIsolation(Boolean) SetSnapshotIsolation(Boolean)

Enables or disables snapshot isolation for the current database

SetTextBody(String) SetTextBody(String) SetTextBody(String) Inherited from ScriptNameObjectBase
SetTextHeader(String) SetTextHeader(String) SetTextHeader(String) Inherited from ScriptNameObjectBase
SetTextMode(Boolean, SmoCollectionBase[]) SetTextMode(Boolean, SmoCollectionBase[]) SetTextMode(Boolean, SmoCollectionBase[]) Inherited from ScriptNameObjectBase
Shrink(Int32, ShrinkMethod) Shrink(Int32, ShrinkMethod) Shrink(Int32, ShrinkMethod)

Shrinks a database

SwitchTextMode(Boolean, SmoCollectionBase[]) SwitchTextMode(Boolean, SmoCollectionBase[]) SwitchTextMode(Boolean, SmoCollectionBase[]) Inherited from ScriptNameObjectBase
ThrowIfAboveVersion100(String) ThrowIfAboveVersion100(String) ThrowIfAboveVersion100(String)

Throws an exception if the ServerVersion major version for this object is above 10.0 (SQL 2008)

(Inherited from SqlSmoObject)
ThrowIfAboveVersion80(String) ThrowIfAboveVersion80(String) ThrowIfAboveVersion80(String)

Throws an exception if the ServerVersion major version for this object is above 8.0 (SQL 2000)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion100(String) ThrowIfBelowVersion100(String) ThrowIfBelowVersion100(String)

Throws an exception if the ServerVersion major version for this object is below 10.0 (SQL 2008)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion110(String) ThrowIfBelowVersion110(String) ThrowIfBelowVersion110(String)

Throws an UnsupportedVersionException if either the source or destination server is below 11.0 (SQL 2012)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion110Prop(String) ThrowIfBelowVersion110Prop(String) ThrowIfBelowVersion110Prop(String)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 11.0 (SQL 2012)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion120(String) ThrowIfBelowVersion120(String) ThrowIfBelowVersion120(String)

Throws an exception if the ServerVersion major version for this object is below 12.0 (SQL 2014)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion120Prop(String) ThrowIfBelowVersion120Prop(String) ThrowIfBelowVersion120Prop(String)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 12.0 (SQL 2014)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion130(String) ThrowIfBelowVersion130(String) ThrowIfBelowVersion130(String)

Throws an exception if the ServerVersion major version for this object is below 13.0 (SQL 2016)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion130Prop(String) ThrowIfBelowVersion130Prop(String) ThrowIfBelowVersion130Prop(String)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 13.0 (SQL 2016)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion140(String) ThrowIfBelowVersion140(String) ThrowIfBelowVersion140(String)

Throws an exception if the ServerVersion major version for this object is below 14.0 (SQL 2017)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion140Prop(String) ThrowIfBelowVersion140Prop(String) ThrowIfBelowVersion140Prop(String)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 14.0 (SQL 2017)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion80(String) ThrowIfBelowVersion80(String) ThrowIfBelowVersion80(String)

Throws an exception if the ServerVersion major version for this object is below 8.0 (SQL 2000)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion80SP3() ThrowIfBelowVersion80SP3() ThrowIfBelowVersion80SP3()

Throws an exception if the ServerVersion for this object is below 8.760 (8.0 SP3)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion90(String) ThrowIfBelowVersion90(String) ThrowIfBelowVersion90(String)

Throws an exception if the ServerVersion major version for this object is below 9.0 (SQL 2005)

(Inherited from SqlSmoObject)
ThrowIfTextIsDirtyForAlter() ThrowIfTextIsDirtyForAlter() ThrowIfTextIsDirtyForAlter() Inherited from ScriptNameObjectBase
ToString() ToString() ToString() Inherited from SqlSmoObject
Touch() Touch() Touch()

Mark the object "touched" for unconditional scripting of Alter.

(Inherited from SqlSmoObject)
TouchImpl() TouchImpl() TouchImpl()

Virtual method to allow derived classes to do additional work when touched.

(Inherited from SqlSmoObject)
TruncateLog() TruncateLog() TruncateLog()

Truncate log. This is supported in SQL Server 2005 for backwards compatibility reasons.

UnbindDefaultImpl(Boolean) UnbindDefaultImpl(Boolean) UnbindDefaultImpl(Boolean) Inherited from SqlSmoObject
UnbindRuleImpl(Boolean) UnbindRuleImpl(Boolean) UnbindRuleImpl(Boolean) Inherited from SqlSmoObject
UpdateIndexStatistics() UpdateIndexStatistics() UpdateIndexStatistics()

Update statistics for all indexes in the database.

Validate(String, Object[]) Validate(String, Object[]) Validate(String, Object[]) Inherited from SmoObjectBase
ValidateAllPlanGuides() ValidateAllPlanGuides() ValidateAllPlanGuides()

Validate all the planguides

ValidateAllPlanGuides(DataTable) ValidateAllPlanGuides(DataTable) ValidateAllPlanGuides(DataTable)

Validate all the planguides

Explicit Interface Implementations

IAlienObject.Discover() IAlienObject.Discover() IAlienObject.Discover() Inherited from SqlSmoObject
IAlienObject.GetDomainRoot() IAlienObject.GetDomainRoot() IAlienObject.GetDomainRoot() Inherited from SqlSmoObject
IAlienObject.GetParent() IAlienObject.GetParent() IAlienObject.GetParent() Inherited from SqlSmoObject
IAlienObject.GetPropertyType(String) IAlienObject.GetPropertyType(String) IAlienObject.GetPropertyType(String)

Discovers type of property.

(Inherited from SqlSmoObject)
IAlienObject.GetPropertyValue(String, Type) IAlienObject.GetPropertyValue(String, Type) IAlienObject.GetPropertyValue(String, Type)

Retrieves value for a given property. Throws if property is not found.

(Inherited from SqlSmoObject)
IAlienObject.GetUrn() IAlienObject.GetUrn() IAlienObject.GetUrn() Inherited from SqlSmoObject
IAlienObject.Resolve(String) IAlienObject.Resolve(String) IAlienObject.Resolve(String) Inherited from SqlSmoObject
IAlienObject.SetObjectState(SfcObjectState) IAlienObject.SetObjectState(SfcObjectState) IAlienObject.SetObjectState(SfcObjectState)

Sets state of this object based on provided SfcObjectState.

(Inherited from SqlSmoObject)
IAlienObject.SetPropertyValue(String, Type, Object) IAlienObject.SetPropertyValue(String, Type, Object) IAlienObject.SetPropertyValue(String, Type, Object)

Sets the value of given property, if it is writable. If property is not in property bag, reflection is used. Throws exception if the property is not found.

(Inherited from SqlSmoObject)
ISfcPropertyProvider.GetPropertySet() ISfcPropertyProvider.GetPropertySet() ISfcPropertyProvider.GetPropertySet() Inherited from SqlSmoObject
ISfcSupportsDesignMode.IsDesignMode ISfcSupportsDesignMode.IsDesignMode ISfcSupportsDesignMode.IsDesignMode

This object extend ISfcSupportsDesignMode.

Fields

m_ExtendedProperties m_ExtendedProperties m_ExtendedProperties Inherited from SqlSmoObject
singletonParent singletonParent singletonParent

Regular SMO objects access the parent class reference through parentColl (corresponding collection in parent class). Singleton class has no collection in parent.

(Inherited from SqlSmoObject)

Events

PropertyChanged PropertyChanged PropertyChanged Inherited from SqlSmoObject
PropertyMetadataChanged PropertyMetadataChanged PropertyMetadataChanged Inherited from SqlSmoObject

Applies to