Database Object Properties Methods Lists Collections
Property | Description |
---|
Application Application Write: No |
The Application object. |
CreateDate String Write: No |
The date and time this database was created. |
CreateForLoad Boolean Write: Before Add |
Determines if this database was created with the FOR LOAD option. |
DataSpaceUsage Float Write: No |
The space in megabytes (accurate to two decimal places) used to store data. |
DboLogin Boolean Write: No |
Indicates if the login used for the connection (contained in the SQLServer object) has DBO privilege in this database. |
DBOption DBOption Write: No |
The DBOption object for this database. |
IndexSpaceUsage Float Write: No |
The space in megabytes (accurate to two decimal places) used to store indexes. |
ID Long Write: No |
The database ID. |
MinimumSize Long Write: No |
The minimum size this database can be shrunk to. |
Name Identifier Write: Yes |
The name of this database. |
Owner Identifier Write: No |
The login of the database owner. |
Parent SQLServer Write: No |
The SQLServer object. |
Size Long Write: No |
The total storage space in megabytes allocated for this database. This includes both used and available space. |
SpaceAvailable Long Write: No |
The unused storage space in kilobytes available for new data. |
SpaceAvailableInMB Float Write: No |
The unused storage space in megabytes (accurate to two decimal places) available for new data. |
Status SQLOLE_DBSTATUS_TYPE Write: No |
The status of this database. |
SystemObject Boolean Write: No |
Indicates if this is a SQL Server system database. If True, this is a SQL Server system database. If False, this database was created by a user. |
TransactionLog TransactionLog Write: No |
The TransactionLog object for this database. |
TypeOf SQLOLE_OBJECT_TYPE Write: No |
The type of object. |
UserData Long Write: Yes |
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property. |
UserName Identifier Write: Yes |
Name of the current database user. The SA or DBO can change this property to that of existing user in this database, thus impersonating that other user. |
UserProfile SQLOLE_DBUSERPROFILE_TYPE Write: No |
The database profile information for the currently connected user. |
Version Long Write: No |
The version of the database from sysdatabases. |