Database Object (SQL-DMO)

The Database object represents the properties of a single Microsoft® SQL Server™.

Remarks

Because it represents a SQL Server database, the Database object is a major component of the SQL-DMO object tree. The Database object contains collections that define the tables, stored procedures, data types, and users of a database. Methods of the Database object allow you to perform essential database maintenance functions, such as backup.

With the Database object, you can:

• Create a SQL Server database.
• Add database roles, rules, stored procedures, tables, user-defined data types, users, and views to an existing SQL Server database.
• Remove or drop database objects (tables, views, and so on) from an existing SQL Server database.
• Modify the disk resource used by the database for storage.
• Backup or restore an existing SQL Server database or its transaction log.
• Control SQL Server database security by adding users and granting, denying, or revoking access rights to the database.
• Check SQL Server database integrity.
• Check current usage in the database; specifically, check the status of locks applied against database resources.

The Name property of a Database object is a character string. Name must be a valid string for the SQL Server sysname data type.

To create a SQL Server database

1. Create a Database object.
2. Set the Name property of the Database object.
3. Create a DBFile object.
4. Set the Name property of the DBFile object.
5. Set the PhysicalName property of the DBFile object.
6. Set DBFile object properties optional for new database files, such as Size.
7. Add the DBFile object to the new Database object FileGroup object named PRIMARY.
8. Add the Database object to the Databases collection of a connected SQLServer object.

If you do not set the Size property of the DBFile object or specify a transaction log file, SQL Server defaults are used. For more information, see CREATE DATABASE.

You can specify a transaction log file during SQL Server database creation. Specify the log file prior to adding the Database object to the Databases collection.

To specify a log file

1. Create a LogFile object.
2. Set the Name property.
3. Set the PhysicalName property.
4. Set the LogFile Size property.
5. Add the LogFile object to the LogFiles collection of the TransactionLog object of the new Database object.

Methods

Properties