Skip to main content Link Menu Expand (external link) Document Search Copy Copied

SHOW CREATE TABLE statement

Output the data definition language (DDL) CREATE TABLE statement for a specified FeatureBase table.

BNF diagram

expr

Syntax

SHOW CREATE TABLE table_name;

Arguments

Argument Data type Description
table_name String Name of existing FeatureBase table

Returns

Column name Data type Description
ddl String DDL for CREATE TABLE statement

Examples

Show DDL for sample data skills table

The skills table is created automatically when a user chooses to create a Database with pre-loaded sample data.

SHOW CREATE TABLE skills;

Returns:

ddl
"create table skills (_id string, bools stringset, bools-exists stringset, id int, skills stringset, titles stringset, doctest int);"