Subject | Creating foreign keys |
---|---|
Author | marcel_nic |
Post date | 2004-07-15T07:48:46Z |
Hi all,
I'm trying to create a foreign key between 2 tables while 2 or more
connections to the database are active and I get an error like this
This operation is not defined for system tables.
unsuccessful metadata update.
object REFERENCED_TABLE is in use
Is this a normal behaviour (while any other changes are alowed - i.e.
add or delete fields, delete FK-s)
Thanks, Marcel
I'm trying to create a foreign key between 2 tables while 2 or more
connections to the database are active and I get an error like this
This operation is not defined for system tables.
unsuccessful metadata update.
object REFERENCED_TABLE is in use
Is this a normal behaviour (while any other changes are alowed - i.e.
add or delete fields, delete FK-s)
Thanks, Marcel