Reports the table’s current logging mode, depending on the session, table and database-wide settings.


object_attr(table_name, string)




  • The return type is a varchar, which appropriately returns the value of the property (for example, on or off) depending on the property queried for.

  • The logging mode as reported by extensions to showplan output might be affected at run-time, if there are set statements in the same batch, preceding the execution of the DML, which changes the logging mode of the table

  • The return value is the value NULL (not the string “NULL”) for an unknown property.

  • A special-type of string parameter, help prints to the session’s output all the currently supported properties for object_attr. This allows you to quickly identify which properties are supported by object_attr.