Automatically Detect Table Schema/Namespace

description

Queries executed on a tablename without a namespace should automatically resolve to the proper namespace. For example, if I run "Select * from batches" and the table batches has a namespace of dbo.batches in one environment, but in another environment
the table namespace is vendor.batches, it should automatically recognize that schema.