Return
-
Title
Table's create script is not showing the NULL for columns correctly in DDL -
Description
When I view the script in the Schema Browser's script tab or generate a DDL, all the columns show as NULL, whether or not they nullable or not.
-
Cause
Check Constraint option is unchecked in the script options.
-
Resolution
Open the Script Options, which can be found on the toolbar in the Schema Browser's Script tab. In the Script Options window, go to the Table tab and check the 'Check Constraint' option.
-
Additional Information
If you have the Check Constraint option un-checked, so the constraints are not included, then there will not be anything to make sure the column is actually NULL or NOT NULL. Since there is nothing to regulate if a value is entered for the column, Toad just creates the DDL to show all columns as NULL, since they can all be NULL without the constraint.