A table, ITEM has been created in a database with the following fields:
ITEMCODE, ITEMNAME, QTY, PRICE
Give the SQL command to add a new field, DISCOUNT (of type Integer) to the ITEM table.
Answer
ALTER TABLE Item
ADD (Discount INT);
![Slide43.JPG](https://d1avenlh0i1xmr.cloudfront.net/c2a02491-17be-4958-a5fa-db8621ec7ad4/slide43.jpg)
![Slide44.JPG](https://d1avenlh0i1xmr.cloudfront.net/450d52d2-9b28-40c5-a47a-fe17c24b7385/slide44.jpg)
CBSE Class 12 Sample Paper for 2022 Boards [Term 2] - Computer Science
CBSE Class 12 Sample Paper for 2022 Boards [Term 2] - Computer Science
Last updated at April 16, 2024 by Teachoo
Answer
ALTER TABLE Item
ADD (Discount INT);