GET_VIEW_TAGS

Description

The stored procedure GET_VIEW_TAGS returns information about the tags assignments to views and columns.

Each row represents an assignment.

Syntax

GET_VIEW_TAGS (
      input_database_name : text
    , input_view_name : text
    , input_column_name : element type
    , input_tag_names : array
)
  • input_database_name: name of the database where the views belong to (optional).

  • input_view_name: name of the view (optional).

  • input_column_name: name of the column (optional).

  • input_tag_names: names of the tags to search (optional).

The output schema has the following fields:

  • database_name: name of the database where the views belong to.

  • view_name: name of the view.

  • column_name: name of the column.

  • tag_name: name of the tag.

Examples

Example 1

SELECT * from GET_VIEW_TAGS()
   WHERE INPUT_DATABASE_NAME = 'acme'

Obtains the tags assignment information for the views and columns from the database acme.

Example 2

SELECT * from GET_VIEW_TAGS()
   WHERE INPUT_DATABASE_NAME = 'acme' AND INPUT_TAG_NAMES = {ROW('restricted'), ROW('confidential')}

Obtains the views and columns from database acme which have the tags restricted and confidential.