/SQL/How to add column sql

How to add column sql

Alter table add column

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

13

Alter table add column

ALTER TABLE table_name 
ADD column_name datatype;

9

Add column in table

ALTER TABLE table_name
  ADD column_name column_definition;

2

How to add column sql

ALTER TABLE Customers
ADD Email varchar(255);

0

Similar codes

3 votes149 views1 answer
Locate sql server
SQL
6 votes139 views1 answer
Oracle trigger after logon on database
SQL
0 vote179 views3 answers
Mysql CAST(amount as float)
SQL
1 vote298 views3 answers
Sql subquery
SQL
0 vote160 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote140 views2 answers
Find a column in all tables mysql
SQL
0 vote147 views1 answer
Mysql query problems and solutions
SQL
1 vote145 views1 answer
OstgreSQL version
SQL
4 votes197 views1 answer
Oracle change nls_date_format permanently
SQL
8 votes143 views1 answer
Oracle add months to sysdate
SQL

Share