Database Class
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
public sealed class Database : ScriptNameObjectBase, ICreatable, IAlterable, IDroppable, IRenamable, IExtendedProperties, IScriptable
public final class Database extends ScriptNameObjectBase implements ICreatable, IAlterable, IDroppable, IRenamable, IExtendedProperties, IScriptable
public final class Database extends ScriptNameObjectBase implements ICreatable, IAlterable, IDroppable, IRenamable, IExtendedProperties, IScriptable
Updated text: 17 July 2006
Updated text: 14 April 2006
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
The Database class represents databases, either system or user-defined, on the instance of SQL Server. The Server class is the parent of the Database class.
By using the Database class, you can do the following:
-
Create a new database or drop and existing database.
-
Register the database in the Active Directory directory service.
-
Reference database objects in collections, such as tables, users, and triggers.
-
Set up database mirroring.
-
Create a master database key.
-
Set up a full-text search catalog.
-
Check data, allocations, catalogs, and tables.
-
Issue a checkpoint.
-
Grant, revoke, and deny permissions to users on the database.
-
Run Transact-SQL statements.
-
Enumerate database information, such as locks or object permissions.
-
Remove the backup history.
-
Monitor the number of transactions.
-
Set the database offline or online.
-
Change the owner of the database.
-
Update statistics.
-
Shrink the database.
-
Truncate the log.
-
Script the database.
To get Database object properties, users can be a member of the public fixed server role.
To set Database object properties and run the Alter method, users must have ALTER permission on the database, or be a member of the db_owner fixed database role.
To create a database, users must have CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permission on the parent server.
To drop a database, users must have CONTROL permission on the database, or be a member of the db_owner fixed database role.
To grant, revoke, or deny other users permission on the database, users must have CONTROL permission on the database or be a member of the db_owner fixed database role.
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server 'Define a Database object variable by supplying the server and the database name arguments in the constructor. Dim db As Database db = New Database(srv, "Test_SMO_Database") 'Create the database on the instance of SQL Server. db.Create() 'Reference the database and display the date when it was created. db = srv.Databases("Test_SMO_Database") Console.WriteLine(db.CreateDate) 'Remove the database. db.Drop()
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.Target Platforms
|
Release |
History |
|
17 July 2006 |
Changed content:
|
|
Release |
History |
|
14 April 2006 |
Changed content:
|
