SQL 9 🛢️ Modifying Tables with ALTER TABLE
A table is created once and lives for years. The data inside it changes constantly, but the structure — the columns, the data types, the constraints — is not permanent. Requirements change. A new column is needed. A data type was chosen poorly. A constraint must be added to prevent invalid data. The ALTER TABLE…