How do I add a new columns without disturbing any users that are currently using that table?
I think drop command is applicable only if all users are disconnected from the table.
Thanks.
Manuals are your friends. Look it up in the manual of your database.