catalog.views table
The catalog.views table stores information about views. The CreationText column contains the SQL used to create the view.
The following table describes the columns in the catalog.views table.
| Column name | Data type | Description |
|---|---|---|
| ViewName | varchar(40) | Name of the view. |
| DatabaseName | varchar(40) | Name of the parent database. |
| CreationText | varchar(16384) | The CREATE VIEW text used to create the view. |
| StorageKind | integer | Type of storage: 1: Persistent 4: Transient |
| IsRecovered | Boolean | TRUE if this is a successfully recovered view after restart. |
| IsDmlEnabled | Boolean | TRUE if all of the table's primary keys are in the view, and therefore DML actions can be performed on the view. |
| IsAggregate | Boolean | TRUE if this is created from an aggregate SELECT statement. |