Row-end column

The row-end column represents the time when the data in the row was no longer current.

The rows in the system-period temporal table are by definition current, so the row-end column is populated with a default value, 9999-12-30-00.00.00.000000000000. For rows in a history table, the value in the row-end column represents when the row was added to the history table. For more information on how this value is set for historical rows, see Updating data in a system-period temporal table and Deleting data in a system-period temporal table.

When an existing table is altered to add a row-end column, the row-end column is populated with the default value 9999-12-30-00.00.00.000000000000 for all existing rows.