How to access the current object in CANames.sql

[Claus Pedersen]

How do I access the current object (for instance a package) when writing selects for CANames.sql?

 

[Marco Kalter]

That is not possible. The queries from this script are executed only once when the connection is established, and it runs in a background thread (it can be time-consuming). It can only be used to fetch names that are relevant in the scope of the connection.