select
database_name
, folder
, name
, create_date
, last_modification_date
, view_type
, cache_status
, view_status
from GET_VIEWS()
order by database_name, name
;
view_type:
0: if it is a base view
1: if it is a derived view
2: if it is an interface view
3: if it is a materialized table
cache_status:
0: if the cache mode is "Off"
1: if the cache mode is "Partial exact"
2: if the cache mode is "Partial"
3: if the cache mode is "Full"
4: if the cache mode is "Partial exact preload"
5: if the cache mode is "Partial preload"