Why all the format of the Views disappear after Run or Save the Views?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All

Please notice that views are stored in the server side, therefore, the format Navicat shows are actually returned from the server.

In version 9 or above, you can employ Beautify SQL to format the SQL statement after you opened the View Designer.