# Create table by Spec: Node or Workflow ?

**URL:** <https://forum.knime.com/t/create-table-by-spec-node-or-workflow/27471>\
**Category:** KNIME Analytics Platform\
**Created:** [September 18, 2020, 6:18am UTC](https://forum.knime.com/t/create-table-by-spec-node-or-workflow/27471 "2020-09-18T06:18:50Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [September 18, 2020, 8:23am UTC](https://forum.knime.com/t/create-table-by-spec-node-or-workflow/27471/2 "2020-09-18T08:23:06Z")

</div>

Of course you could just create a KNIME tase from scratch and define the types of the columns - or if you have an existing file you could just use that and remove all lines with data …

And then you might create a Table in a SQL database like H2 from code and then bring that to KNIME. If you are into coding.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/d/9/d9e4f7327869ffab62dfa79feeacfa3ed24df089.png)

> **[Example how to use H2 database to create table with upload and from scratch –...](https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_db_h2_create_table_from_scratch)**
>
> Example how to use H2 database to create table with upload and from scratch

---

_[View the full topic](https://forum.knime.com/t/create-table-by-spec-node-or-workflow/27471)._
