calculated column

Database
Enthusiast

calculated column

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

 

Example 

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 ?

1 REPLY
Junior Contributor

Re: calculated column

There's no computed column in Teradata, this should be added to the view level.