sivakumar

• Feb 28th, 2006

 

Alter is a DDL command which is used to change the structure of the table.We cant add a new row using the alter,but we can do with insert which is a DML command.

rupal

 Profile Answers by rupal Questions by rupal

• Mar 3rd, 2006

 

Alter table is DDL language which is allow us to edit table schema. The syntax is following: alter table <tablename> <add/subtract/modify> <column_name> <datatype(length)>;

pawan ahuja

 Profile Answers by pawan ahuja 

• Mar 21st, 2006

 

Hi,

Alter is a ddl statement thru which we can modify the datatype add the column etc.

only insert is command thru whic u can be insert the data.

Regards

Pawan Ahuja

na123

 Profile Answers by na123 Questions by na123

• Mar 24th, 2006

 

Alter table is a DDL language.we cannot insert a new row thr' alter command but we can add new column thr' Alter command.

Abdul Mannan

• May 28th, 2006

 

to insert a column in a table dml command should be used i.e., INSERT. A column cannot inserted in a table through ALTER command - only the data in a table is modified thru alter.

sandeep dasari

• Jul 6th, 2006

 

by using alter table we can alter only column not the rows. by using alter  command we write query like this........

alter table table_name add column_name datatype;

for drop that column ;

alter table table_name  drop column_name datatype;

it's the answer.