Home:ALL Converter>Object Status (Table, View etc.) VALID/INVALID in Informix

Object Status (Table, View etc.) VALID/INVALID in Informix

Ask Time:2017-07-11T00:40:52         Author:bda

Json Formatter

Does Informix have object status? In Oracle there is a status on the views, tables and other objects represented by VALID/INVALID values.

An equivalent Oracle query is:

SELECT owner,
       object_name,
       status
  FROM all_objects

What about Informix?

Author:bda,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/45017485/object-status-table-view-etc-valid-invalid-in-informix
yy