Attribute

QualifyNormalizedNames (qnn)

Purpose

Determines whether the names of relational child-tables normalized from arrays, objects, and subdocuments are prefixed with the collection name and any parent objects.

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, object, or subdocument.

If set to 1 (Table), the relational table name is prepended with the name of the collection. For example, if the name of the collection was named Books and the array column was named 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, object, or subdocument is nested. For example, if the collection 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

1 (Table)