Database Methods
SQL Server 2005
(see also
Protected
Methods
)
| Name | Description | |
|---|---|---|
| Alter |
Overloaded.
Updates any Database object property changes on an instance of Microsoft SQL Server.
|
|
| ChangeMirroringState |
Changes the mirroring configuration as specified by the options.
|
|
| CheckAllocations |
Scans all pages of the referenced database and tests pages to guarantee integrity.
|
|
| CheckAllocationsDataOnly |
Scans all pages of the referenced database and tests only the data to guarantee integrity.
|
|
| CheckCatalog |
Tests the integrity of the database catalog.
|
|
| CheckIdentityValues |
Verifies the integrity of all identity columns in tables in the database.
|
|
| Checkpoint |
Issues a checkpoint.
|
|
| CheckTables |
Tests the integrity of database pages for all tables and indexes defined on the tables of the database.
|
|
| CheckTablesDataOnly |
Tests integrity of pages that store data for all tables and indexes defined on the tables of the referenced database.
|
|
| Create |
Overloaded.
Creates a database on the instance of Microsoft SQL Server as defined by the Database object.
|
|
| Deny |
Overloaded.
Denies the specified set of permissions for the specified grantees on the database.
|
|
| Drop |
Drops the database.
|
|
| DropBackupHistory |
Drops the backup history for the database.
|
|
| EnumCandidateKeys |
Enumerates a list of all candidate primary keys in the database, which may be referenced by a foreign key.
|
|
| EnumDatabasePermissions |
Overloaded.
Enumerates a list of all database permissions in the database.
|
|
| EnumLocks |
Overloaded.
Enumerates a list of current locks on the database.
|
|
| EnumLoginMappings |
Enumerates a list of Microsoft SQL Server logins for all the users in the database.
|
|
| EnumMatchingSPs |
Overloaded.
Enumerates a list of stored procedures that contain the specified string in the definition.
|
|
| EnumObjectPermissions |
Overloaded.
Enumerates a list of permissions for objects in the database.
|
|
| EnumObjects |
Overloaded.
Enumerates a list of objects in the database.
|
|
| EnumTransactions |
Overloaded.
Enumerates a list of open transactions on the database.
|
|
| EnumWindowsGroups |
Overloaded.
Enumerates a list of Microsoft Windows groups.
|
|
| Equals | Overloaded. (inherited from Object ) |
|
| ExecuteNonQuery |
Overloaded.
Executes a collection of batches in the context of the database where there are no results returned.
|
|
| ExecuteWithResults |
Overloaded.
Executes a collection of batches in the context of the database where there are results returned.
|
|
| GetHashCode | (inherited from Object ) |
|
| GetTransactionCount |
Overloaded.
Gets the number of open transactions on the database.
|
|
| GetType | (inherited from Object ) |
|
| Grant |
Overloaded.
Grants the specified set of permissions to the specified grantees on the database.
|
|
| Initialize |
Overloaded.
Initializes the object and forces the properties be loaded.
(inherited from
SqlSmoObject
)
|
|
| IsMember |
Determines whether the specified group or role belongs to the database.
|
|
| PrefetchObjects |
Overloaded.
Prefetches database objects.
|
|
| RecalculateSpaceUsage |
Recalculates space usage.
|
|
| ReferenceEquals | (inherited from Object ) |
|
| Refresh |
Overridden.
Updates the Database object.
|
|
| RemoveFullTextCatalogs |
Removes full-text catalogs from the database.
|
|
| Rename |
Renames the database.
|
|
| Revoke |
Overloaded.
Revokes a previously granted set of permissions from a grantee or grantees on the database.
|
|
| Script |
Overloaded.
Generates a Transact-SQL script that can be used to re-create the database.
|
|
| SetDefaultFileGroup |
Sets the default file group for the database.
|
|
| SetDefaultFullTextCatalog |
Sets the default full-text catalog for the database.
|
|
| SetOffline |
Sets the database offline.
|
|
| SetOnline |
Sets the database online.
|
|
| SetOwner |
Overloaded.
Sets the database owner.
|
|
| Shrink |
Shrinks the database.
|
|
| ToString |
Returns a String that represents the referenced object.
(inherited from
SqlSmoObject
)
|
|
| TruncateLog |
Truncates the database log.
|
|
| UpdateIndexStatistics |
Updates index statistics.
|
| Name | Description | |
|---|---|---|
|
| AlterImpl | (inherited from SqlSmoObject ) |
|
| AlterImplFinish | (inherited from SqlSmoObject ) |
|
| AlterImplInit | (inherited from SqlSmoObject ) |
|
| AlterImplWorker | (inherited from SqlSmoObject ) |
|
| AppendCommaText | (inherited from ScriptNameObjectBase ) |
|
| AppendWithCommaText | (inherited from ScriptNameObjectBase ) |
|
| AppendWithOption | (inherited from ScriptNameObjectBase ) |
|
| BindDefaultImpl | (inherited from SqlSmoObject ) |
|
| BindRuleImpl | (inherited from SqlSmoObject ) |
|
| CheckCollation | (inherited from SqlSmoObject ) |
|
| CheckObjectState |
Overloaded.
Validates the state of the referenced object.
(inherited from
SqlSmoObject
)
|
|
| CheckObjectStateImpl | (inherited from SqlSmoObject ) |
|
| CheckTextCorectness | (inherited from ScriptNameObjectBase ) |
|
| CheckTextModeSupport | (inherited from ScriptNameObjectBase ) |
|
| CheckVersion80 |
Checks the validity of the object on Microsoft SQL Server 2000.
(inherited from
SqlSmoObject
)
|
|
| CheckVersion80SP3 |
Checks the validity of the object on Microsoft SQL Server 2000 SP3.
(inherited from
SqlSmoObject
)
|
|
| CheckVersion90 |
Check the validity of the object on Microsoft SQL Server 2005.
(inherited from
SqlSmoObject
)
|
|
| CheckVersionBelow90 | (inherited from SqlSmoObject ) |
|
| CleanObject |
Cleans the referenced object.
(inherited from
ScriptNameObjectBase
)
|
|
| CreateImpl | (inherited from SqlSmoObject ) |
|
| CreateImplFinish | (inherited from SqlSmoObject ) |
|
| CreateImplInit | (inherited from SqlSmoObject ) |
|
| DropImpl | (inherited from SqlSmoObject ) |
|
| DropImplWorker | (inherited from SqlSmoObject ) |
|
| Finalize | (inherited from Object ) |
|
| ForceTextModeOnTextBody |
Enforces text mode on the text body.
(inherited from
ScriptNameObjectBase
)
|
|
| FormatSqlVariant | (inherited from SqlSmoObject ) |
|
| GenerateDataSpaceScript | (inherited from SqlSmoObject ) |
|
| GetBindDefaultScript | (inherited from SqlSmoObject ) |
|
| GetBindRuleScript | (inherited from SqlSmoObject ) |
|
| GetBoolParameter | Overloaded. (inherited from SqlSmoObject ) |
|
| GetBraketNameForText | (inherited from ScriptNameObjectBase ) |
|
| GetDateTimeParameter | (inherited from SqlSmoObject ) |
|
| GetDateTimeParameterAsInt | (inherited from SqlSmoObject ) |
|
| GetDBName |
Gets the database name associated with the object.
(inherited from
SqlSmoObject
)
|
|
| GetEnumParameter | (inherited from SqlSmoObject ) |
|
| GetFragOptionString | (inherited from SqlSmoObject ) |
|
| GetGuidParameter | (inherited from SqlSmoObject ) |
|
| GetIsTextDirty |
Determines whether the text value is consistent with stored value.
(inherited from
ScriptNameObjectBase
)
|
|
| GetParameter | Overloaded. (inherited from SqlSmoObject ) |
|
| GetPropValue | (inherited from SqlSmoObject ) |
|
| GetPropValueOptional | (inherited from SqlSmoObject ) |
|
| GetPropValueOptionalAllowNull | (inherited from SqlSmoObject ) |
|
| GetRealValue | (inherited from SqlSmoObject ) |
|
| GetScriptIncludeExists | (inherited from ScriptNameObjectBase ) |
|
| GetScriptingOptionsForCreate | (inherited from SqlSmoObject ) |
|
| GetServerName |
Gets the name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from
SqlSmoObject
)
|
|
| GetSqlServerVersionName |
Gets the version name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from
SqlSmoObject
)
|
|
| GetStringParameter | Overloaded. (inherited from SqlSmoObject ) |
|
| GetTextBody |
Overloaded.
Returns the text body.
(inherited from
ScriptNameObjectBase
)
|
|
| GetTextForScript | (inherited from ScriptNameObjectBase ) |
|
| GetTextHeader | (inherited from ScriptNameObjectBase ) |
|
| GetTextMode |
Determines whether the script name is using text mode.
(inherited from
ScriptNameObjectBase
)
|
|
| GetTextProperty | (inherited from ScriptNameObjectBase ) |
|
| GetTimeSpanParameterAsInt | (inherited from SqlSmoObject ) |
|
| GetUrnRecursive | Overloaded. (inherited from SqlSmoObject ) |
|
| ImplInitialize | (inherited from SqlSmoObject ) |
|
| IsCollectionDirty | (inherited from SqlSmoObject ) |
|
| IsObjectDirty |
Determines whether the referenced object is consistent with the stored object.
(inherited from
ScriptNameObjectBase
)
|
|
| IsObjectInitialized |
Verifies whether the object has been initialized.
(inherited from
SqlSmoObject
)
|
|
| IsObjectInSpace |
Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server.
(inherited from
SqlSmoObject
)
|
|
| IsVersion80SP3 | (inherited from SqlSmoObject ) |
|
| MarkDropped |
This method supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
(inherited from
SqlSmoObject
)
|
|
| MarkForDropImpl | (inherited from SqlSmoObject ) |
|
| MemberwiseClone | (inherited from Object ) |
|
| PostAlter | (inherited from SqlSmoObject ) |
|
| PostCreate |
This method supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
(inherited from
SqlSmoObject
)
|
|
| PostDrop | (inherited from SqlSmoObject ) |
|
| RenameImpl | (inherited from NamedSmoObject ) |
|
| RenameImplWorker | (inherited from NamedSmoObject ) |
|
| ScriptAlter |
This method supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
(inherited from
SqlSmoObject
)
|
|
| ScriptAnsiQI | (inherited from ScriptNameObjectBase ) |
|
| ScriptChangeOwner | (inherited from NamedSmoObject ) |
|
| ScriptCreate | (inherited from SqlSmoObject ) |
|
| ScriptDdl | (inherited from SqlSmoObject ) |
|
| ScriptDrop | (inherited from SqlSmoObject ) |
|
| ScriptImpl | Overloaded. (inherited from SqlSmoObject ) |
|
| ScriptImplWorker | (inherited from SqlSmoObject ) |
|
| ScriptInformativeHeaders | (inherited from ScriptNameObjectBase ) |
|
| ScriptRename | (inherited from NamedSmoObject ) |
|
| SetCollectionTextMode | (inherited from ScriptNameObjectBase ) |
|
| SetParentImpl | (inherited from SqlSmoObject ) |
|
| SetTextBody | (inherited from ScriptNameObjectBase ) |
|
| SetTextHeader | (inherited from ScriptNameObjectBase ) |
|
| SetTextMode | (inherited from ScriptNameObjectBase ) |
|
| SwitchTextMode | (inherited from ScriptNameObjectBase ) |
|
| ThrowIfTextIsDirtyForAlter | (inherited from ScriptNameObjectBase ) |
|
| Trace | (inherited from SqlSmoObject ) |
|
| UnbindDefaultImpl | (inherited from SqlSmoObject ) |
|
| UnbindRuleImpl | (inherited from SqlSmoObject ) |
|
| UpdateCollectionState2 | (inherited from SqlSmoObject ) |
