- Zetaris Support - Knowledge Base
- Using Zetaris
- Query Builder
Processes for Automation: Table, View, Schema creation / deletion
This article explains how to use Zetaris' Query Builder to create and delete views.
Steps to create view
-
Login to Zetaris
-
Go to query builder tab
3. In the middle pane drag and drop tables that are needed in the view.
![QBImage2](https://kbase.zetaris.com/hs-fs/hubfs/QBImage2.png?width=688&name=QBImage2.png)
5. Select all the columns that are needed by clicking on the plus button, then further clicking add.
![QBImage3](https://kbase.zetaris.com/hs-fs/hubfs/QBImage3.png?width=688&name=QBImage3.png)
6. Once all columns, predicates, aggregations for and the name of the permanent view are set, click on "Save Permanent View."
7. This will save your view.
Steps to delete view
-
Login to Zetaris
-
Go to query builder tab
![QBImage4](https://kbase.zetaris.com/hs-fs/hubfs/QBImage4.png?width=688&name=QBImage4.png)
4. This will delete your view.