Current temporal modifications are modifications to the current rows of a temporal table.
The period of applicability of a current modification implicitly begins from the current time and extends indefinitely, represented by an ending period bound of UNTIL_CHANGED. Current modifications need not explicitly specify a period in the modification SQL. The CURRENT keyword causes the system to automatically apply the modification to those rows whose period of validity overlaps the current time.
Some proposed implementations of temporal tables suggest that a current modification also apply to future rows. In the Teradata Database implementation, a current modification applies only to current rows.
A current modification to any column creates history rows in the temporal table.