1. SQL Reference Guide
  2. Namespace Management
  3. Namespace Resolution

Namespace Resolution

To resolve a table from a table_name that appears in an SQL statement, the following rules apply:

  • if the table_name contains a namespace name, no resolution is needed, because a qualified table name uniquely identifies a table.
  • if you don't specify a namespace name explicitly, the namespace used is the one contained in the ExecuteOptions instance that is given as input to the executeSync(), execute(), or prepare() methods of TableAPI. See Java Direct Driver Developer's Guide.
  • if ExecuteOptions doesn't specify a namespace, the default sysdefault namespace is used.

Using different namespaces in ExecuteOptions allows executing the same queries on separate but similar tables.