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

No | Table | FullPath

Behavior

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

If set to 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 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 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

No

Data Type

String