Foreign Key Constraints
Foreign Key Constraints
- Subject: Foreign Key Constraints
- From: Dave Elsner <email@hidden>
- Date: Wed, 10 May 2006 13:45:51 +1000
Hi,
I'm generating Foreign Key Constraints from with in EO Modeler, but due to Oracles limitation of 30 character long identifiers most of my relationship constraints exceed this limit, so I need to shorten them. If I Edit the SQL generated from EO Modeler from:
ALTER TABLE FOO ADD CONSTRAINT FOO_SOME_REALLY_REALLY_LONG_NAME_FK FOREIGN KEY .........
To:
ALTER TABLE FOO ADD CONSTRAINT FOO_BAR_FK FOREIGN KEY .........
Will this affect how WO and the DB talk... My guess is No. That once the constraints are created in the DB WebObjects doesn't reefer to them ever again. But instead uses the EOModel rules. e.g. it executes the SQL and if it violates a model rule it give an error otherwise it sends the SQL to the DB and if it violates a DB constraint then an exception is returned from the DB and has nothing to do with the model. Right? So in other words I can rename my Foreign Key Constraints to anything I like and every thing will still work as per usual.
- Dave
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden