Tag: truncate table

Difference Between DELETE and TRUNCATE Table in SQL Server

Database development, Statements, Tables

Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE...
Read More

Understanding MySQL TRUNCATE TABLE by Practical Examples

Database development, MySQL, Statements, Tables

MySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL table. When we run this command, it drops...
Read More

Workplace Encounters: Reclaiming Space from an Oversized Database

Database administration, Memory Optimization

INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd...
Read More