Re: How to name inline constraints using Designer 2000

John Elliott wrote:
>
> Using Designer 2000 (v1.2a) ER diagrammer you can specify a list of allowable
> values for a given attribute in an entity. After you have your ER model just
> the way you want it you can use the database design wizard to generate the
> table candidates. The allowable values specified for an attribute carry down
> to the columns in these tables.
>
> This is fine, however when using the Generate SQL DDL utility these allowable
> values get turned into unnamed inline constraints. Running the generated DDL
> results in a bunch of SYS_Cnnnnnn named constraints. How can I get Designer
> 2000 to name these constraints? If this is not possible, what are the
> workarounds?
>
> Your help is very much appreciated,
>
> John Elliott
> elliotjs_at_dmdcwest.fmp.osd.mil
John,

I don't think there are constraint-prefix/naming preferences. What you might need to do is write a pl/sql script using the API - doing bulk updates on the meta-objects. Thought i haven't done this very thing, i am very positive this can be done. Let me know if you are interested in knowing more.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.