(i) A table, ITEM has been created in a database with the following fields: ITEMCODE, ITEMNAME, QTY, PRICE
(i) 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.
(ii) Categorize following commands into DDL and DML commands?
INSERT INTO, DROP TABLE, ALTER TABLE, UPDATE...SET
7 views
1 Answers
(i) ALTER TABLE Item
ADD (Discount INT);
(ii ) DDL: DROP TABLE, ALTER TABLE
DML: INSERT INTO, UPDATE. ..SET
7 views
Answered