Menu

Table Status: Missing, Drift, Matched, Extra
📰

Table Status: Missing, Drift, Matched, Extra

DEV Community: database·Jeff·3 days ago
#7hj5Q4Dc
#devtodatabase#devto#dev#table#extra
Reading 0:00
15s threshold

Quick answer: During reconciliation every table gets one of four statuses: missing, drift, matched, or extra. Missing means the model expects a table the database does not have, drift means it exists but differs, matched means it agrees, and extra means the database has a table the model does not. The status names the table-level state before any migration is proposed.

Why a table status matters

A migration plan that does not first name the table state is hard to trust. A table that already matches should not be rebuilt, a table that differs needs a precise diff rather than a blind replace, and an extra table might be intentional or forgotten.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.