database
The Database object to which the query, stored procedure or table definition is assigned.
Property of
Query, StoredProc, TableDef
Description
A query or stored procedure must be assigned to the database that provides access to the tables it wants before it is activated. When created, a Query or StoredProc object is assigned to the default database in the default session.
To assign the object to the default database in another session, assign that session to the session property. Assigning the session property always sets the database property to the default database in that session.
To assign the object to another database in another session, assign the object to that session first. This makes the databases in that session available to the object.