Skip navigation links
4.6.8.9 SHOW WARNINGS | ERRORS »
Section Navigation      [Toggle]

4.6.8.8. SHOW CREATE TABLE

Exibe uma instrução CREATE TABLE que irá criar a seguinte tabela: 

mysql> SHOW CREATE TABLE t\G
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE t (
  id INT(11) default NULL auto_increment,
  s char(60) default NULL,
  PRIMARY KEY (id)
) TYPE=MyISAM

SHOW CREATE TABLE cita os nomes de colunas e tabelas de acordo com o valor da opção SQL_QUOTE_SHOW_CREATE. Secção 5.5.6, “Sintaxe de SET”.

This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.