How can Oracle delete multiple table fields?

2 years ago
Noah Thompson
1 minute

To delete multiple table fields, you can use the ALTER TABLE statement to delete them all at once. For example, to delete two fields in a table, you can follow the format below:

ALTER TABLE table_name
DROP COLUMN column1,
DROP COLUMN column2;

In the code above, table_name refers to the name of the table being manipulated, while column1 and column2 represent the names of the fields to be deleted. Following the example above, executing this ALTER TABLE statement will result in the removal of the column1 and column2 fields from the table.

bannerAds