Change Views (Reference)
Go Up to System Tables, Temporary Tables, and Views
Change Views can be subscribed to in order to view data that has changed across database connections. The effect is a long-lived transaction spanning multiple database connections.
- Specifically, the subscription tracks all row inserts, updates, and deletes to one or more tables at a column-level granularity over a disconnected, extended period of time.
- The InterBase SQL query language is modified to search on columns where data has changed since the prior observation.
- These data changes are tracked at a column granularity.