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 vote297 views1 answer
Day of the week sqlite
SQL
-1 vote348 views1 answer
Difference berween database and data base management system
SQL
1 vote282 views1 answer
How to truncate a table in databse
SQL
0 vote377 views2 answers
Insert data into multiple tables mysql
SQL
1 vote292 views1 answer
Importance of comment in mysql
SQL
1 vote305 views1 answer
Postgresql how to show table names
SQL
123 votes514 views5 answers
Sql where contains
SQL
0 vote337 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote284 views1 answer
Sql server split string and insert into table select
SQL
0 vote288 views1 answer
Pl sql search in all packages
SQL