Question

A SQL table ITEMS contains the following columns:

INO, INAME, QUANTITY, PRICE, DISCOUNT

Write the SQL command to remove the column DISCOUNT from the table.

Answer 1

ALTER TABLE ITEMS DROP COLUMN DISCOUNT;

Explanation:

Alter is a DDL command in SQL that allows us to change the table's structure.