xxxxxxxxxx
ALTER TABLE internal_transfer
ADD client_account_id int not null
AFTER id;
xxxxxxxxxx
ALTER TABLE table_name
ADD column_name INT -- datatype
-- With default vaue and not nullable
ALTER TABLE table_name
ADD column_name BIT DEFAULT 0 NOT NULL --
xxxxxxxxxx
ALTER TABLE vendors
ADD COLUMN phone VARCHAR(15) AFTER name;
Code language: SQL (Structured Query Language) (sql)