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 vote123 views1 answer
Sql server user permissions and roles
SQL
0 vote77 views0 answer
SQL
0 vote113 views1 answer
Change database name psql 8
SQL
1 vote142 views2 answers
Drop table if exists test
SQL
0 vote128 views1 answer
Postgresql array to rows
SQL
0 vote126 views1 answer
Sql server Cost Fifo query
SQL
1 vote125 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
2 votes154 views1 answer
Mysql now format
SQL
0 vote119 views1 answer
MySql count occurences more than"
SQL
0 vote125 views2 answers
Mysql calcular idade
SQL