Creating and managing views
Last updated
Last updated
Fabricate views allow you compose virtual tables from data in other tables. They are particularly use for:
Denormalization
Aggregation
Subsetting
JSON objects and arrays
When you export a database, views are exported as concrete tables. They do not create or replace the views in the target database.
To add a view to a database:
In the database heading, click Add View.
On the Add View panel, in the name field, provide a name for the view.
Click Create View.
The view is added to the tables list for the database.
The details page for the view is displayed.
To display the settings panel for the view, in the view heading, click the settings icon.
The view settings contain most of the same options as regular tables, including:
To regenerate the view data based on the current view definition, in the view heading, click the regenerate icon.
To delete a view, in the view header, click the delete icon.
To define the view, in the query text area, provide the query to use. The view definition accepts any valid SQLite query.
Constraints - For more information, go to .
Whether to include the view in the export - For more information, go to .
A seed to use for the view - For more information, go to .
