Table Properties (Change Tracking Page)
- Change Tracking
Indicates whether change tracking is enabled for the table. The default value is False.
This option is available only when change tracking is enabled for the database. For more information, see Database Properties (ChangeTracking Page).
To enable change tracking, the table must have a primary key, and you must have permission to modify the table.
You can also configure change tracking by using ALTER TABLE.
- Track Columns Updated
Indicates whether the SQL Server Database Engine tracks which columns were updated.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback