It is possible to execute this statement in each namespace, but the codecompletion of the query analyzer works only in the %SYS namespace. All other namespace hide this information.
Do you know some helpful metadata queries? Please post it to the forum.