# Create From Scratch

This section explains the steps to create a table from scratch.

1. Select the option as shown below and then click **Continue.**

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FQxf4eqoQWxXZnSpy8sfd%2Fimage.png?alt=media&#x26;token=25c34b8a-c7d3-4ec5-b1b0-ef9a796d85f1" alt=""><figcaption><p>Create From Scratch</p></figcaption></figure>

2. The 'Create Table' pop-window opens where you can specify the required details.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FiYE4gtGO31lr1VhsuD9J%2Fimage.png?alt=media&#x26;token=5b3e2fad-5520-424a-abc0-de42ba4d89da" alt=""><figcaption><p>Create Table</p></figcaption></figure>

3. **Select Connection:** Choose from the list of admin or user connections, or [EDITable managed DB](https://docs.inforiver.com/editable/admin-portal-and-editable-console/admin-portal/settings/writeback-settings/editable-managed-db). The supported database connections are mentioned [here](https://docs.inforiver.com/editable/introduction-to-editable/supported-database-connections).

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FMPFXoc53vwxKzGZ8Xlh0%2Fimage.png?alt=media&#x26;token=35af5a6c-d6e3-4f15-9f70-61ada454ba99" alt=""><figcaption><p>Select connection</p></figcaption></figure>

4. If you do not want to choose any of the existing connections and would like to add a new connection, click on **Add Connection.** To learn more on adding a connection, refer to [this page](https://docs.inforiver.com/editable/admin-portal-and-editable-console/admin-portal/settings/writeback-settings/add-and-manage-connections).

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2F4z2SFlF1zmO3LLWXwTEM%2Fimage.png?alt=media&#x26;token=a3911ef3-9792-4260-b6fa-ce3bc9eab56f" alt=""><figcaption><p>Add connection</p></figcaption></figure>

5. **Table Name:** Enter a name for your table.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2F6pg8ikkQbJYLMfFM9wbF%2Fimage.png?alt=media&#x26;token=1b35ed76-8c49-4445-8d06-8a35d698b82b" alt=""><figcaption><p>Table name</p></figcaption></figure>

6. **Column Details:** Start creating your table by adding the column name, primary key, and other relevant details like length, precision, etc. wherever applicable.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FVzYwLvekynAPJ7wzW09h%2Fimage.png?alt=media&#x26;token=74d96c3d-c8d8-45f0-8fd6-5f45a27f6221" alt=""><figcaption><p>Add Column details</p></figcaption></figure>

7. **Add Column:** Click on '+ Add Column' at the top of the 'Column Details' table to add a new field/column.&#x20;

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FpGirReObrljzFz083DgW%2Fimage.png?alt=media&#x26;token=f50765f8-6c6e-4892-9932-2ce8897cf5ac" alt=""><figcaption><p>Add Column</p></figcaption></figure>

8. **Advanced Properties:** Check this option to add advanced properties to the column such as Display Name, Thousands Separator, Prefix and Suffix.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FDBUXqwwx8n1YMLwIfNNI%2Fimage.png?alt=media&#x26;token=bad96994-44ee-4704-aea1-ee5932a9ddbf" alt=""><figcaption><p>Advanced Properties</p></figcaption></figure>

9. Click the **bin icon** as shown below if you want to delete that column.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FIzve9CSokPdtkhcsV7Gs%2Fimage.png?alt=media&#x26;token=bc4e8fa4-82fb-4c48-a882-303e0a58f9a8" alt=""><figcaption><p>Delete a column</p></figcaption></figure>

10. You can click on **Preview** if you wish to view the SQL query generated which will be used to create a new table in the chosen destination.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FGQbM8TAEh3rCurjtZl4s%2Fimage.png?alt=media&#x26;token=56ed7516-5819-41aa-8f80-be202d7b2a4a" alt=""><figcaption><p>Preview Query</p></figcaption></figure>

11. Click **Apply** after entering all the column details.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2F6yWWIE14xdSuuX8Zr7Cs%2Fimage.png?alt=media&#x26;token=a7b442e2-cb9f-4a3e-a513-ef4051d38bf7" alt=""><figcaption><p>Click 'Apply'</p></figcaption></figure>

You can now download a pre-configured Power BI report (.pbix file) with a live connection to the table.&#x20;

{% hint style="info" %}
After downloading the .pbix file, you might get a few pop-up messages:

* Click 'Apply changes' to apply any pending changes to the queries.
* Close the 'Pause visuals' suggestion tip that appears below. **Do not pause the visuals** so the live changes get synced to the database.
* Save the .pbix report at regular intervals after making any changes to avoid loss of data.
  {% endhint %}

After creating a table, you can proceed to the next step: [managing columns](https://docs.inforiver.com/editable/working-with-editable/manage-columns), to configure them, and then you can start working on your data.

If you already have an existing database, you can directly connect to it and start working on it. This is explained in the next section.