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 an external 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) |
Not supported. Its value is NULL. |
cell_flash_cache |
character varying(7) |
Not supported. Its value is NULL. |
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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
