Hi Beth,
Not sure why this is the case, but it is frustrating sometimes trying to remember which columns are in which tables.
One work around could be to create your own system views in the PUBLIC schema and add the columns you prefer...
Example:
Code: Select all
dbadmin=> select min(schema_name) from all_tables;
min
-----
jim
(1 row)
dbadmin=> select min(schema_name) from tables;
ERROR 2624: Column "schema_name" does not exist
dbadmin=> create view public.tables as
dbadmin-> select
dbadmin-> table_schema_id,
dbadmin-> table_schema schema_name,
dbadmin-> table_id,
dbadmin-> table_name,
dbadmin-> owner_id,
dbadmin-> owner_name,
dbadmin-> is_temp_table,
dbadmin-> is_system_table,
dbadmin-> force_outer,
dbadmin-> is_flextable,
dbadmin-> has_aggregate_projection,
dbadmin-> system_table_creator,
dbadmin-> partition_expression,
dbadmin-> create_time,
dbadmin-> table_definition,
dbadmin-> recover_priority,
dbadmin-> storage_mode
dbadmin-> from v_catalog.tables;
CREATE VIEW
dbadmin=> select min(schema_name) from tables;
min
-----
jim
(1 row)