Tabular IQ

DbViewInfo Class

Class Index By Category

Overview

The DbViewInfo class describes a SQL view, the way the database reports it. DbConnection.describeView() returns one.

Properties

DbViewInfo.name
The name of the view, given as a string.
DbViewInfo.definition
The query that defines the view, given as a string: the SELECT, without the CREATE VIEW before it.
DbViewInfo.materialized
True for a materialized view, which stores its rows, and false otherwise.
DbViewInfo.updatable
True if the database lets rows be inserted, updated or deleted through the view, and false otherwise.
DbViewInfo.checkOption
The view's check option, given as a string: "NONE", "LOCAL" or "CASCADED".