In MS SQL server , I can create a new column in the table bassed on a certain formula from the other columns, the calculated column will be auto. calcuated, Whenever I insert\update a row , and Store the result physical on the hand desk
The table will have 2 columns First name and second name , and the Calculated columns will concatinate both value . So I can select the calculated column directly from the table as a normal column.
Does Teradata has this option ?