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.