Category Archives: sql

SQL – Show Tables (Listing Tables) Table of content There are several instances when you need to retrieve a list of tables from your database. This could be done for testing purposes, to identify any existing tables before adding or removing any, or for any other reason. This tutorial will discuss how we can list […]

SQL – Rename Database Table of content There can be several reasons to rename a database name. One of the reasons could be to avoid naming conflicts or to separate different types of data into different databases. Another reason can be to arrange them in an organized way which makes them more descriptive and easier […]

SQL – TRUNCATE TABLE Table of content SQL provides command to TRUNCATE a table completely in one go instead of deleting table records one by one which will be very time consuming and cumbersome process. The SQL TRUNCATE TABLE Statement The SQL TRUNCATE TABLE command is used to empty a table. This command is a […]