Computer Science, asked by himanshufogat74, 9 months ago


What is the difference between ADD and MODIFY clauses in the ALTER TABLE
command.

Answers

Answered by ayushmedicare1
0

Answer:

tehe age is the tyuwohbf

Answered by AskewTronics
1

Difference in Add and Modify in the Alter table:

Explanation:

  • ADD: The Add is used with the Alter table command which is used to add the column on the exiting table. The syntax to do this is:-"Alter table table_name add column_name data type(size);".
  • Modify: The modify is also used with the Alter table command which works is to modify the existing column size with the new column size in the exiting table. The syntax to do this is :"Alter table Table_name modify exiting_column_name exiting_size new_size".

Learn More:

  • SQL Command : https://brainly.in/question/8751693
Similar questions