`reload_="catalog"`

<do action_="sql" reload_="catalog"/> refreshes the entire database catalog in the caller's session.

Description

The 1010data session retrieves SQL metadata at login and caches it throughout the session, just as it caches the underlying MDB metadata. This means that the user will not ordinarily see changes to the metadata after using a <do action_="sql"> transaction until next time they log in. <reload_="catalog"> reloads the cache to ensure that changes are visible to the session. <reload_="catalog"> also clears the MDB query cache to avoid returning stale results from cached queries.

Syntax

<dynamic>
    <do action_="sql" reload_="catalog"/>
</dynamic>