126. What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.
DROP…..It will drop the table completely.(all values& table structure)
TRUNCATE……All the values in the table will be deleted.(the structure wont be)
DELETE….Can be use to delete particular row or all values i table.(structure wont be deleted)