Partager via


Membres Database

The Database object represents a SQL Server database.

Le type Database expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique Database() () () () Initializes a new instance of the Database class.
Méthode publique Database(Server, String) Initializes a new instance of the Database class on the specified server and with the specified name.

Haut de la page

Méthodes

  Nom Description
Méthode protégée AddDatabaseContext (Hérité de SqlSmoObject.)
Méthode publique Alter() () () () Updates any Database object property changes on the instance of SQL Server. 
Méthode publique Alter(TimeSpan) Updates any Database object property changes on the instance of SQL Server. 
Méthode publique Alter(TerminationClause) Updates any Database object property changes on the instance of SQL Server. 
Méthode protégée AlterImpl (Hérité de SqlSmoObject.)
Méthode protégée AlterImplFinish (Hérité de SqlSmoObject.)
Méthode protégée AlterImplInit (Hérité de SqlSmoObject.)
Méthode protégée AlterImplWorker (Hérité de SqlSmoObject.)
Méthode protégée AppendCommaText (Hérité de ScriptNameObjectBase.)
Méthode protégée AppendWithCommaText (Hérité de ScriptNameObjectBase.)
Méthode protégée AppendWithOption (Hérité de ScriptNameObjectBase.)
Méthode protégée BindDefaultImpl (Hérité de SqlSmoObject.)
Méthode protégée BindRuleImpl (Hérité de SqlSmoObject.)
Méthode publique ChangeMirroringState Changes the mirroring configuration as specified by the options.
Méthode publique CheckAllocations Scans all pages of the referenced database and tests pages to help ensure integrity.
Méthode publique CheckAllocationsDataOnly Scans all pages of the referenced database and tests only the data to help ensure integrity.
Méthode publique CheckCatalog Tests the integrity of the database catalog.
Méthode protégée CheckCollation (Hérité de SqlSmoObject.)
Méthode publique CheckIdentityValues Verifies the integrity of all identity columns in tables in the database.
Méthode protégée CheckObjectDirty (Hérité de ScriptNameObjectBase.)
Méthode protégée CheckObjectState() () () () Validates the state of the referenced object. (Hérité de SqlSmoObject.)
Méthode protégée CheckObjectState(Boolean) Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (Hérité de SqlSmoObject.)
Méthode protégée CheckObjectStateImpl (Hérité de SqlSmoObject.)
Méthode publique Checkpoint Issues a checkpoint.
Méthode publique CheckTables(RepairType)
Méthode publique CheckTables(RepairType, RepairOptions)
Méthode publique CheckTables(RepairType, RepairStructure)
Méthode publique CheckTables(RepairType, RepairOptions, RepairStructure)
Méthode publique CheckTablesDataOnly() () () () Tests integrity of data in pages that store data for all tables and indexes defined on the tables of the referenced database.
Méthode publique CheckTablesDataOnly(RepairOptions) Tests integrity of data in pages that store data for all tables and indexes defined on the tables of the referenced database, with the specified repair options.
Méthode publique CheckTablesDataOnly(RepairStructure) Tests integrity of data in pages that store data for all tables and indexes defined on the tables of the referenced database with the specified repair structure.
Méthode publique CheckTablesDataOnly(RepairOptions, RepairStructure) Tests integrity of data in pages that store data for all tables and indexes defined on the tables of the referenced database with the specified repair options and repair structure.
Méthode protégée CheckTextCorectness (Hérité de ScriptNameObjectBase.)
Méthode protégée CheckTextModeSupport (Hérité de ScriptNameObjectBase.)
Méthode protégée CheckVersion100 (Hérité de SqlSmoObject.)
Méthode protégée CheckVersion80 Checks the validity of the object on SQL Server 2000. (Hérité de SqlSmoObject.)
Méthode protégée CheckVersion80SP3 Checks the validity of the object on SQL Server 2000 SP3. (Hérité de SqlSmoObject.)
Méthode protégée CheckVersion90 Check the validity of the object on SQL Server 2005. (Hérité de SqlSmoObject.)
Méthode protégée CheckVersionBelow90 (Hérité de SqlSmoObject.)
Méthode protégée CleanObject Cleans the referenced object. (Hérité de ScriptNameObjectBase.)
Méthode publique Create() () () () Creates a database on the instance of SQL Server as defined by the Database object.
Méthode publique Create(Boolean) Creates a database on the instance of SQL Server as defined by the Database object.
Méthode protégée CreateImpl (Hérité de SqlSmoObject.)
Méthode protégée CreateImplFinish (Hérité de SqlSmoObject.)
Méthode protégée CreateImplInit (Hérité de SqlSmoObject.)
Méthode publique Deny(DatabasePermissionSet, String) Denies the specified set of permissions for the specified grantee on the database.
Méthode publique Deny(DatabasePermissionSet, array<String> [] () [] []) Denies the specified set of permissions for the specified grantees on the database.
Méthode publique Deny(DatabasePermissionSet, String, Boolean) Denies the specified set of permissions for the specified grantee and other users who the grantee granted the specified set of permissions on the database.
Méthode publique Deny(DatabasePermissionSet, array<String> [] () [] [], Boolean) Denies the specified set of permissions for the specified grantees and other users who the grantee granted the specified set of permissions on the database.
Méthode publique DisableAllPlanGuides Disables all Plan Guides in a database.
Méthode publique Discover (Hérité de SqlSmoObject.)
Méthode publique Drop Drops the database.
Méthode publique DropAllPlanGuides Drops all Plan Guides in a database.
Méthode publique DropBackupHistory Drops the backup history for the database.
Méthode protégée DropImpl (Hérité de SqlSmoObject.)
Méthode protégée DropImplWorker (Hérité de SqlSmoObject.)
Méthode publique EnableAllPlanGuides Enables all Plan Guides in a database.
Méthode publique EnumBackupSetFiles() () () () Returns a DataTable listing files contained in a backup set.
Méthode publique EnumBackupSetFiles(Int32) Returns a Data table that lists the files in a backup set
Méthode publique EnumBackupSets Returns a DataTable listing the backup sets associated with a database.
Méthode publique EnumCandidateKeys Enumerates a list of all candidate primary keys in the database, which can be referenced by a foreign key.
Méthode publique EnumDatabasePermissions() () () () Enumerates a list of all permissions in the database.
Méthode publique EnumDatabasePermissions(String) Enumerates a list of permissions in the database for the specified user.
Méthode publique EnumDatabasePermissions(DatabasePermissionSet) Enumerates a list of permissions in the database for the specified permission set.
Méthode publique EnumDatabasePermissions(String, DatabasePermissionSet) Enumerates a list of permissions in the database for the specified user and a specified permission set.
Méthode publique EnumLocks() () () () Enumerates a list of all current locks held on the database.
Méthode publique EnumLocks(Int32) Enumerates a list of current locks held on the database for a specified system process ID.
Méthode publique EnumLoginMappings Enumerates a list of SQL Server logins for all the users in the database.
Méthode publique EnumMatchingSPs(String) Enumerates a list of stored procedures that contain the specified string in the definition.
Méthode publique EnumMatchingSPs(String, Boolean) Enumerates a list of stored procedures that contain the specified string in the definition.
Méthode publique EnumObjectPermissions() () () () Enumerates a list of permissions for objects in the database.
Méthode publique EnumObjectPermissions(String) Enumerates a list of permissions for objects in the database that belong to the specified user.
Méthode publique EnumObjectPermissions(ObjectPermissionSet) Enumerates a list of permissions for objects in the database limited to the specified permission set.
Méthode publique EnumObjectPermissions(String, ObjectPermissionSet) Enumerates a list of permissions for objects in the database that belong to the specified user and limited to the specified permission set.
Méthode publique EnumObjects() () () () Enumerates a list of objects in the database.
Méthode publique EnumObjects(DatabaseObjectTypes) Enumerates a list of objects in the database.
Méthode publique EnumObjects(DatabaseObjectTypes, SortOrder) Enumerates a list of objects in the database.
Méthode protégée EnumScriptImpl (Hérité de SqlSmoObject.)
Méthode protégée EnumScriptImplWorker (Hérité de SqlSmoObject.)
Méthode publique EnumTransactions() () () () Enumerates a list of open transactions on the database.
Méthode publique EnumTransactions(TransactionTypes) Enumerates a list of open transactions of a specified type on the database.
Méthode publique EnumWindowsGroups() () () () Enumerates a list of Windows groups.
Méthode publique EnumWindowsGroups(String) Enumerates a list of Windows groups for a specified group.
Méthode publique Equals (Hérité de Object.)
Méthode publique ExecuteNonQuery(StringCollection) Executes a batch in the context of the database where there are no results returned.
Méthode publique ExecuteNonQuery(String) Executes a statement in the context of the database where there are no results returned.
Méthode publique ExecuteNonQuery(StringCollection, ExecutionTypes) Runs a collection of batches in the context of the database where there are no results returned for the specified execution type only.
Méthode publique ExecuteNonQuery(String, ExecutionTypes) Executes a batch in the context of the database where there are no results returned for the specified execution type only.
Méthode publique ExecuteWithResults(StringCollection) Executes a batch in the context of the database where there are results returned.
Méthode publique ExecuteWithResults(String) Executes a collection of batches in the context of the database where there are results returned.
Méthode protégée Finalize (Hérité de Object.)
Méthode protégée ForceTextModeOnTextBody Enforces text mode on the text body. (Hérité de ScriptNameObjectBase.)
Méthode protégée FormatSqlVariant (Hérité de SqlSmoObject.)
Méthode protégée GenerateDataSpaceFileStreamScript (Hérité de SqlSmoObject.)
Méthode protégée GenerateDataSpaceScript (Hérité de SqlSmoObject.)
Méthode protégée GetBindDefaultScript (Hérité de SqlSmoObject.)
Méthode protégée GetBindRuleScript (Hérité de SqlSmoObject.)
Méthode protégée GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Hérité de SqlSmoObject.)
Méthode protégée GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Hérité de SqlSmoObject.)
Méthode protégée GetBraketNameForText (Hérité de ScriptNameObjectBase.)
Méthode protégée GetDateTimeParameter (Hérité de SqlSmoObject.)
Méthode protégée GetDateTimeParameterAsInt (Hérité de SqlSmoObject.)
Méthode protégée GetDBName Gets the database name that is associated with the object. (Hérité de SqlSmoObject.)
Méthode protégée GetEnumParameter (Hérité de SqlSmoObject.)
Méthode protégée GetFragOptionString (Hérité de SqlSmoObject.)
Méthode protégée GetGuidParameter (Hérité de SqlSmoObject.)
Méthode publique GetHashCode (Hérité de Object.)
Méthode protégée GetIsTextDirty Determines whether the text value is consistent with stored value. (Hérité de ScriptNameObjectBase.)
Méthode protégée GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Hérité de SqlSmoObject.)
Méthode protégée GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Hérité de SqlSmoObject.)
Méthode protégée GetPropValue (Hérité de SqlSmoObject.)
Méthode protégée GetPropValueOptional (Hérité de SqlSmoObject.)
Méthode protégée GetPropValueOptionalAllowNull (Hérité de SqlSmoObject.)
Méthode protégée GetRealValue (Hérité de SqlSmoObject.)
Méthode protégée GetScriptIncludeExists (Hérité de ScriptNameObjectBase.)
Méthode protégée GetScriptingOptionsForCreate (Hérité de SqlSmoObject.)
Méthode protégée GetServerName Gets the name of the instance of SQL Server with which the object is associated. (Hérité de SqlSmoObject.)
Méthode protégée GetServerObject (Hérité de SqlSmoObject.)
Méthode protégée GetSqlServerVersionName Gets the version name of the instance of SQL Server with which the object is associated. (Hérité de SqlSmoObject.)
Méthode protégée GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Hérité de SqlSmoObject.)
Méthode protégée GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Hérité de SqlSmoObject.)
Méthode protégée GetTextBody() () () () Returns the text body. (Hérité de ScriptNameObjectBase.)
Méthode protégée GetTextBody(Boolean) Returns the text body. (Hérité de ScriptNameObjectBase.)
Méthode protégée GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] []) Gets the text for scripting. (Hérité de ScriptNameObjectBase.)
Méthode protégée GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [], Boolean) (Hérité de ScriptNameObjectBase.)
Méthode protégée GetTextHeader Returns the text header. (Hérité de ScriptNameObjectBase.)
Méthode protégée GetTextMode Determines whether the script name is using text mode. (Hérité de ScriptNameObjectBase.)
Méthode protégée GetTextProperty(String) (Hérité de ScriptNameObjectBase.)
Méthode protégée GetTextProperty(String, ScriptingOptions) (Hérité de ScriptNameObjectBase.)
Méthode protégée GetTimeSpanParameterAsInt (Hérité de SqlSmoObject.)
Méthode publique GetTransactionCount() () () () Gets the number of open transactions on the database.
Méthode publique GetTransactionCount(TransactionTypes) Gets the number of open transactions of a specified type on the database.
Méthode publique GetType (Hérité de Object.)
Méthode protégée GetUrnRecursive(StringBuilder) (Hérité de SqlSmoObject.)
Méthode protégée GetUrnRecursive(StringBuilder, UrnIdOption) (Hérité de SqlSmoObject.)
Méthode publique Grant(DatabasePermissionSet, String) Grants the specified set of permissions to the specified grantee on the database.
Méthode publique Grant(DatabasePermissionSet, array<String> [] () [] []) Grants the specified set of permissions to the specified grantees on the database.
Méthode publique Grant(DatabasePermissionSet, String, Boolean) Grants access to the specified permission to the grantee and the ability to grant access to other users on the database.
Méthode publique Grant(DatabasePermissionSet, array<String> [] () [] [], Boolean) Grants access to the specified permission to the grantees and the ability to grant access to other users on the database.
Méthode publique Grant(DatabasePermissionSet, String, Boolean, String) Grants the specified set of permissions to the grantee and the ability to grant the set of permissions to other users on the database under an assumed role.
Méthode publique Grant(DatabasePermissionSet, array<String> [] () [] [], Boolean, String) Grants the specified set of permissions to the grantees and the ability to grant the set of permissions to other users on the database under an assumed role.
Méthode protégée ImplInitialize (Hérité de SqlSmoObject.)
Méthode publique Initialize() () () () Initializes the object and forces the properties be loaded. (Hérité de SqlSmoObject.)
Méthode publique Initialize(Boolean) Initializes the object and forces the properties be loaded. (Hérité de SqlSmoObject.)
Méthode publique IsMember Determines whether the specified group or role belongs to the database.
Méthode protégée IsObjectDirty Determines whether the referenced object is consistent with the stored object. (Hérité de ScriptNameObjectBase.)
Méthode protégée IsObjectInitialized Verifies whether the object has been initialized. (Hérité de SqlSmoObject.)
Méthode protégée IsObjectInSpace Verifies whether the object is isolated or connected to the instance of SQL Server. (Hérité de SqlSmoObject.)
Méthode protégée IsVersion80SP3 (Hérité de SqlSmoObject.)
Méthode protégée MarkDropped (Hérité de SqlSmoObject.)
Méthode protégée MarkForDropImpl (Hérité de SqlSmoObject.)
Méthode protégée MemberwiseClone (Hérité de Object.)
Méthode protégée PostAlter (Hérité de SqlSmoObject.)
Méthode protégée PostCreate (Hérité de SqlSmoObject.)
Méthode protégée PostDrop (Hérité de SqlSmoObject.)
Méthode publique PrefetchObjects() () () () Prefetches database objects.
Méthode publique PrefetchObjects(Type) Prefetches database objects of a specified type.
Méthode publique PrefetchObjects(Type, ScriptingOptions) Prefetches database objects of a specified type with scripting options.
Méthode publique RecalculateSpaceUsage Recalculates space usage.
Méthode publique Refresh Updates the Database object. (Se substitue à ScriptNameObjectBase. . :: . .Refresh() () () ().)
Méthode publique RemoveFullTextCatalogs Removes full-text catalogs from the database.
Méthode publique Rename Renames the database.
Méthode protégée RenameImpl This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.)
Méthode protégée RenameImplWorker This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.)
Méthode publique Revoke(DatabasePermissionSet, String) Revokes a previously granted set of permissions from a grantee on the database.
Méthode publique Revoke(DatabasePermissionSet, array<String> [] () [] []) Revokes a previously granted set of permissions from a list of grantees on the database.
Méthode publique Revoke(DatabasePermissionSet, String, Boolean, Boolean) Revokes previously granted permissions from a grantee on the database and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.
Méthode publique Revoke(DatabasePermissionSet, array<String> [] () [] [], Boolean, Boolean) Revokes previously granted permissions from grantees on the database and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.
Méthode publique Revoke(DatabasePermissionSet, String, Boolean, Boolean, String) Revokes previously granted permissions from a grantee on the database and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.
Méthode publique Revoke(DatabasePermissionSet, array<String> [] () [] [], Boolean, Boolean, String) Revokes previously granted permissions from grantees on the database and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.
Méthode publique Script() () () () Generates a Transact-SQL script that can be used to re-create the database.
Méthode publique Script(ScriptingOptions) Generates a Transact-SQL script that can be used to re-create the database as specified by the script options.
Méthode protégée ScriptAlter (Hérité de SqlSmoObject.)
Méthode protégée ScriptAnsiQI (Hérité de ScriptNameObjectBase.)
Méthode protégée ScriptChangeOwner This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.)
Méthode protégée ScriptCreate (Hérité de SqlSmoObject.)
Méthode protégée ScriptDdl (Hérité de SqlSmoObject.)
Méthode protégée ScriptDrop (Hérité de SqlSmoObject.)
Méthode protégée ScriptImpl() () () () (Hérité de SqlSmoObject.)
Méthode protégée ScriptImpl(ScriptingOptions) (Hérité de SqlSmoObject.)
Méthode protégée ScriptImplWorker (Hérité de SqlSmoObject.)
Méthode protégée ScriptInformativeHeaders (Hérité de ScriptNameObjectBase.)
Méthode protégée ScriptRename This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.)
Méthode protégée SetCollectionTextMode Sets the collection text mode. (Hérité de ScriptNameObjectBase.)
Méthode publique SetDefaultFileGroup Sets the default file group for the database.
Méthode publique SetDefaultFileStreamFileGroup Sets the default filestream group.
Méthode publique SetDefaultFullTextCatalog Sets the default full-text catalog for the database.
Méthode publique SetOffline Sets the database offline.
Méthode publique SetOnline Sets the database online.
Méthode publique SetOwner(String) Sets the database owner.
Méthode publique SetOwner(String, Boolean) Sets the database owner.
Méthode protégée SetParentImpl (Hérité de SqlSmoObject.)
Méthode publique SetSnapshotIsolation Sets the snapshot isolation level.
Méthode protégée SetTextBody Specifies the text body. (Hérité de ScriptNameObjectBase.)
Méthode protégée SetTextHeader Specifies the text header. (Hérité de ScriptNameObjectBase.)
Méthode protégée SetTextMode Specifies the text mode. (Hérité de ScriptNameObjectBase.)
Méthode publique Shrink Shrinks the database.
Méthode protégée SwitchTextMode Switches the text mode. (Hérité de ScriptNameObjectBase.)
Méthode protégée ThrowIfTextIsDirtyForAlter (Hérité de ScriptNameObjectBase.)
Méthode publique ToString Returns a String that represents the referenced object. (Hérité de SqlSmoObject.)
Méthode protégée TouchImpl (Hérité de SqlSmoObject.)
Méthode publique TruncateLog Truncates the database log.
Méthode protégée UnbindDefaultImpl (Hérité de SqlSmoObject.)
Méthode protégée UnbindRuleImpl (Hérité de SqlSmoObject.)
Méthode publique UpdateIndexStatistics Updates index statistics.
Méthode publique Validate (Hérité de SmoObjectBase.)
Méthode publique ValidateAllPlanGuides() () () () Verifies the validity of the execution plans associated with the database.
Méthode publique ValidateAllPlanGuides(DataTable%)

Haut de la page

Champs

  Nom Description
Champ protégé m_ExtendedProperties (Hérité de SqlSmoObject.)

Haut de la page

Propriétés

  Nom Description
Propriété publique ActiveConnections Gets the number of active connections to the database.
Propriété publique ActiveDirectory Gets the information about the Active Directory settings for the database.
Propriété publique AnsiNullDefault Gets or sets AnsiNullDefault Property.
Propriété publique AnsiNullsEnabled Gets or sets the Boolean ANSI_NULLS_ENABLED property value.
Propriété publique AnsiPaddingEnabled Gets or sets the ANSI_PADDING_ENABLED database option is enabled.
Propriété publique AnsiWarningsEnabled Gets or sets the Boolean ANSI_WARNING_ENABLED property value.
Propriété publique ApplicationRoles Represents a collection of ApplicationRole objects. Each ApplicationRole object represents an application role defined on the database.
Propriété publique ArithmeticAbortEnabled Gets or sets the ARITHMETICABORT property value.
Propriété publique Assemblies Represents a collection of SqlAssembly objects. Each SqlAssembly object represents an assembly defined on the database.
Propriété publique AsymmetricKeys Represents a collection of AsymmetricKey objects. Each AsymmetricKey object represents an asymmetric key defined on the database.
Propriété publique AutoClose Gets or sets the AUTOCLOSE database option is set.
Propriété publique AutoCreateStatisticsEnabled Gets a Boolean property value that specifies whether statistics are automatically created for the database.
Propriété publique AutoShrink Gets or sets the AUTO_SHRINK database option.
Propriété publique AutoUpdateStatisticsAsync Gets or sets a property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active.
Propriété publique AutoUpdateStatisticsEnabled Gets a Boolean property value that specifies whether statistics are automatically updated for the database.
Propriété publique BrokerEnabled Gets or sets a property value that specifies whether the Service Broker service is enabled.
Propriété publique CaseSensitive Gets a Boolean property value that specifies whether uppercase letters and lowercase letters are evaluated as equal.
Propriété publique Certificates Represents a collection of Certificate objects. Each Certificate object represents a certificate defined on the database.
Propriété publique ChangeTrackingAutoCleanUp Gets or sets a Boolean property value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled.
Propriété publique ChangeTrackingEnabled Gets or sets a property value that specifies whether the CHANGE_TRACKING_VALUE option is enabled
Propriété publique ChangeTrackingRetentionPeriod Gets or sets the CHANGE_TRACKING_RETENTION_PERIOD value.
Propriété publique ChangeTrackingRetentionPeriodUnits Gets or sets the unit type for a retention period value.
Propriété publique CloseCursorsOnCommitEnabled Gets or sets a value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.
Propriété publique Collation Gets or sets the default collation used by the database.
Propriété publique CompatibilityLevel Gets or sets the compatibility level for the database.
Propriété publique ConcatenateNullYieldsNull Gets or sets a property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.
Propriété publique CreateDate Gets the date that the database was created.
Propriété publique DatabaseAuditSpecifications Represents a collection of DatabaseAuditSpecification objects. Each DatabaseAuditSpecification object represents an database audit specification defined on the server.
Propriété publique DatabaseEncryptionKey Gets a DataBaseEncryptionKey datatype.
Propriété publique DatabaseGuid Gets the Guid value that uniquely identifies the database.
Propriété publique DatabaseOptions Gets the DatabaseOptions object that contains configuration options for the database.
Propriété publique DatabaseOwnershipChaining Gets or sets a property value that specifies whether the database ownership chaining is active.
Propriété publique DatabaseSnapshotBaseName Gets the name of the snapshot base for the database.
Propriété publique DataSpaceUsage Gets the space used by the data in the database.
Propriété publique DateCorrelationOptimization Gets or sets a property value that specifies whether the date correlation optimization is active.
Propriété publique DboLogin Gets the Boolean value that specifies whether the current user is logged on as the database owner (DBO).
Propriété publique DefaultFileGroup Gets the default file group used by the database.
Propriété publique DefaultFileStreamFileGroup Gets a DefaultFileStreamFileGroup datatype
Propriété publique DefaultFullTextCatalog Gets the default full-text catalog used by the database.
Propriété publique Defaults Represents a collection of Default objects. Each Default object represents a default defined on the database.
Propriété publique DefaultSchema Gets the default schema of the user.
Propriété publique EncryptionEnabled Gets or sets the ENCRYPTIONENABLED property of a database.
Propriété publique Events Gets the events associated with the database.
Propriété protégée ExecuteForScalar Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Hérité de SqlSmoObject.)
Propriété publique ExtendedProperties Gets the extended properties of the database.
Propriété publique ExtendedStoredProcedures Represents a collection of ExtendedStoredProcedure objects. Each ExtendedStoredProcedure object represents an extended stored procedure defined on the database.
Propriété publique FileGroups Represents a collection of FileGroup objects. Each FileGroup object represents a filegroup defined on the database.
Propriété publique FullTextCatalogs Represents a collection of FullTextCatalog objects. Each FullTextCatalog object represents a full-text catalog defined on the database.
Propriété publique FullTextStopLists Represents a collection of FullTextStopList objects. Each FullTextStopList object represents a full text stop list defined on the server.
Propriété publique HonorBrokerPriority Gets or sets the Boolean value that specifies whether the priority specified by the broker is acknowledged or not.
Propriété publique ID Gets the database ID value that uniquely identifies the database.
Propriété publique IndexSpaceUsage Gets the space used by the indexes in the database.
Propriété publique IsAccessible Gets a Boolean property value that specifies whether the database can be accessed.
Propriété publique IsDatabaseSnapshot Gets a Boolean property value that specifies whether the database is a snapshot database.
Propriété publique IsDatabaseSnapshotBase Gets a Boolean property value that specifies whether the database is the base database for a snapshot database.
Propriété publique IsDbAccessAdmin Gets a Boolean property value that specifies whether the current user is a member of the DbAccessAdmin database role.
Propriété publique IsDbBackupOperator Gets a Boolean property value that specifies whether the current user is a member of the DbBackupOperator database role.
Propriété publique IsDbDatareader Gets a Boolean property value that specifies whether the current user is a member of the DbDatareader database role.
Propriété publique IsDbDatawriter Gets a Boolean property value that specifies whether the current user is a member of the DbDatawriter database role.
Propriété publique IsDbDdlAdmin Gets a Boolean property value that specifies whether the current user is a member of the DbDdlAdmin database role.
Propriété publique IsDbDenyDatareader Gets a Boolean property value that specifies whether the current user is a member of the DbDenyDatareader database role.
Propriété publique IsDbDenyDatawriter Gets a Boolean property value that specifies whether the current member is a member of the DbDenyDatawriter database.
Propriété publique IsDbOwner Gets a Boolean property value that specifies whether the current user is a member of the DbOwner database role.
Propriété publique IsDbSecurityAdmin Gets a Boolean property value that specifies whether the current user is a member of the DbSecurityAdmin database role.
Propriété publique IsFullTextEnabled Gets the Boolean value that specifies whether the database is enabled for full-text search.
Propriété publique IsMailHost Gets the Boolean value that specifies whether the database is configured as a mail host.
Propriété publique IsManagementDataWarehouse Gets the Boolean value that specifies whether the database is a management data warehouse.
Propriété publique IsMirroringEnabled Gets the Boolean value that specifies whether mirroring is enabled on the database.
Propriété publique IsParameterizationForced Gets or sets a property value that specifies whether parameterization is forced on the database.
Propriété publique IsReadCommittedSnapshotOn Gets the Boolean value that specifies whether transactions with the read committed isolation level use row versioning.
Propriété publique IsSystemObject Gets the Boolean value that specifies whether the database is a system object or a user-defined database.
Propriété protégée IsTouched Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Hérité de SqlSmoObject.)
Propriété publique IsUpdateable Gets the Boolean value that specifies whether the database can be updated.
Propriété publique IsVarDecimalStorageFormatEnabled Gets or sets a property value that specifies whether VarDecimal storage is enabled.
Propriété publique LastBackupDate Gets the date and time when the database was last backed up.
Propriété publique LastDifferentialBackupDate Gets the date and time when the last differential backup was performed.
Propriété publique LastLogBackupDate Gets the date and time when the transaction log was last backed up.
Propriété publique LocalCursorsDefault Gets the Boolean value that specifies whether the local server cursors are used by default.
Propriété publique LogFiles Represents a collection of LogFile objects. Each LogFile object represents a log file defined on the database.
Propriété publique LogReuseWaitStatus Gets the type of operation on which the reuse of transaction log space is waiting.
Propriété publique MasterKey Gets the master key that is used to encrypt the private keys of certificates.
Propriété publique MirroringFailoverLogSequenceNumber Gets the log sequence number at last failover.
Propriété publique MirroringID Gets the ID value that uniquely identifies the mirroring partnership.
Propriété publique MirroringPartner Gets or sets the address of the Moteur de base de données instance that is the partner server for database mirroring.
Propriété publique MirroringPartnerInstance Gets the instance of SQL Server on which the mirroring partner is configured.
Propriété publique MirroringRedoQueueMaxSize Gets or sets the maximum size of the redo queue of the mirror server instance in KB.
Propriété publique MirroringRoleSequence Gets the role sequence number for primary/backup roles played by the mirroring partners.
Propriété publique MirroringSafetyLevel Gets or sets the mirroring safety level.
Propriété publique MirroringSafetySequence Gets the role sequence number for safety levels for the mirroring partners.
Propriété publique MirroringStatus Gets the status of the database and the database mirroring session.
Propriété publique MirroringTimeout Gets or sets the maximum time, in seconds, that the principal server instance waits for a PING message from another instance in the mirroring session before assuming the other instance is disconnected.
Propriété publique MirroringWitness Gets or sets the name of the Moteur de base de données instance of the database mirroring witness server.
Propriété publique MirroringWitnessStatus Gets the status of the mirroring witness server.
Propriété publique Name Gets or sets the name of the object. (Hérité de NamedSmoObject.)
Propriété publique NumericRoundAbortEnabled Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active.
Propriété protégée ObjectInSpace Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Hérité de SqlSmoObject.)
Propriété publique Owner Gets the database principal that is the owner of the database.
Propriété publique PageVerify Specifies the type of page integrity check that SQL Server performs when reading database pages.
Propriété publique Parent Gets the Server object that is the parent of the Database object.
Propriété publique PartitionFunctions Represents a collection of PartitionFunction objects. Each PartitionFunction object represents a partition function defined on the database.
Propriété publique PartitionSchemes Represents a collection of PartitionScheme objects. Each PartitionScheme object represents a partition scheme defined on the database.
Propriété publique PlanGuides Gets Plan Guides associated with a database.
Propriété publique PrimaryFilePath Gets the path and name of the operating system directory that contains the primary file for the database.
Propriété publique Properties Gets a collection of Property objects that represent the object properties. (Hérité de SqlSmoObject.)
Propriété publique QuotedIdentifiersEnabled Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks (" ") are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.
Propriété publique ReadOnly Gets or sets the Boolean property value that specifies whether the database is read-only.
Propriété publique RecoveryForkGuid Gets the GUID value that specifies the recovery fork on which the database is currently active.
Propriété publique RecoveryModel Gets or sets the recovery model for the database.
Propriété publique RecursiveTriggersEnabled Gets or sets the Boolean value that specifies whether recursive triggers are enabled on the database.
Propriété publique ReplicationOptions Gets the active replication settings for a database,
Propriété publique Roles Represents a collection of DatabaseRole objects. Each DatabaseRole object represents a role defined on the database.
Propriété publique Rules Represents a collection of Rule objects. Each Rule object represents a rule defined on the database.
Propriété protégée ScalarResult Gets the scalar result for the referenced object. (Hérité de SqlSmoObject.)
Propriété publique Schemas Represents a collection of Schema objects. Each Schema object represents a schema defined on the database.
Propriété publique ServiceBroker Gets the ServiceBroker object that represents the Service Broker.
Propriété publique ServiceBrokerGuid Gets the Guid object that uniquely identifies the instance of Service Broker.
Propriété publique Size Gets the size of the database in MB.
Propriété publique SnapshotIsolationState Gets the snapshot isolation state for the database.
Propriété publique SpaceAvailable Gets the available space in the database in KB.
Propriété publique State Gets the state of the referenced object. (Hérité de SmoObjectBase.)
Propriété publique Status Gets the database status.
Propriété publique StoredProcedures Represents a collection of StoredProcedure objects. Each StoredProcedure object represents a stored procedure defined on the database.
Propriété publique SymmetricKeys Represents a collection of SymmetricKey objects. Each SymmetricKey object represents a symmetric key defined on the database.
Propriété publique Synonyms Represents a collection of Synonym objects. Each Synonym object represents a synonym defined on the database.
Propriété publique Tables Represents a collection of Table objects. Each Table object represents a table defined on the database.
Propriété publique Triggers Represents a collection of DatabaseDdlTrigger objects. Each DatabaseDdlTrigger object represents a trigger defined on the database.
Propriété publique Trustworthy The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server 2005 trusts the database and the contents within it
Propriété publique Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Hérité de SqlSmoObject.)
Propriété publique UserAccess Gets or sets the database user access.
Propriété publique UserData Gets or sets user-defined data associated with the referenced object. (Hérité de SmoObjectBase.)
Propriété publique UserDefinedAggregates Represents a collection of UserDefinedAggregate objects. Each UserDefinedAggregate object represents a user-defined aggregate defined on the database.
Propriété publique UserDefinedDataTypes Represents a collection of UserDefinedDataType objects. Each UserDefinedDataType object represents a user-defined data type on the database.
Propriété publique UserDefinedFunctions Represents a collection of UserDefinedFunction objects. Each UserDefinedFunction object represents a user-defined function on the database.
Propriété publique UserDefinedTableTypes Represents a collection of UserDefinedTableType objects. Each UserDefinedTableType object represents a user-defined table type on the database.
Propriété publique UserDefinedTypes Represents a collection of UserDefinedType objects. Each UserDefinedType object represents a user-defined type on the database.
Propriété publique UserName Gets or sets the database user name.
Propriété publique Users Represents a collection of User objects. Each User object represents a user who is defined on the database.
Propriété publique Version Gets the version of the instance of SQL Server that was used to create the database.
Propriété publique Views Represents a collection of View objects. Each View object represents a view defined on the database.
Propriété publique XmlSchemaCollections Represents a collection of XmlSchemaCollection objects. Each XmlSchemaCollection object represents an XML schema defined on the database.

Haut de la page

Événements

  Nom Description
Événement public PropertyChanged (Hérité de SqlSmoObject.)
Événement public PropertyMetadataChanged (Hérité de SqlSmoObject.)

Haut de la page

Implémentations d'interfaces explicites

  Nom Description
Implémentation d'interface expliciteMéthode privée IAlienObjectDiscover (Hérité de SqlSmoObject.)
Implémentation d'interface expliciteMéthode privée IAlienObjectGetParent (Hérité de SqlSmoObject.)
Implémentation d'interface expliciteMéthode privée IAlienObjectGetProperty (Hérité de SqlSmoObject.)
Implémentation d'interface expliciteMéthode privée ISfcPropertyProviderGetPropertySet (Hérité de SqlSmoObject.)
Implémentation d'interface expliciteMéthode privée IAlienObjectGetUrn (Hérité de SqlSmoObject.)
Implémentation d'interface expliciteMéthode privée IAlienObjectResolve (Hérité de SqlSmoObject.)
Implémentation d'interface expliciteMéthode privée IAlienObjectSetProperty (Hérité de SqlSmoObject.)

Haut de la page