006 Renaming, Truncating and Dropping a Table

You can rename a table using the “RENAME TABLE” statement. Truncating a table means deleting all the data from its rows and columns. You can truncate a table by using the TRUNCATE TABLE statement. Sometimes, tables within a particular database become obsolete and need to be discarded. In such a situation, you can use the DROP TABLE statement to remove a table and all the data related to that table.