Namespace Resolution

Namespace resolution determines which table a SQL query refers to, ensuring that the query targets the correct table, especially when multiple tables with the same name exist across different namespaces.

The rules are as follows:

• If you provide the table name with a namespace, no further resolution is needed because the namespace uniquely identifies the table.
• If you provide the table name without a namespace, the system resolves the table based on the namespace specified in the ExecuteOptions class.
• If ExecuteOptions does not specify a namespace, the system defaults to the sysdefault namespace to resolve the table.
• By using different namespaces in ExecuteOptions, you can execute the same queries on similar tables present in different namespace.