Which command is used to add a new column to the existing table? code example

Example: add new column in table

ALTER TABLE vendors
ADD COLUMN phone VARCHAR(15) AFTER name;
Code language: SQL (Structured Query Language) (sql)