Quest Toad Data Modeler Community : Check Constraints missing in DDL script ...

Forums » Join Discussions About... » Toad Data Modeler

Thread: Check Constraints missing in DDL script

This question is not answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 1 - Pages: 1 - Last Post: Nov 3, 2009 2:29 AM by: vladka

AndreasL

Posts: 49
Registered: 2/25/09

Check Constraints missing in DDL script
Posted: Oct 30, 2009 2:10 AM

I have an Oracle9 PDM with check constraints on some attributes. In the generated DDL script, the check constraint is missing:
WSR_SYNC_STATUS Varchar2(20 ) NOT NULL
CONSTRAINT WSR_SYNC_STATUS_CHECK CHECK (AsText),
instead of
WSR_SYNC_STATUS Varchar2(20 ) NOT NULL
CONSTRAINT WSR_SYNC_STATUS_CHECK CHECK (WSR_SYNC_STATUS IN ('insert','update','delete')),

Is this a problem of the current Beta 3.5.2.10?

Regards
Andreas

vladka

Posts: 1,738
Registered: 2/20/07

Re: Check Constraints missing in DDL script
Posted: Nov 3, 2009 2:29 AM

in response to: AndreasL

Hello Andreas,

Yes, we know about it. For now AsText is displayed instead of the check constraint. This issue and related CR are in progress now. It will be fixed in next Beta.
Thanks for your patience.

Regards,

Vladka + TDM Team

Pages: 1

Back to Thread List

Legend
	Guru: 2001 + pts
	Expert: 751 - 2000 pts
	Enthusiast: 31 - 750 pts
	Novice: 0 - 30 pts
	Moderators
	Helpful answer (5 pts)
	Answered (10 pts)