I have my event table ( tbl_eventos
), where I'm going to fetch the contact_id field from the contacts table ( tbl_contactos
). To go create this link, I used the following:
ALTER TABLE 'tbl_eventos'
ADD CONSTRAINT 'tbl_eventos_ibfk_3' FOREIGN KEY ('id_contacto') REFERENCES 'tbl_contactos' ('id_contacto');
What happens now is that my contact table has changed its name, meaning it went from tbl_contactos
to tbl_contactos_cliente
. How can I make this change? The code above was generated by phpmyadmin.