Back to articles list
Sometimes, you want all identifiers in your SQL script to be quoted. For example, you want them to have a particular case. Luckily, Vertabelo allows you to quote all SQL identifiers in your generated script to prevent you from any SQL name conflicts.
Go to your model:
Click the SQL generation settings tab in the Model properties panel on the right:
Check Quote all SQL identifiers:
If you want to check out the result, select any table and click the SQL preview button:
Now, you can see that all identifiers are quoted:
Note that since the above sample model was created for MySQL, the identifiers are quoted with backticks, i.e., `reservation_type_id`. For other database engines (that are ANSI-compliant) double-quotes will be used, i.e., "reservation_type_id". The following example is for PostgreSQL:
