Use the Column Definition page of the New XML Table Function wizard
to specify the column name, the data type, and the relative path to the column
element within the XML document. The specified column name and data type correspond
to the table format that is returned from the UDF.
- Specify the path
- Specifies that you will type in the path.
- Import path from XML document
- Specifies that the path will be imported from an existing XML document.
- Filename
- Specify an existing file.
- Import path and column definitions from a file
- Specifies that the paths and column definitions will be read in from an
existing file that was saved from a prior execution of the wizard.
- Filename
- Specify an existing file.
- Absolute path to table element
- Type in the absolute path to the table element. The path is from the root
of the document up to the table element, for example, BookstoreDocument/Books/.
The path cannot be longer than 32,672 characters.
- Relative path to row element
- Type in the path to the row elements relative to the table element. For
example, /LiteratureBooks where the table path is BookstoreDocument/Books/.