Running the extended attributes view tool

You can use the extended attributes view tool to generate a database view that corresponds to an existing extended attribute.

To create a corresponding view for an extended attribute, complete the following steps:

Create an extended attribute on the model object.
Use the extended attributes view tool to create the required SQL scripts:
```
extattr_views.sh scripts
```
Use the extended attributes view tool to create the view:
```
extattr_views.sh create
```
Optional: Query the data using an SQL command.

For example, if you create an extended attribute called 'SUPPORT_AREA' on the ComputerSystem model type, running the extended attributes view tool creates two views:

EA_COMPUTERSYSTEM40_V
The new view has the following columns:
- PK_C, which contains the primary key.
- SUPPORT_AREA_C, which contains the extended attributes.
BE_COMPUTERSYSTEM40_V
The new view has the following columns:
- All columns from the building block view BB_COMPUTERSYSTEM40_V, for example PK_C, NAME_C, VMID_C.
- SUPPORT_AREA_C, which contains the extended attributes, only if there is no column name conflict with the columns from the building block view BB_COMPUTERSYSTEM40_V.

You can use the following SQL commands to query the data:

SELECT 
     	T1.FQDN_C,
     	T2.SUPPORT_AREA_C
     FROM
        BB_COMPUTERSYSTEM40_V T1,
        EA_COMPUTERSYSTEM40_V T2
     WHERE
        T1.PK_C = T2.PK_C

SELECT
     FQDN_C, SUPPORT_AREA_C
    FROM
     BE_COMPUTERSYSTEM40_V

Note: If a column name conflict occurs, the tool tries to add extended attribute category string. If this does not resolve the problem, the extended attribute column is not included in the BE_model_V views.