What is Truncate in DDL | Data delete | V2V CLASS

Stay tuned and watch the full video.
Don't forget to like, subscribe to our youtube channel. Press the bell icon🔔 so you never miss any update from the v2v class.


TRUNCATE is a DDL(Data Definition Language) command and is used to delete all the rows or tuples from a table. Unlike the DELETE command, the TRUNCATE command does not contain a WHERE clause. In the TRUNCATE command, the transaction log for each deleted data page is not recorded.


DELETE is a DML(Data Manipulation Language) command and is used when we specify the row(tuple) that we want to remove or delete from the table or relation. The DELETE command can contain a WHERE clause. If the WHERE clause is used with the DELETE command then it removes or deletes only those rows(tuple) that satisfy the condition otherwise by default it removes all the tuples(rows) from the table.  Remember that DELETE logs the row deletions.


►Click here to subscribe:-
   / @v2vedtechllp  
Follow us On Social Media:-
►Website of v2v classes - https://v2vclass.com
►Facebook -   / v2vclass  
►Instagram -   / v2vclass  
#v2v #v2vclass #BscIT