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

0 vote275 views1 answer
Cara menampilkan user di mysql terminal
SQL
1 vote268 views1 answer
Primary key reset in SQL database
SQL
0 vote268 views1 answer
2020 new year
SQL
0 vote287 views1 answer
Creating a simple notify in postgresql
SQL
0 vote302 views1 answer
Mysql user set plugin
SQL
0 vote274 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
9 votes311 views3 answers
Postgres make sql dump
SQL
0 vote274 views1 answer
Mysql date time string format python
SQL
0 vote325 views1 answer
Alternative for LIMIT sql
SQL
18 votes277 views3 answers
Mysql number format
SQL