Why in the erwin Data Modeler Forward Engineer Preview SQL Syntax I am not seeing View SQL? Other SQL Syntax creates fine, including Parent Table Create syntax.
Solution: Check the View Editor and confirm the checkbox "Generate" is checked off. The View SQL Syntax will now be created in the Forward Engineer Preview SQL Syntax.
If you check off "User-Defined SQL" this will overwrite the View syntax that is automatically generated as seen above. See below for the results of the user defined syntax.
Note: User Defined SQL should only be used for documentation purposes only as there is no validation.