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 k
> 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
+-
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 is t
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 ignore
