Databases Reference
In-Depth Information
Just type the first few characters of the table name, and click on the arrow—all matching tables
will be listed, and here again, select the table and then click on the
Add
button.
We can see here that the SAP HANA Studio shows in which schema a table
can be found—if we have many tables containing the letters
cust
, they would
all be listed, and by seeing the schema we can select the correct table.
Several tables can be added to a view at once, just add all the tables required.
Here, we'll just add our
CUSTOMERS
table to the view—once that's done, click on
Finish
to see
the results.
The next step in our attribute view creation is to add the fields we want to use. The
CUSTOMERS
table contains three fields; we'll only be using two of them in the view.
An attribute view contains, like a table itself, key fields and data fields. Right-click on
the
CUST_ID
field in the left-hand pane, and select
Add as key attribute
. Then, add the
CUST_NAME
field as a regular attribute, using the
Add as attribute
option.
Once that's done, we have an attribute view that looks similar to the screenshot we've
just seen. There's a little green star next to
CUST_ID
, to show it's a key attribute.