16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

User, Database, or Profile DEFAULT MAP OVERRIDE ON ERROR Option

If the map you specify does not exist, has not been granted to you, is not in the same secure zone, or the map is otherwise unavailable to you, a message indicates that the default map is being used instead of the map you specified. This is the default behavior if DEFAULT MAP OVERRIDE ON ERROR option is not specified for the user, database or profile. An error occurs only if DEFAULT MAP OVERRIDE NOT ON ERROR option is specified for the user, database, or profile.

Default Map for a CREATE TABLE (Queue Table Form) Statement

If you do not specify the MAP option when creating a queue table, the system determines a default map for the table in following order of precedence:
  • If the immediate owner is not the creator:
    • Default map, if defined, for the profile of the immediate owner.
    • Default map, if defined, for the immediate owner.
    • System-default map.
  • Default map, if defined, for the profile of the creator.
  • Default map, if defined, for the creator.
  • System-default map.