PROPERTY:

 

 

 

 

 

 

 

DESCRIPTION:

 

 

Indicates the current database schema name.

 

 

 

 

PROPERTY OF:

 

 

ADODatabase

 

 

 

 

DEFAULT VALUE:

 

 

Empty string

 

 

 

 

 

DESCRIPTION:

 

 

This property contains the name of current database schema (schema is analogous to the DBMS user).

 

The schema user that made the DBMS connection is assumed as the current.

 

 

 

During a user session to such a DBMS, one can switch database context, 

 

such as between the production database and the staging database, or the admin database. 

 

Each of these databases can have identical or completely different user tables. 

 

For example, two users: "scott" and "mary" can each have a table "foo", that can be completely different.

 

In these cases the full SQL would be like: "Select * from PRODUCTION.MARY.FOO" or "Select * from SALES.SCOTT.FOO"