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_nameADD column_name datatype
Syntax: Delete a Column
ALTER TABLE table_nameDROP COLUMN column_name
Syntax: Change Column Name
ALTER TABLE table_nameALTER 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_name
ADD column_name datatype

interview

What is the use of Alter Table command in database?

Anonymous User

Can you answer this question?

2 Answers

Liked By