Redgate Data Modeler

5 December 2015

Tip #5 – How to quote table names in generated SQL script

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 e.g. PostgreSQL) double-quotes will be used, i.e., "reservation_type_id".