SHOW OBJECTS command: New column and changes to output¶

Attention

This behavior change is in the 2024_03 bundle.

For the current status of the bundle, refer to Bundle History.

The SHOW OBJECTS output behaves as follows:

Before the change:

The output of SHOW OBJECTS does not include the is_dynamic column, and the kind column returns DYNAMIC_TABLE for dynamic tables.

After the change:

The output of SHOW OBJECTS includes the is_dynamic column, which is defined as follows:

Column Name	`is_dynamic`
Data Type	Text
Description	Y if the table is a dynamic table; otherwise, N.

The kind column in the output of SHOW OBJECTS displays TABLE for dynamic tables.

Ref: 1529