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 dbo.doc_exa
ADD column_b VARCHAR(20) NULL,
column_c INT NULL ;
xxxxxxxxxx
ALTER TABLE table_name
ADD column_name1 column_definition,
ADD column_name2 column_definition;
xxxxxxxxxx
-- For More Tutorial, visit NAYCode.com
Alter Table [Table Name] Add [Column Name] [datatype]
xxxxxxxxxx
ALTER TABLE table_name
ADD column_name data_type column_constraint
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)