MY_TABLES
MY_TABLES displays information about the tables owned by the current user. This view exists in both PG_CATALOG and SYS schema.
| Name | Type | Description |
|---|---|---|
| owner | character varying(64) | Table owner. |
| table_name | character varying(64) | Table name. |
| tablespace_name | character varying(64) | Tablespace name of the table. |
| dropped | character varying | Specifies whether the current record is deleted.
|
| num_rows | numeric | Estimated number of rows in the table. |
| status | character varying(8) | Specifies whether the current record is valid.
|
| sample_size | numeric | Number of samples used for analyzing the table. |
| temporary | character(1) | Specifies whether the table is a temporary table.
|
| pct_free | numeric | Minimum percentage of free space in a block. |
| ini_trans | numeric | Initial number of transactions. |
| max_trans | numeric | Maximum number of transactions. |
| avg_row_len | integer | Average number of bytes in each row. |
| partitioned | character varying(3) | Specifies whether a table is a partitioned table. |
| last_analyzed | timestamp with time zone | Last time when the table was analyzed. Database restart is not supported. Otherwise, data loss will occur. |
| row_movement | character varying(8) | Specifies whether to allow partition row movement. |
| compression | character varying(8) | Specifies whether to enable a table compression. |
| duration | character varying(15) | Time elapsed when a temporary table is processed. |
| logical_replication | character varying(8) | Specifies whether logical replication is enabled for a table. |
| external | character varying(3) | Specifies whether the table is a foreign table. |
| logging | character varying(3) | Specifies whether changes to a table are logged. |
| default_collation | character varying(100) | Default collation of a table. |
| degree | character varying(10) | Number of instances in a scanned table. |
| table_lock | character varying(8) | Specifies whether to enable a table lock. |
| nested | character varying(3) | Specifies whether a table is a nested table. |
| buffer_pool | character varying(7) | Default buffer pool of a table. |
| flash_cache | character varying(7) | Smart flash cache hint in database for a table block. |
| cell_flash_cache | character varying(7) | Cell flash cache hint for a table block. |
| skip_corrupt | character varying(8) | Specifies whether to skip corrupted blocks during table scanning. |
| has_identity | character varying(3) | Specifies whether a table has an identifier column. |
| segment_created | character varying(3) | Specifies whether a table segment has been created. |
| monitoring | character varying(3) | Specifies whether to monitor the modification of a table. |
| cluster_name | character varying(128) | Not supported. Its value is NULL. |
| iot_name | character varying(128) | Not supported. Its value is NULL. |
| pct_used | numeric | Not supported. Its value is NULL. |
| initial_extent | numeric | Not supported. Its value is NULL. |
| next_extent | numeric | Not supported. Its value is NULL. |
| min_extents | numeric | Not supported. Its value is NULL. |
| max_extents | numeric | Not supported. Its value is NULL. |
| pct_increase | numeric | Not supported. Its value is NULL. |
| freelists | numeric | Not supported. Its value is NULL. |
| freelist_groups | numeric | Not supported. Its value is NULL. |
| backed_up | character varying(1) | Not supported. Its value is NULL. |
| blocks | numeric | Not supported. Its value is NULL. |
| empty_blocks | numeric | Not supported. Its value is NULL. |
| avg_space | numeric | Not supported. Its value is NULL. |
| chain_cnt | numeric | Not supported. Its value is NULL. |
| avg_space_freelist_blocks | numeric | Not supported. Its value is NULL. |
| num_freelist_blocks | numeric | Not supported. Its value is NULL. |
| instances | character varying(10) | Not supported. Its value is NULL. |
| cache | character varying(5) | Not supported. Its value is NULL. |
| iot_type | character varying(12) | Not supported. Its value is NULL. |
| secondary | character varying(1) | Not supported. Its value is NULL. |
| global_stats | character varying(3) | Not supported. Its value is NULL. |
| user_stats | character varying(3) | Not supported. Its value is NULL. |
| cluster_owner | character varying(30) | Not supported. Its value is NULL. |
| dependencies | character varying(8) | Not supported. Its value is NULL. |
| compression_for | character varying(30) | Not supported. Its value is NULL. |
| read_only | character varying(3) | Not supported. Its value is NULL. |
| result_cache | character varying(7) | Not supported. Its value is NULL. |
| clustering | character varying(3) | Not supported. Its value is NULL. |
| activity_tracking | character varying(23) | Not supported. Its value is NULL. |
| dml_timestamp | character varying(25) | Not supported. Its value is NULL. |
| container_data | character varying(3) | Not supported. Its value is NULL. |
| inmemory_priority | character varying(8) | Not supported. Its value is NULL. |
| inmemory_distribute | character varying(15) | Not supported. Its value is NULL. |
| inmemory_compression | character varying(17) | Not supported. Its value is NULL. |
| inmemory_duplicate | character varying(13) | Not supported. Its value is NULL. |
| duplicated | character varying(1) | Not supported. Its value is NULL. |
| sharded | character varying(1) | Not supported. Its value is NULL. |
| hybrid | character varying(3) | Not supported. Its value is NULL. |
| cellmemory | character varying(24) | Not supported. Its value is NULL. |
| containers_default | character varying(3) | Not supported. Its value is NULL. |
| container_map | character varying(3) | Not supported. Its value is NULL. |
| extended_data_link | character varying(3) | Not supported. Its value is NULL. |
| extended_data_link_map | character varying(3) | Not supported. Its value is NULL. |
| inmemory_service | character varying(12) | Not supported. Its value is NULL. |
| inmemory_service_name | character varying(1000) | Not supported. Its value is NULL. |
| container_map_object | character varying(3) | Not supported. Its value is NULL. |
| memoptimize_read | character varying(8) | Not supported. Its value is NULL. |
| memoptimize_write | character varying(8) | Not supported. Its value is NULL. |
| has_sensitive_column | character varying(3) | Not supported. Its value is NULL. |
| admit_null | character varying(3) | Not supported. Its value is NULL. |
| data_link_dml_enabled | character varying(3) | Not supported. Its value is NULL. |
| object_id_type | character varying(16) | Not supported. Its value is NULL. |
| table_type_owner | character varying(128) | Not supported. Its value is NULL. |
| table_type | character varying(128) | Not supported. Its value is NULL. |
| compress_for | character varying(30) | Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
