Saved Bookmarks
| 1. |
Write note on delete command ? |
|||||
|
Answer» DELETE COMMAND The DELETE command permanently removes one or more records from the table. It removes the entire row, not individual fields of the row, so no field argument is needed. The DELETE command is used as follows : DELETE FROM table-name WHERE condition; For example to delete the record whose admission number is 104 the command is given as follows: DELETE FROM Student WHERE Admno=104;
The following record is deleted from the Student table. To delete all the rows of the table, the. command is used as : DELETE * FROM Student; The table will be empty now and could be destroyed using the DROP command. |
||||||