Creating a Check constraint in TOAD DM

Toad Data Modeler
1

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,

2

constraints on columns are created

3

Can you send me an example in SQL, please?

Thank you,

Vaclav

4

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”))

5

Hi,

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

Regards,

Vaclav

chk-cnst.png
chk-cnst.png1019×714 35.6 KB