| Subject | Re: Rename a foreign key |
|---|---|
| Author | |
| Post date | 2017-11-16T10:39:17Z |
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.