Create View

Create View allows users to create a custom database view on the tables in a local SQLite database. Note: It is not possible to create a view on an ODBC-connected database (e.g. SQL Server, Oracle). Users must have a system administrator create that view in the external database before using Import definition from external table to import the view.

  1. From within the project/data folder click the 'New table' function.

  2. From the data main panel select Create view from the 'Mode' dropdown menu.
  3. In 'Source' field select the name of the database for which to create a table view.
  4. In the 'View name' field specify a name for the view.
  5. In the 'DDL' field enter the query required to create the table view.

  6. Click add to complete the operation.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • These views can be set up for complex SQL Select statements with special joins, etc. in the case where your selection cannot be created using the standard editor in the dbgrid part.

Like1 Follow
  • 1 yr agoLast active
  • 1Replies
  • 32Views
  • 2 Following