MySQL – Drop Tables Table of content The MySQL DROP TABLE statement The MySQL DROP TABLE statement is a Data Definition Language (DDL) command that is used to remove a table”s definition, and its data, indexes, triggers, constraints and permission specifications (if any). In simple terms, this statement will delete the entire table from the […]
Author Archives: user
MySQL – Rename Columns Table of content The ALTER TABLE statement in MySQL can be used to change the structure of a table. For instance, we can add, delete, or rename the columns, etc. using this statement. Following are the two options that can be used with the ALTER TABLE statement to rename a column(s) […]
MySQL – Show Columns Table of content MySQL Show Columns Statement To retrieve entire information of a table, we use DESCRIBE, DESC or SHOW COLUMNS statements. All of these statements of MySQL can be used to retrieve/display the description of all the columns of a table, as they all retrieve the same result-sets. Obtaining column […]