Specifies whether the provider will use relative column names.

Possible Values

Data Type

string

Default Value

"none"

Remarks

By default (QualifyColumns = none), the add-in only qualifies a column name as much as is necessary to make it unique. For example, in the following document the add-in will produces two columns: id (referring to the company id) and employee.id.

<company>
  <id>Smith Holdings</id>
  <employees>
    <employee>
      <id>George Smith</id>
    </employee>
    <employee>
      <id>Mike Johnson</id>
    </employee>
  </employees>
</company>

When QualifyColumns = parent, the add-in uses a similar procedure to the one above. However, the add-in always qualifies columns by one level so that their table name is included, even if the column name is unique. For example, the above document would generate the columns company.id and employee.id ,because both are unique when including their parent.

When QualifyColumns = full, the add-in qualifies all column names with their full XPath. This generates longer column names, but ensures that it is clear where each column name comes from within the document. For example, the above document would generate the columns company.id and company.employees.employee.id.