Background documentationsql_recreateindex Locate this document in the navigation structure

 

Use this command to re-create the indexes of the database system.

Prerequisites

  • You have the server permission AccessSQL.

  • You have opened a database session (see: db_connect).

Structure

sql_recreateindex [<index_specification>]

<index_specification> :: = <schema>.<table>.<index>

Options

Option

Description

<index_specification>

Index specification

<schema>: schema

<table>: table name

<index>: index name or field name

If you do not specify that option, the system re-creates all indexes that are flagged as bad.

Result

OK

In the event of errors, see Reply Format.