Using this statement you can remove all data of rows or column ( complete data ) not table. In this there is no where clause but where clause is available in Delete statement. Truncate table is faster ...
DELETE comes under DML(Data Manipulation Language). DELETE can be used to delete a particular row by using WHERE clause. It is slower than TRUNCATE as it keeps logs. Rollback is possible when used ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback