An identifier is a string used to reference a database, table, or
field. Identifiers follow the standard SQL rules. Since a UnityJDBC query may span multiple
databases, table and field identifiers defined in a data source may not be unique across all
data sources. In which case, the database name should be added to the identifier to create a
unique system-wide identifier. For instance, consider an order database given the name
OrderDB
with a table called Orders
and fields
id
and orderDate
. The Orders
table may be referred to using only Orders
or
OrderDB.Orders
. Similarly, the field id
may be
referred to as Orders.id
or OrderDB.Orders.id
.
Standard aliasing using AS
in the FROM
and
SELECT
clauses is supported. Delimited identifiers are supported by
enclosing in double quotes (e.g. "from"
or "my field with
spaces"
). Delimited identifiers must be used for SQL reserved words.