Add column in table

Alter table add column

ALTER TABLE table
ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;

Alter table add column

ALTER TABLE table_name
ADD column_name datatype;

Add column in table

ALTER TABLE table_name
  ADD column_name column_definition;

Add a new column into table

ALTER TABLE table ADD [COLUMN] column_name;

Source: mysqltutorial.org

T-SQL Add Column

ALTER TABLE sales.quotations 
    ADD 
        amount DECIMAL (10, 2) NOT NULL,
        customer_name VARCHAR (50) NOT NULL;
Code language: SQL (Structured Query Language) (sql)

Source: sqlservertutorial.net

Similar codes

4 votes170 views1 answer
Oracle error compilation line
SQL
0 vote227 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote164 views2 answers
Mysql two column combination unique
SQL
0 vote156 views1 answer
Full syntax inner join
SQL
60 votes541 views6 answers
Add column in sql
SQL
1 vote161 views1 answer
Sql alchemy with azuresql server
SQL
1 vote177 views1 answer
Add many column to sap iq table
SQL
8 votes169 views2 answers
Mysql get first x characters
SQL
0 vote232 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
1 vote182 views2 answers
Sql drop multiple columns if exists
SQL