Options (Text Editor/XML/Formatting Page)


Applies To: SQL Server 2016

This dialog box allows you to specify the formatting settings for the XML Editor. You can access the Options dialog box from the Tools menu.

System_CAPS_ICON_note.jpg Note

These settings are available when you select the Text Editor folder, the XML folder, and then the Formatting option from the Options dialog box.

Preserve manual attribute formatting
Do not reformat attributes. This is the default.

System_CAPS_ICON_note.jpg Note

If the attributes are on multiple lines, the editor indents each line of attributes to match the indentation of the parent element.

Align attributes each on a separate line
Align the second and subsequent attributes vertically to match the indentation of the first attribute. The following XML text is an example of how the attributes would be aligned.

<item id = "123-A"  
      name = "hammer"  
      price = "9.95"  

On paste from clipboard.
Reformat XML text pasted from the clipboard.

On completion of end tag
Reformat the element when the end tag is completed.

Format mixed content by default.
Attempt to reformat mixed content, except when the content is found in an xml:space="preserve" scope. This is the default.

If an element contains a mix of text and markup, the contents are considered to be mixed content. Following is an example of an element with mixed content.

  <file readOnly="false">test1.txt</file>  
  <file readOnly="false">test2.txt</file>  


XML Editor (SQL Server Management Studio)

Community Additions