Toad World® Forums

Display Column Constraint on Table in Model

Is it possible to indicate which columns have constraints applied to them on a table in the workspace?

Hi,

Not Null constraint = yes (NN mark).

Unique constraint = yes (unique key).

FK constraint = yes (relationship).

Check constraints = no.

Regards,

Vaclav

Thank you Vaclav. Where are these settings applied?

Hi,

see the following screenshot. It shows how Not Null, Unique Keys (Alternate Key - AK) and foreign keys are displayed. Settings can be modified on Application level in Settings, on Workspace level (right click on workspace and choose Workspace Format...) or on object level (right click entity and choose Format...)

constraints.png

Regards,

Vaclav

I originally applied the constraint as a constraint in the ‘Check Constraint’ tab of the ‘Entity Properties’. When I removed this and added an AK in the ‘Attribute Properties’ it now displays in the model. My preference is to have this constraint generate as part of the table create statement [‘Check Constraint’] (not an alter table statement [versus ‘Alternate Key’]) and display on the model that the column has a constraint applied. I will have to settle for one or the other. Thank you for you help! Nick

Hi,

you can change the way SQL code is generated. Open the SQL code generation form and on tab Detailed Settings click the Edit button in group box Order of generated objects. New dialog opens, click Extension tab and change value next to the Keys table cell. To activate edit mode press F2 key (similar to windows explorer behavior). Confirm changes, generate SQL code and see the output.

inside.png

unique.png

Regards,

Vaclav

Vaclav - You have been a great help! Thank you for showing me this is possible. Thank you. Cheers - Nick

You are welcome!