Hi,

I need to create a script to convert my database. To convert my database I need to drop a foreign key. To drop it, I use the command:

ALTER TABLE my_table DROP CONSTRAINT my_foreign_key

There is only one problem. I don't know the name of my foreign key, because the name of this key is generated by creation. How can I get the name of my foreign key? I have the parent and the child alias.

Tia,

Sander Bouwmeester