Difference Between Truncate Vs Delete Vs Drop in SQL Server

Welcome to SQL Server, Interview question series. In this vLog, we will talk about What is difference between Truncate, Delete and Drop Command in SQL Server.

This is the most favorite interview question while you are preparing for SQL Server Interview.

In this vLog we will be covering following things
- What is Truncate Command? How to use this with the help of example?
- What is Delete Command? How to use this with the help of example?
- What is Drop Command? How to use the command in Example?

The Question covers the answer with the example, where first we will be discussing how to use the Truncate command , Deleted command and Drop Command and how to these with the help of example. After that we will summarize the difference point.

The main purpose of this SQL Interview Question series is you can answer – point to point answer to the interviewer for asked questions.
Share your question and experience with me in the comment section.

#SQLServer
#InterviewQuestion
#SQLServerInterview
***************
Contact me for any Questions, Consulting Service or Development Service:
Whatsapp: [phone]

[muskanattar]

Explained in very simplest way 😊easy to understand 👍 Thank you 🙂

[anlithsimha]

Very good information. Can you make on
1)diff bw Temp table, Table variable and CTE
2)what is recursive cte and non recursive cte

[prple]

If we do delete from employe it will delete all the records. Will schema stay or delete?

[parikshitwairagade]

You said we can rollback truncate operation so how can we do that tell me please

[smrutiranjanpardhi]

drop table command transaction main dalke to dekh sab rollback hota hai. like if you all agree