Spa HANA DB - View

Articles Related

Syntax

CREATE VIEW <view_name> [COMMENT <string_literal>]
   [(<column_name_list>)] AS <subquery> [<with_association_clause>]
   -- Data Security
   [WITH MASK (<column_name> USING <mask_expression> [,...])]
   [WITH STRUCTURED PRIVILEGE CHECK] 
   -- Cache
   [WITH [<cache_type>] CACHE [RETENTION] <minute_value> [OF <projection_list>]]
   [FILTER <filter_condition>]
   [FORCE]
   -- Data Check integrity when inserting / updating
   [WITH CHECK OPTION]

where:

• MASK is data masking for contents to transform confidential data so that it appears meaningless to users
• PRIVILEGE if an SQL-based analytic privilege must be needed to access this view.
• CACHE data cache gestion
• FILER reduces the cached data by specifying a filter condition.
• FORCE: forces the addition of a cache without checking its cachability

Metadata

select * from VIEW_COLUMNS where view_name = 'NAME'
select * from VIEWS

where:

• VIEW_COLUMNS
• VIEWS

Documentation / Reference

• Create View SQL statement