Database Properties

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.