Tutorial 4 - Create view using wizard
Step 0 - Start Wizard
This tutorial show, how to create new view using wizard in KPoGre. Wizard is not able to handle all possible requirements, but it is suitable for most of common situations. I am expect, that you are basicaly familiar with CREATE VIEW statement.
In left tree view, select Database
or Schema
and choose menu command Database
-> Wizard
.
Select view
icon from displayied dialog.
Or select Views
folder and make right button click on it to display
object menu.
KPoGre displays wizard for create new view. This wizard have 5 steps.
Step 1 - View name
If you start this wizard when Database
is selected,
choose schema for new view. When you run wizard from Schema
or
Tables
folder, actual schema is used.
Type name
for new view. Add tables
that will be used for output columns and joins. Using one or two letters Alias
for each table is good practice.
Step 2 - Define columns
For each table you may add column to view output. If you want to rename column, use AS
field.
After defining all columns press Next
button.
Step 3 - Define joins
If you have more than one table in view, you probably need define joins. Choose Join type
. Select tables
for joins and also select columns
. Selecting more than one column is allowed. Joined columns must have compatible datatypes and selected columns count must match.
Press Add
button in Joins
group box. Join definition is included to list. You may repeat this for all needed joins in view.
After adding first join, left table is locked and you may change only right table.
Join may be removed from list, using Delete
button. After defining all joins press Next
button.
Step 4 - Define conditions
In this step you may define conditions to reduce number of output rows. Thi step is optional. Select Table
and its Column
for condition. Also select Condition
type and enter Value
.
Press Add
button in Conditions
group box. Condition is included to list. You may repeat this for all needed conditions in view.
Condition may be removed from list, using Delete
button. After defining all conditions press Next
button.
Step 5 - Review SQL statement
In this step, SQL statement for create view is displayied for your check. You may modify it, if you understand, what do you do.
When you press Next
button command will be send to server.
Step 6 - Check operation result
Finally, check operation result. If you get any error, you may go Back
and try make changes and retry step 5.