Question

how do u modify the colum name and width for existing table​

Answer 1

Answer:

Syntax(Oracle,MySQL,MariaDB): ALTER TABLE table_name RENAME TO new_table_name;

Columns can be also be given new name with the use of ALTER TABLE. Syntax(Oracle): ALTER TABLE table_name RENAME COLUMN old_name TO new_name;

Syntax(MySQL,MariaDB): ALTER TABLE table_name CHANGE COLUMN old_name TO new_name;

Answer 2

Alter- syntax

"ALTER TABLE `table_name`" is the command that tells MySQL server to modify the table named `table_name`.

"ADD COLUMN `column_name` `data_type`" is the command that tells MySQL server to add a new column named `column_name` with data type `data_type