Re: Foreign Key Constraints
Re: Foreign Key Constraints
- Subject: Re: Foreign Key Constraints
- From: Dave Elsner <email@hidden>
- Date: Wed, 10 May 2006 14:25:39 +1000
Thanks for the clarification.
On 10/05/2006, at 1:53 PM, Chuck Hill wrote:
On May 9, 2006, at 8:45 PM, Dave Elsner wrote:
Hi,
I'm generating Foreign Key Constraints from with in EO Modeler, but due to Oracles limitation of 30 character long identifiers
That is so 1972. :-P
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.
Yes, you can rename them as long as you are not using schema synchronization. I am not sure how this would affect schema synchronization.
Chuck
--
|
_______________________________________________
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