-
Notifications
You must be signed in to change notification settings - Fork 16
create
Scott C Gray edited this page Feb 26, 2017
·
1 revision
Generates a CREATE TABLE using table definitions
\create [-p] table_name
The \create command generates a CREATE TABLE statement based upon the name of the
table provided on the command line.
The definition of the table is determined by asking the JDBC driver for metadata
information about the table, so the CREATE statement will only be as accurate as
the driver reports. In addition, the current implementation of the \create command
does not include anything other than column names, types, and nullability. That
is, it does not include any primary or foreign key information or check constraints.
Causes the CREATE TABLE statement to just be printed to the screen rather than placing it into the SQL buffer for execution.