Skip to content

Choosing Delimiters and Qualifiers

A delimited identifier is a name in quotes or another delimiter, such as "Order Details" or [Order Details]. It is needed for names with special characters, reserved words or mixed case. A qualified name includes the schema or database, such as sales.orders. It is needed for objects in another schema or database than the current one.

When DbVisualizer runs SQL on its own, for example to load the Data tab of a table or to drop a procedure, it always uses delimited and qualified names. For SQL that DbVisualizer generates for you, you choose whether to use them.

To set this for a connection, use the Delimited Identifiers and Qualifiers categories in the Properties tab of the connection. To set it for all connections to a database type, use the same categories for the database type in the Database tab of Tools → Tool Properties.

  • Delimited Identifiers shows the delimiters of the database, such as double quotes or square brackets, and lets you choose where to use them: in scripting, in auto-completion and the Query Builder, in exports, and in actions such as Create Table. You can only change the delimiters for the Generic database type.
  • Qualifiers lets you choose where to qualify names with the schema or database: in scripting, in the References and Navigator graphs, in auto-completion, in the Query Builder, and in exports. You can also choose where to qualify column names with the table name. For databases with both databases and schemas, you can choose fully qualified names in the graphs, in auto-completion and in the Query Builder.