What is the use of Alter Table command in database?

Question

Anonymous User · Answer

The SQL ALTER TABLE command is used to add, delete or modify columns in an existing table.

Use of ALTER command in database

Alter command is used for change the column name, add column, add constraint, and change the datatype.

Syntax: Add Column name

ALTER TABLE table_name

ADD column_name datatype

Syntax: Delete a Column

ALTER TABLE table_name

DROP COLUMN column_name

Syntax: Change Column Name

ALTER TABLE table_name

ALTER COLUMN column_name datatype

Pushpendra Singh · Answer

The ALTER table command is used to add, delete, or modify columns in an existing table.To add a column in a table, use the following syntax:ALTER TABLE table_nameADD column_name datatype

interview

What is the use of Alter Table command in database?

Can you answer this question?

2 Answers