TrainityTrainity
All ideas

2. Statements, Tables & DDL Commands

Instead of modify command, can we not go back and change the previous command? Say for eg: address column has to be changed from 50 to 100 characters. Instead of writing a new command, can we not just change 50 to 100? Why do you write #drop table, #create table before writing the commands, is it mandatory, can you explain the need for that command.