Loading

Show create table

Arjun Panwar

what is SHOW CREATE TABLE command to find out InnoDB's internal label for the field.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Akash Ahlawat15y ago
Shows the CREATE TABLE statement that creates the given table. The statement requires the SELECT privilege for the table. As of MySQL 5.0.1, this statement also works with views.
```
        Table: t Create Table: CREATE TABLE t (   id INT(11) default NULL auto_increment,   s char(60) default NULL,   PRIMARY KEY (id) )   
```