How to see create table definition of a table in mySQL or mairaDB

Sometime you need to see the definition of table in Mysql or mairadb to understand the data types which the table is using for different columns to store the data OR you might need to create a new table exactly like the one you have already created, To see the definition of table in mairadb or mysql, you can use below statement.

MySQL > show create table TableName;

1 comment: