Delete may use with SQL operators as well as subqueries to delete any or all rows that apply to our conditional.
Syntax
DELETE * FROM employees;
Note:The above example delete each row from employees table
SQL Truncate statement
Truncate removes all the rows from the table and cannot be Rollbacked, while delete removes all or specific rows from table and can be rollbacked.
Truncate is used for HUGE databases & Delete will work efficiently on small database table.
Syntax:
TRUNCATE TABLE employees;
Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
