Method 1: Database reconfiguration
With this method, the table is converted in:
- Indexes that must be changed or dropped are dropped.
- The table is converted by
issuing a single
SQL ALTER TABLE
command to the database. - Indexes that must be changed or created are created.