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

1. View an existing table.
2. Click on the Foreign Keys tab.

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

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

© 2002 Netlegger Systems. All rights reserved.