# View

## Overview

A **View** object represents an individual table view in a [Database Server](https://docs.servoy.com/reference/servoycore/object-model/database-server).\
A database table view, often simply referred to as a "view," is a virtual or logical table generated by a query on one or more database tables. Users or applications can then query the view as if it were a regular table, even though it does not store any data itself.

## Properties Summary

The following properties can be configured for a View object:

| Property                                                                                               | Summary                                                                  |
| ------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------ |
| [hiddenInDeveloper](https://docs.servoy.com/reference/servoycore/object-model/table#hiddenindeveloper) | Use this property to hide the view from the Servoy Developer environment |
| isMetadataTable                                                                                        | Returns whether table was flagged as metadata view                       |

## Events Summary

The following events can be handled for a View object.

| Property                                                                                                               | Summary                                                                                 |
| ---------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------- |
| [onRecordInsert](https://docs.servoy.com/reference/servoycore/object-model/table#onrecordinsert)                       | occurs prior to a new record being inserted into the table                              |
| [onRecordUpdate](https://docs.servoy.com/reference/servoycore/object-model/table#onrecordupdate)                       | occurs prior to an existing record being updated in the database                        |
| [onRecordDelete](https://docs.servoy.com/reference/servoycore/object-model/table#onrecorddelete)                       | occurs prior to an existing record being deleted from the database                      |
| [afterRecordInsert](https://docs.servoy.com/reference/servoycore/object-model/table#afterrecordinsert)                 | occurs subsequent to a new record being inserted into the table                         |
| [afterRecordUpdate](https://docs.servoy.com/reference/servoycore/object-model/table#afterrecordupdate)                 | occurs subsequent to an existing record being updated in the database                   |
| [afterRecordDelete](https://docs.servoy.com/reference/servoycore/object-model/table#afterrecorddelete)                 | occurs subsequent to an existing record being deleted from the database                 |
| [onFoundSetRecordCreate](https://docs.servoy.com/reference/servoycore/object-model/table#onfoundsetrecordcreate)       | occurs prior to a new record being created in the foundset                              |
| [onFoundSetFind](https://docs.servoy.com/reference/servoycore/object-model/table#onfoundsetfind)                       | occurs prior to the foundset going into find mode                                       |
| [onFoundSetSearch](https://docs.servoy.com/reference/servoycore/object-model/table#onfoundsetsearch)                   | occurs prior to executing a search on the foundset                                      |
| [afterFoundSetRecordCreate](https://docs.servoy.com/reference/servoycore/object-model/table#afterfoundsetrecordcreate) | occurs subsequent to the creation of a new record                                       |
| [afterFoundSetFind](https://docs.servoy.com/reference/servoycore/object-model/table#afterfoundsetfind)                 | occurs subsequent to entering find mode                                                 |
| [afterFoundSetSearch](https://docs.servoy.com/reference/servoycore/object-model/table#afterfoundsetsearch)             | occurs subsequent to performing the search for a foundset                               |
| [onValidate](https://docs.servoy.com/reference/servoycore/object-model/table#onvalidate)                               | occurs before an insert operation, it can block the insert operation by returning false |

## Properties Details

See [Table Properties Details](https://docs.servoy.com/reference/servoycore/object-model/table#properties-details).

## Events Details

See [Table Events Details](https://docs.servoy.com/reference/servoycore/object-model/table#events-details).

## Column

See [Table Column](https://docs.servoy.com/reference/servoycore/object-model/table/column#properties-details).

## Calculation

See [Table Calculation](https://docs.servoy.com/reference/servoycore/object-model/table/calculation#properties-details).

## Method

See [Table Method](https://docs.servoy.com/reference/servoycore/object-model/table/method#properties-details).

## Aggregration

See [Table Aggregration](https://github.com/Servoy/gitbook/blob/master/reference/servoycore/object-model/database-server/table/aggregration.md#properties-details).