Suggest an editImprove this articleRefine the answer for “How do you add a new column to a table?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)Adding a new column to an existing table is done with `ALTER TABLE` and the `ADD COLUMN` clause, e.g. `ALTER TABLE Employees ADD COLUMN Salary DECIMAL(10,2);`. **Key point:** constraints like `NOT NULL` or `DEFAULT value` (e.g. `DEFAULT CURRENT_DATE`) can be added right away, and some DBMSs let you add several columns in a single query.Shown above the full answer for quick recall.Answer (EN)ImageAdding a new column to an existing table is done with the `ALTER TABLE` command and the `ADD COLUMN` clause. **Syntax:** ```sql ALTER TABLE Table_Name ADD COLUMN Column_Name Data_Type Constraints; ``` **Example:** ```sql ALTER TABLE Employees ADD COLUMN Salary DECIMAL(10,2); ``` **Explanation:** - `ALTER TABLE Employees`, picks the table we want to change. - `ADD COLUMN Salary DECIMAL(10,2)`, adds a new `Salary` column, a number with two digits after the decimal point. ### Notes - Several columns can be added in a single query (in some DBMSs). - Constraints can be added if needed: `NOT NULL`, `DEFAULT value`, and so on. An example with a constraint: ```sql ALTER TABLE Employees ADD COLUMN HireDate DATE NOT NULL DEFAULT CURRENT_DATE; ```For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.