show create table

lucycodes42

The & operator sets the cursor to the first line of the table in the database. The [USER_INPUT:2] section defines the input for the SHOW CREATE TABLE statement. The first parameter is the name of the table, and the second parameter is the string SHOW CREATE TABLE. The code will display the CREATE TABLE statement for the table named table.

Shortcut: s_hcreate

SHOW CREATE TABLE `table`;