Adding a table to a database
To add a table to a database, you can:
Create a completely new table
Clone an existing table
Import data from a .csv file
Creating a completely new table
To create a table:
Click Add Table(s).
On the Add Table(s) panel, in the Name field, provide a name for the table.
Optionally, in the Schema Definition text area, provide one of the following to define the table schema:
SQL DDL script
OpenAPI spec
Content from another type of script or definition file, such as a JSON or XML schema or a DTD. The Fabricate AI then attempts to interpret the information and then use it to set up the table.
A prompt that describes the table. For example, "Create a table that tracks customers, including the mailing address, email address, and telephone number". The Fabricate AI uses that as the basis to set up an initial version of the table.
Click Add Table.
Cloning an existing table
You can also create a clone of an existing table. The clone is created with the same columns and data as the original table. You can then adjust the table configuration.
To add a table that is a clone of an existing table:
Display the table that you want to clone.
Click Clone Table.
On the clone panel, in the New Table Name field, provide the name for the new table. By default, the table name is
<table_name>_COPY. For example, if you clone the users table, the default name isusers_COPY.Click Clone Table.
Creating a table from imported data
You can create a table from an imported CSV file. Fabricate uses the file to determine the table columns and data types, and to populate the table data.
To add a table based on an imported CSV file:
In the database header, click Import Data.
In the Name field, provide the name of the table.
To search for and select a file, click Choose File.
Click Import Table.
On the table details, Fabricate indicates that the table data came from a file. It marks the columns as having come from the source file.
Last updated