createindex

Description

Creates an index on a table.

Attributes

Attribute Description Required
configKeywordKeyword indicating alternate default configurations. The keyword is found in the dbtune.sde file. No

Nested Elements

<indexdef>

Attribute Description Required
columnlistColumn names Yes
uniqueSets the index unique characterstic. No. Defaults to false
nameIndex name. A placeholder @{tablename} can be used, to embed the corresponding table name. Yes

Examples

  <sde:sdeconnection id="sde.conn" 
      host="127.0.0.1" password="pass" username="myuser"/>
      
  <sde:createindex connection="sde.conn"
       tablename="SE_TABLE1">
       <indexdef columnlist="fips" unique="false" 
           name="@{tablename}_FIPS"/>
  </sde:createindex>