Example: Re-Ordering of Columns Using Schema Evolution | VantageCloud Lake - Example: Re-Ordering of Columns Using Schema Evolution - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

Schema After Evolution

EmpName    EmpID     City
-------    -----     --------
John       65784     Austin
Robert     69824     Atlanta
Frank      48392     Columbus
Colin      72985     Phoenix
Brandon    34862     Hartford

Select Columns From NOS Table

SELECT EmpID,EmpName,City from nos_table;

Result:

    EmpID          EmpName       City
    -----          -------        --------
    65784          John          Austin
    69824          Robert        Atlanta
    48392          Frank         Columbus
    72985          Colin         Phoenix
    34862          Brandon       Hartford

If schema evolution were disabled, the following result would be returned:

    EmpID          EmpName        City
    -------        -------        --------
    John           65784          Austin
    Robert         69824          Atlanta
    Frank          48392          Columbus
    Colin          72985          Phoenix
    Brandon        34862          Hartford