Question

A customer table is created with cno,cname, and address columns. Evaluate the following statement whether it is correct or not?

Delete cname from customer;

Answer 1

The statement is incorrect. DELETE removes rows, not columns. To remove a column, use:

ALTER TABLE customer
DROP COLUMN cname;