How to delete multiple table columns in db2?

1 year ago
Ava Mitchell
1 minute

To delete multiple table fields, you can use the ALTER TABLE statement.

For example, to delete two fields in the table, you can use the following syntax:

ALTER TABLE table_name
DROP COLUMN column_name1,
DROP COLUMN column_name2;

Please make sure to back up your data before proceeding with this operation as deleting the field will result in data loss.

bannerAds