You can use the Table Data Editor to display and edit database tables that contain XML data types. The Table Data Editor provides a special XML Editor for this type of data.
- Select a table in your database that contains the XML data type.XML data type objects are stored as single objects in separate rows within the table.
- Right-click the table and select .You can open several tables in the editor in this way and move between them by clicking the tabs at the top of the editor.
- Review the table.Any XML data displays in the XML column of the table and is visible in the Table Data Editor.
- Locate the object you want to edit and select the row for that object.An XML data type object is represented by the handle to the stored XML data.
- Click
to open the XML Editor. - Review and edit the data displayed in the editor.
If the data in the object is imported, the source file for that data displays in the File field.
You can edit directly in the editor or you can export the XML data to a text file to review and edit the data, and then import that data back to the XML Editor.
The Encoding field shows the encoding standard used for the data in the editor workarea. Use the drop-down menu to select a different standard.
- Click OK to save your changes.