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

No | Table | FullPath

Behavior

If set to No, the relational table name is derived solely from the column name of the array, object, or subdocument.

If set to 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 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 property also controls the name of the foreign key column in the child table. For example, if this property 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.

Data Source Methods

public String getQualifyNormalizedNames()

public void setQualifyNormalizedNames(String)

Default Value

Table

Data Type

String