Specifies how column names are qualified to ensure uniqueness in the generated schema.

Syntax

Connect-XML -QualifyColumns string

Possible Values

Data Type

cstr

Default Value

"None"

Remarks

By default the cmdlet qualifies column names only as much as necessary to make them unique. For example, given the following XML document, the cmdlet produces the 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 this option is set to Parent, the cmdlet uses a similar procedure to the one above. However, the cmdlet will always qualify 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 this option is set to Full, the cmdlet will qualify 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 the example above, the cmdlet generates the columns company.id and company.employees.employee.id.