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 sales.quotations
ADD
amount DECIMAL (10, 2) NOT NULL,
customer_name VARCHAR (50) NOT NULL;
Code language: SQL (Structured Query Language) (sql)
xxxxxxxxxx
ALTER TABLE table_name
ADD column_name data_type column_constraint