14.Delete vs Drop vs Truncate Sql Server in Telugu
#SqlServerTelugu #LearnersPage #SQLTELUGUTUTORIALS
The difference between TRUNCATE, DELETE, and DROP is one of the most common interview questions. TRUNCATE, DELETE, and DROP SQL queries are often used in SQL Server to delete data from a database. Learn the difference between truncate and delete in this video.
TRUNCATE is a DDL command
TRUNCATE is executed using a table lock and the whole table is locked to remove all records.
We cannot use the WHERE clause with TRUNCATE.
TRUNCATE removes all rows from a table.
DELETE is a DML command.
DELETE is executed using a row lock, each row in the table is locked for deletion.
We can use where clause with DELETE to filter & delete specific records.
The DELETE command is used to remove rows from a table based on WHERE condition
The DROP command removes a table from the database.
All the tables' rows, indexes, and privileges will also be removed.
No DML triggers will be fired.
The operation cannot be rolled back.
DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command.
SQL SERVER IN TELUGU:
@Learnerspage t.me/Learnerspage follow us on Telegram
https://t.me/Learnerspage
Must know about what's in SQL before your Interview .
Data Warehouse in Telugu
• Data Warehouse in Telugu
ETL and SSIS : • SSIS in Telugu :SQL Server Integration Se...
Tableau in Telugu: Tableau Colors
• 4.Tableau in Telugu: Tableau Colors
EXCEL IN TELUGU: FETCH DATA FROM SQL TO EXCEL
• EXCEL IN TELUGU: IMPORT DATA FROM SQL T...
BIGDATA in TELUGU
• BIGDATA in TELUGU
Tableau in Telugu: Import data from Excel
• 2.Tableau in Telugu: Import data from Exc...
Pareto Chart Analysis Excel in Telugu
• Pareto Chart Analysis Excel in Telugu