default_schema attribute - Aster Database

Teradata AsterĀ® Database 6.20 Release Notes

Product
Aster Database
Release Number
6.20.08
Published
November 2019
Language
English (United States)
Last Update
2019-11-12
dita:mapPath
vux1500568440584.ditamap
dita:ditavalPath
External-only.ditaval
dita:id
vux1500568440584
lifecycle
previous
Product Category
Software

The current AD 6.20-based syntax related to the default_schema attribute is as follows.

SHOW

SHOW default_schema;

Shows the current default schema which is searched when an object (table, view, and so on) is referenced by a name with no schema component.

ALTER USER

ALTER USER username SET default_schema { TO | = } schemaname;

This sets the default schema of the user. When the user subsequently starts a new session, the specified schema is used as its default.

SET

SET [ LOCAL | TRANSACTION | SESSION ] default_schema { TO | = } schemaname;

This specifies the default schema to search when an object (table, view, and so on) is referenced by a name with no schema component. Pass the session qualifier to limit the use of the default schema to the current session. Pass the local or transaction qualifier to limit the use of the default schema to the current transaction. If no qualifier is passed, the default_schema applies to the current transaction.