Toad World® Forums

Creating a Check constraint in TOAD DM

I’m trying to find a way to effectively add check constraints to my model.

If’s there’s a simple straight forward way to do so.

Thanks,

constraints on columns are created

Can you send me an example in SQL, please?

Thank you,

Vaclav

The SQL code looks like this:

(ERROR_FLAG=“Y”) OR (ERROR_FLAG=“N”)

When I generate DDL the code looks lile the following:

CONSTRAINT ERROR_FLG_CHK CHECK ((ERROR_FLAG=“Y”) OR (ERROR_FLAG=“N”))

Hi,

edit your attribute, on tab check constraint add new item and then define the SQL code manually. See attached screenshot.

Regards,

Vaclav