4 ms·
Sure but columns can change data types too which 'select column's doesn't protect you from either
by hvb2 1y ago
Sure but columns can change data types too which 'select column's doesn't protect you from either
- layer8 1y agoA column changing its data type is generally considering a breaking change for the schema (for obvious reasons), while adding more columns isn’t. Backwards-compatible schema evolution isn’t practical without the latter — you’d have to add a new secondary table whenever you want to add more columns. This mirrors how adding additional fields to an object type in a programming language usually isn’t considered a breaking change, but changing the type of an existing field is.