Adding a table to a database

To add a table to a database, you can:

• Create a new table based on a description, sample data, or a script

• Clone an existing table

• Import data from a .csv file

Creating a table based on a script, description, or sample data

To create a table based on a description, sample data, or a script:

1. Click Add Table(s).

2. On the Add Table(s) panel, in the Name field, provide a name for the table.

3. To import the structure from a script, in the SQL DDL Script field, paste the script.

4. To display additional options to provide a description and example data, click More Options. Under More Options:

   1. To provide a description, use the Table definition description field. For example, "A list of customers with names, mailing addresses, and telephone numbers." Fabricate uses the description to derive the table columns.

   2. To provide example data, in the Example Data field, paste the data. The example data can use either CSV or JSON format. Fabricate uses the example data to derive the table column.s

5. Click Add Table.

Cloning a 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:

1. Display the table that you want to clone.

2. Click Clone Table.

3. 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 is users_COPY.

4. 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.

To add a table based on an imported CSV file:

1. In the database header, click Import Data.

2. In the Name field, provide the name of the table.

3. To search for and select a file, click Choose File.

4. Click Import Table.