This tutorial shows how to use SQLXP's Object viewer to Add and Remove Index.

1. View an existing table.
2. Click on the Index tab.

To Add:
1. Click the Table menu or right click on the grid, and click Add Index .
2. Enter the name of the Index add click ok.
3. Select the column(s) that will make up your Index.

To Remove:
1. Select a Index from the grid.
2. Click the Table menu or right click on the grid, and click Remove Index .

© 2002 Netlegger Systems. All rights reserved.