Question

What is the function of ALTER command?

Answer 1

SQL ALTER TABLE Statement. The SQL ALTER TABLE command is used to modify the definition (structure) of a table by modifying the definition of its columns. The ALTER command is used to perform the following functions.

Answer 2

Answer:

The ALTER command is used for modifying the existing database, tables, its views or any other database objects. The alter syntax will be as follows,

ALTER Table - name ADD COLUMN col - name ‘data type’;

Here the alter table is the command which is used for referring the MYSQL server to modify the table name, by adding new column of given data type. Here two commands are used one is Alter and second is add.