Saved Queries

Rename Output Columns

A view can rename output columns without changing the base table.

highlighted = computed this step

Rename output columns

A saved query can label its output columns without changing the base table.

rename output labels\text{rename output labels}

Show the output labels

The output still has 2 columns, and the alias flag is yes.

columns=2\text{columns}=2

View examples are tiny finite saved-query outputs; SQL dialects, optimizers, security, updatability, materialized-view strategy, performance, and maintenance advice are out of scope.

Rename output columns: base tableidstatustotal1open502closed203open70 view column mappingsourceoutputidorder_idtotalamount view filteropcolumnvalueeqstatusopen source rows usedbaseRow02 current view outputorder_idamount150370 view factsfactvaluebaseRowCount3sourceRowCount2rowCount2columnCount2stalenot_materializedhasFilteryeshasAliasesyeshasMaterializedCopyno

Read the mapping

The mapping table shows source columns beside their output names.

alias mapping\text{alias mapping}

Summary

Duplicate output aliases fail closed because the view shape would be unclear.

clear names\text{clear names}