Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


VIEWS


Records views in the database.

Column name
Data type
Description

VIEW_SYSID

INTEGER

System identifier of the view.

CHECK_OPTION

CHAR(20)

One of:
"CASCADED"
"LOCAL"
"NONE".

IS_UPDATABLE

CHAR(3)

One of:
"NO" = The view can not be updated
"YES" = The view can be updated.

IS_INSTEAD_OF

CHAR(3)

One of:
"NO" = The view can be updated per se
"YES" = The view can be updated due to the existence of an instead of trigger.

VIEW_DEFINITION

VARCHAR(2000)

The text of the view definition.

Primary key: VIEW_SYSID



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX