UGC NET 2018 :
________ command is used to remove a relation from an SQL database.
(b) Delete table
(c) Update table
(d) Drop table
Solution:
The drop table command is used to delete a table and all rows in the table.
DROP TABLE student;
The DELETE statement is used to delete existing records in a table.
DELETE FROM Student WHERE Name= ‘Kunal’;
The UPDATE statement is used to modify the existing records in a table.
UPDATE Student
SET Name = ‘Kunal’, City= ‘Burhanpur’
WHERE RollNumber= 1201;