Alter Table

Question

Alter Table

Anonymous User · Answer

To add a column to an existing table, the ALTER TABLE syntax is:ALTER TABLE table_nameand ADD column_name dataType
For example:ALTER TABLE Userand ADD Nameand  varchar(50);

Uttam Misra · Answer

To add a column to an existing table, the ALTER TABLE syntax is:        
ALTER TABLE table_name
and ADD column_name column-definition;                
For example:        
ALTER TABLE employee
and ADD employee_nameand  varchar(50);                
This will add a column called employee_name to the Employee table.

Amit Singh · Answer

we add the new column in a table by using alter command as
alter table tablename add columnname datatype constraints
alter table tablename add newLocation varchar(30), oldCityName varchar(20)

forum

Alter Table

Jack C

Can you answer this question?

3 Answers

Liked By