11. DELETE VS DROP VS TRUNCATE IN SQL | SQL TUTORIAL

DELETE vs DROP vs TRUNCATE in SQL: What's the Difference?
In this video, understand the key differences between DELETE, DROP, and TRUNCATE commands in SQL! 🗑️⚠️

✅ DELETE: Removes specific rows from a table based on conditions. You can control what to delete using the WHERE clause.

✅ DROP: Removes the entire table or database, including all its data and structure.

✅ TRUNCATE: Quickly removes all rows from a table but keeps the structure intact for future use.

Want more similar videos- hit like, comment, share and subscribe

❤️Do Like, Share and Comment ❤️
❤️ Like Aim 5000 likes! ❤️

➖➖➖➖➖➖➖➖➖➖➖➖➖

Please like & share the video.
script

CREATE TABLE EMPL (
ID INT,
NAME VARCHAR (17),
SALARY INT,
LOCATION VARCHAR(17),
DEPT VARCHAR(17)
)

INSERT INTO EMPL VALUES (1,'MANISH', 900000,'INDIA','SDE')
INSERT INTO EMPL VALUES (2,'RANI', 1000000,'INDIA','SDE2')
INSERT INTO EMPL (ID ,NAME,SALARY,DEPT) VALUES (3,'RAJ', 700000,'SALES')
INSERT INTO EMPL(ID ,NAME,SALARY,DEPT) VALUES (4,'RAHUL', 600000,'HR')
➖➖➖➖➖➖➖➖➖➖➖➖➖

Azure data factory :

PYSPARK PLAYLIST -

➖➖➖➖➖➖➖➖➖➖➖➖➖
📣Want to connect with me? Check out these links:📣

➖➖➖➖➖➖➖➖➖➖➖➖➖
what we have covered in this video:

➖➖➖➖➖➖➖➖➖➖➖➖➖

Hope you liked this video and learned something new :)
See you in next video, until then Bye-Bye!

➖➖➖➖➖➖➖➖➖➖➖➖➖