How to add and remove columns from an existing table in the database?

Question

Ashutosh Kumar Verma · Answer

SQL Add column in existing Table :
and  and  To Add a column in existing table in SQL database we can use SQL ALTER command. The following SQL statement is used to Add a column in existing table.
Lets take a database table 'Student',
and  and 
Now, the following SQL Statement is used to add a Column 'stuMarks' in above table,
ALTER TABLE Student
ADD stuMarks int;
Remove Column from existing table :
and  and  To remove a column from existing database table, used SQL ALTER command. The following SQL statement is used to remove or delete a column 'stuMarks' from existing above table,
alter table Student
drop column stuMarks;
In the above example 'stuMarks' column is deleted successfully.

forum

How to add and remove columns from an existing table in the database?

Ravi Vishwakarma

Can you answer this question?

1 Answers

Liked By