G-7127 – Always use the FORCE option when creating views.

The `FORCE` option ensures that the object definition is stored in the data dictionary, even if semantic validation fails. Without `FORCE`, object creation is aborted and the definition is lost. This reduces the visibility of invalid objects and complicates dependency analysis, troubleshooting, and deployment validation. Specify the `NO FORCE` option if you want the statement to fail when it contains semantic errors. However, object definitions containing syntax errors are not stored in the data dictionary, even when the `FORCE` option is specified. This rule applies to the following SQL statements: - `create json relational duality view` - `create view`

Tags: Stored Object.

Quality area: Maintainability. Severity: Major. Fixing time: Local-easy.