How to create an XML Table Index for SQL Server in erwin Data Modeler?
XML table indexes can only be created on a table that has one or more columns of datatype XML. For more information, please see: https://erwin.com/bookshelf/public_html/2020R2/Content/User%20Guides/erwin%20Help/Define_SQL_Server_Table_XML_Indexes.html
Steps:
Please follow the below steps to create an XML Index for SQL Server...
1. Right-click a table and select XML index Properties
2- Confirm the correct table is selected from table drop-down
3- Click the new icon to create index...
4- Define any properties needed for the index
5- Click Close to create the index
Comments
0 comments
Please sign in to leave a comment.