Computed columns are columns that contain data determined by data in other columns.
For example, an
table contains columns
is a computed column that is calculated as
Basic_Salary + Allowances - Tax_Deduction
. The database populates the data in
. If the values in any of the three columns change, the database updates the value in the
You can include tables that contain computed columns in a TDM operation. Because the values are calculated based on data in other columns, the TDM operation does not copy data into computed columns in the target. The database populates the values based on the data in other columns.
You cannot apply data masking or data generation rules on computed columns. You cannot create a value cascade or an auto cascade on computed columns.
You cannot perform data generation operations that include an entity if the primary key column is a computed column.