Databases Reference
In-Depth Information
Clicking on Go generates the view we asked for. At this point, the view has been
created. If we refresh our browser's page and then access the marc_book database,
we will see the following screenshot:
In the main panel, we see the information on the newly-created view. The number of
rows for the view currently indicates ~0 (more on this in the Controlling row counting
for improved performance section, later in this chapter), and View is indicated in the
Type column. There is no collation or size associated with a view.
Main panel and views
As a view has similarities with a table, its name is available along with the names of
the ordinary tables. On clicking the view name, a panel similar to the one seen for
tables is displayed, but with fewer menu tabs than seen in a normal table. Indeed,
some operations do not make sense on a view, for example, Import . This is because
a view does not actually contain data. However, other actions, such as Browse , are
perfectly acceptable.
Let us browse the view shown in the following screenshot:
 
Search WWH ::




Custom Search