Question

Delete Command in database.

Answer 1

In order to delete one or more tuples, DELETE command is used. If we want to delete the tuple for Teacher with ID=101 the command would be: 

DELETE FROM Teacher 
WHERE Teacher_ID=101; 

If the WHERE clause is missing then it will delete all the tuples in a table as shown below: 

DELETE FROM Teacher;