Viewing Table Creation Statements

Function

This statement is used to show the statements for creating a table.

Syntax

1

SHOW CREATE TABLE table_name;

Keyword

CREATE TABLE: statement for creating a table

Parameters

Precautions

The table specified in this statement must exist. Otherwise, an error will occur.

Example

1. Create a table. For details, see Creating an OBS Table or Creating a DLI Table.

1. Run the following statement to view the statement that is used to create table test:

   1	SHOW CREATE TABLE test;