CBSE · 083Class XII · 2022Section B1 mark
Question 9i
7 June 2022 · Computer Science (083)
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
ALTER TABLE ITEMS DROP COLUMN DISCOUNT;
Explanation
Uses ALTER TABLE to modify the structure and DROP COLUMN to remove the specific column.