SHOW CREATE TABLE statement
Output the data definition language (DDL) CREATE TABLE statement for a specified FeatureBase table.
BNF diagram
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 |
Additional information
- Run
SELECT * FROM fb_table_ddlto output all table DDL
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);"