Generating check constraint
413895Jul 24 2006 — edited Jul 25 2006Hi I've got a problem and was wondering if anyone could shed some light on the problem.
Recently we started using designer 10g. When I generate a table using "generate database from server model" all the columns which are defined by a domain and have a check constraint, due to the specified values in the domain, are no longer part of the create statement of the table. Designer seems to put them in the constraint file as part of an alter table along with a weird name.
Is it possible, as in designer 2000, to make the check constraint part of the create statement in 10g and making it a sys constraint ? And how ?
I've been looking around but can't seem to find the solution (or the problem causing it).
Thnx for any help on the subject.