Metadata updates

Metadata (for example, table columns and their type) can change due to the execution of Data Manipulation Language (DML) statements or the external system configuration. The PI OLEDB Enterprise provider has an internal refresh rate of three minutes and automatically updates metadata. For example, if one user creates a Transpose TVF function, that function will be visible and callable by another user within three minutes.

Executing the below statement will trigger internal metadata refresh immediately.

REFRESH METADATA