Author Archives: user

MySQL − Show Tables Table of content MySQL Show Tables Statement In MySQL, we use the SHOW TABLES command to retrieve the names of tables that are present in a specific database. This command is useful in various situations, such as: When we want to view names of tables present in a database to verify […]

MySQL – Rename Tables Table of content There can be a situation where both users and database administrators might want to change the name of a table in a relational database to make the table”s name more suitable for a specific situation. MySQL provides two different ways to rename an MySQL table. We can use […]

MySQL – ALTER Command Table of content MySQL ALTER Command The MySQL ALTER command is used to modify the structure of an existing table. It allows you to make various changes, such as adding, deleting, or modify columns within the table. Additionally, the ALTER command is also used to add and drop different constraints associated […]