SQL – Rename Table Table of content SQL provides two ways to rename an MySQL table. You can use either SQL RENAME TABLE or ALTER TABLE statement to change a table name in MySQL RDBMS. The SQL RENAME TABLE Statement You can change a MySQL table name using SQL RENAME TABLE statement. Syntax Following is […]

SQL – Clone Tables Table of content There may be a situation when you need an exact copy of a table with the same columns, attributes, indexes, default values and so forth. Instead of spending time on creating the exact same version of an existing table, you can create a clone of the existing table. […]

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 […]