Self References & Indexes

[m i l e s]

Hi,

Can anyone tell me if this is the correct syntax for a self reference  
& Index ?

-->  ALTER TABLE `RPI_CTYPE` ADD FOREIGN KEY (`RPI_CT_REPLCID`)  
REFERENCES `RPI_CTYPE`(`RPI_CT_ID`);
-->  CREATE INDEX RPI_H_REPLCID_idxfk ON RPI_HOW (RPI_H_REPLCID);

M i l e s.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]