Tag: truncate table

Difference Between DELETE and TRUNCATE Table in SQL Server

11:01 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

17:04 Database development, 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

13:02 Database administation, Memory Optimization

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