xxxxxxxxxx
ALTER TABLE table_name ADD column_name varchar(50);
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 internal_transfer
ADD client_account_id int not null
AFTER id;