What is the definition of the constraint symbol there is no example of it in the docs ?
Also on a few tables i get errors trying to setup foreign keys
ALTER TABLE departments
ADD FOREIGN KEY (departmentID) REFERENCES departments_join(departmentID)
ON UPDATE CASCADE
this for example gives me
SHOW TABLE STATUS FROM yourdatabasename LIKE 'departments'
which will show us the constraints for table departments..-Martin-
Original Message -
From: Daniel Rossi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 5:50 PM
Subject: Constraint Symbol
What
SHOW TABLE STATUS FROM yourdatabasename LIKE 'departments'
which will show us the constraints for table departments..-Martin-
Apologies constraint was missing, this works
ALTER TABLE assets
ADD CONSTRAINT FOREIGN KEY (end_dateID) REFERENCES end_dates(end_dateID)
ON DELETE CASCADE
I worked out the problem, it worked if i emptied the table, what could that be all
about ?
Daniel Rossi [EMAIL PROTECTED] 09/05/03 10:50am
What is the definition of the constraint symbol there is no example of it in the docs ?
Also on a few tables i get errors trying to setup foreign keys
I see the above referenced throughout the documentation
in the context of foreign keys. What are the possible
choices for CONSTRAINT symbol. I've searched the
docs and have come up empty in this regard.
Chris
sql,query
At 7:58 -0600 10/29/02, Chris Boget wrote:
I see the above referenced throughout the documentation
in the context of foreign keys. What are the possible
choices for CONSTRAINT symbol. I've searched the
docs and have come up empty in this regard.
It doesn't much matter, given that it's ignored