Use "ALTER TABLE ... DROP CONSTRAINT ..." and then "ALTER TABLE ... ADD
CONSTRAINT ... FOREIGN KEY ..."
Thats no fast if the table is huge. This method I know.
Where you see such FK name as "RDB$FOREIGN60"? It created by you or some DB
management tool? As I know, there is no automatically generated ("system")
FK's. So, you must create them manually and assign meaningful name to it.
Correct. It comes from when the database was created back in 1999/2000.
At the time I didn't realize, taht I could change the names.
So it has just been like this.
