Database Methods
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms219496.pubmethod(en-US,SQL.90).gif") |
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.
|
.gif "ms219496.static(en-US,SQL.90).gif") |
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.
|
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms219496.protmethod(en-US,SQL.90).gif") |
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 ) |
See Also
Reference
Database Class
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
How to: Create, Alter, and Remove a Database in Visual Basic .NET
Creating, Altering, and Removing Databases
CREATE DATABASE (Transact-SQL)