Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions page (login required).

DefaultSchema

Default SQL schema name.

Synopsis

[SQL]    DefaultSchema=n

Description

The value n is a string defining the default SQL schema name. The maximum length of the string is 128 characters. The default string is:

SQLUser
Copy code to clipboard

The default schema name comes into play when an unqualified table name is encountered in an SQL statement and there is no #import statement specified. This setting has nothing to do with the mappings between SQL schema names and the class package name; it only specifies the default schema name.

If you specify _CURRENT_USER as the default schema name, the default schema name becomes the username of the currently logged-in process or, if the process has not logged in, SQLUser becomes the default schema name.

If you specify _CURRENT_USER/name as the default schema name, where name is any string of your choice, then the default schema name becomes the username of the currently logged-in process or, if the process has not logged in, name is used as the default schema name. For example, _CURRENT_USER/HMO uses HMO as the default schema name if the process has not logged in.

Examples

DefaultSchema=SQLUser

Range of Values

As described above.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Default SQL Schema Name setting, enter a string of characters.

Feedback