SET NO_BROWSETABLE#
When ON, every SELECT statement behaves as though FOR BROWSE were appended to it, so the
result carries the additional browse-mode metadata that identifies the columns and the base tables
behind the result set. When OFF (the default), statements run normally.
Syntax#
SET NO_BROWSETABLE { ON | OFF } [;]
Remarks#
Browse-mode metadata lets a client see which base table and key columns each result column comes from.
It is used by some data-access layers that build updatable result sets. Turning the option on applies
this mode to every SELECT in the session. The default is OFF.
Permissions#
Requires membership in the public role.
Examples#
SET NO_BROWSETABLE ON;