Attribute

QualifyNormalizedNames (qnn)

Purpose

Determines whether the names of relational tables normalized from array columns are derived directly from the column name or prefixed with parent object names.

Valid Values

0 | 1 | 2

Behavior

If set to 0 (No), the relational table name is derived solely from the column name of the array.

If set to 1 (Table), the relational table name is prepended with the name of the immediate parent object. For example, if the immediate parent was Books and the array column was Chapters, then the relational table name would be BOOKS_CHAPTERS.

If set to 2 (FullPath), the relational table name is prepended with the names of all objects in which the array column is nested. For example, if the immediate parent was BOOKS with an array Chapters that contained an array Pages, then the resulting relational table name would be BOOKS_CHAPTERS_PAGES.

Notes

  • If a naming conflict occurs, the driver appends an underscore separator and integer (for example, _1) to the table name.

  • The value of this option also controls the name of the foreign key column in the child table. For example, if this option is set to Table, the foreign key column name would be _ID prepended with the parent object name. Therefore, a parent object of BOOKS would result in a foreign key column named BOOKS_ID in the child table.

Default Value

0 (No)