How to Delete a column and Add a new column to database
The following query is executed for add and delete a column in a table-
for drop a column-
alter table [table name] drop column [column name];
for add a column in a table-
alter table [table name] add column [new column name] varchar (20);
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.