From: news-uk@dircon.co.uk.nojunk (Phil Edwards) Subject: Re: PeopleSoft and Referential Integrity Date: 1997/08/08 Message-ID: <33eaf636.9821449@news.dircon.co.uk>#1/1 References: <5rsrhq$1gv@camel1.mindspring.com> <5sdutv$80u@camel2.mindspring.com> Organization: Duke Communications Europe Newsgroups: comp.databases,comp.databases.oracle.misc On Fri, 08 Aug 1997 01:58:42 GMT, twincrk@ral.mindspring.com (S. Fleming) wrote: >To be perfectly honest, I am a PeopleSoft developer with somewhat >limited Oracle skills so I really don't know what you are asking. >However, when you generate a SQL script from the Data Designer you get >something like the one shown below. The only parameters that >PeopleSoft lets you change in the Data Designer are the init and next >sizes and the tablespace name. Those changes are saved and >automatically placed in the script when the script is generated again. < script snipt > The answer is: PeopleSoft's generated DDL doesn't use declarative RI (the script used CREATE UNIQUE INDEX rather than a CONSTRAINT clause) and you can't change it to make it do so. Phil -- Phil Edwards phil@news400.com Editor, NEWS/400.uk +44 (0)161 929 0777