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.