Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to use domain rules NOT check constraints in PD?

6 views
Skip to first unread message

Damon Rand

unread,
Aug 11, 2003, 8:21:34 AM8/11/03
to
Hello all,

I am having some trouble with powerdesigner 8 and Sybase 12.5. Our
database makes extensive use of columns with domain types but does not
contain any direct check constraints on these columns. When I reverse
engineer the database into a PDM and then try to generate a SQL script
with 'Modify database' the output SQL correctly sets the columns to
our custom types. However, it also adds the domain rules in to the
column as check constraints!! This is preventing us from being able to
use the tool to modify our database.

The 'Generate database' option allows me to deselect check
constraints.. Is there no way to disable check constraint generation
in 'Modify database'?

Regards,
Damon.

0 new messages