| name |
string |
Name of the view |
| secure |
boolean |
Whether or not this view is secure |
| kind |
string |
Kind of the view, permanent (default) or temporary |
| recursive |
boolean |
Whether or not this view can refer to itself using recursive syntax withot requiring a CTE (common table expression) |
| columns |
array |
The columns of the view |
| comment |
string |
user comment associated to an object in the dictionary |
| query |
string |
Query used to create the view |
| created_on |
string |
Date and time when the view was created. |
| database_name |
string |
Database in which the view is stored |
| schema_name |
string |
Schema in which the view is stored |
| owner |
string |
Role that owns the view |
| owner_role_type |
string |
The type of role that owns the view |