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 an OBS or DLI table, for example, test. For details, see Creating an OBS Table or Creating a DLI Table.
2. Run the following statement to view the statement that is used to create table test:

   1	SHOW CREATE TABLE test;