How can you add and remove any column of a table?
The syntax for adding any column in an existing table is shown below.
1 | ALTER TABLE table_name ADD COLUMN column_name column_definition [FIRST|AFTER existing_column] |
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.