Chapter 15 DBMS-Specific Features

XML indexes

PowerDesigner models XML indexes as table indexes with an index type set to "XML".

Creating an XML index

Steps To create an XML index:

  1. Create an index by opening the property sheet of a table, clicking the Indexes tab and clicking the Add a Row tool.
  2. Open the property sheet of the new index by clicking the properties tool, and then select XML from the list of Types on the General tab.
  3. Click the Microsoft tab and specify any additional options.
  4. Click OK to confirm your changes and close the property sheet.

XML index properties

You can modify an object's properties from its property sheet. To open an XML index property sheet, double-click its Browser entry.

The following extended attributes are available on the Microsoft tab:

Name Description
Primary Specifies that this is the primary xml index.

Scripting name: XMLPrimary
Primary index Specifies the primary XML index to use in creating a secondary XML index.

Scripting name: PrimaryXMLIndex
Secondary XML index type Specifies the type of the secondary XML index.

Scripting name: SecondaryXMLIndexType

 

Copyright (C) 2007. Sybase Inc. All rights reserved.