Views from database

What are views?

A VIEW is like a virtual table that contains data from one or more tables. It contains no data and does not physically exist in the database. Like an SQL table, the display name must be unique in a database. It contains a set of predefined SQL queries to retrieve data from the database. It can also contain database tables from single or multiple databases.

SirkelData Views Form

 

Views toolbar

You can export the table to various formats: PDF, XLS, XLSX, RTF, CSV, DOCX, TXT, HTML, MHT

SirkelData Toolbar Export Ribbon

You can also use the Print Preview. The following screen and associated toolbar will appear:

SirkelData Print Preview

Here you can simplify, embellish, ... the export.

Views: overview and list

ColumnMeaning
View_nameName of the view
CreatedWhen was the view created.
ModifiedWhen was the view modified.
DefinitionSource code of the view.

View details and source code

SirkelData Views Detail Form