# Is there a per table / per database way to store the database by per directory?

**URL:** https://forum.scylladb.com/t/is-there-a-per-table-per-database-way-to-store-the-database-by-per-directory/2358
**Category:** ScyllaDB
**Tags:** data-model
**Created:** [July 26, 2024, 2:19am UTC](https://forum.scylladb.com/t/is-there-a-per-table-per-database-way-to-store-the-database-by-per-directory/2358 "2024-07-26T02:19:46Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Kolin\_Fluence](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/kolin_fluence/32/456_2.png) [@Kolin\_Fluence](https://forum.scylladb.com/u/Kolin_Fluence)
#### Post date: [July 26, 2024, 2:19am UTC](https://forum.scylladb.com/t/is-there-a-per-table-per-database-way-to-store-the-database-by-per-directory/2358/1 "2024-07-26T02:19:46Z")

</div>

e.g. 1 db or 1 table stores in 1 database folder or 1 table folder.  
if i want to delete a database / table, i can just delete the folder

---

<div class="post-metadata">

### Author: ![felipemendes](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/felipemendes/32/11_2.png) [@felipemendes](https://forum.scylladb.com/u/felipemendes)
#### Post date: [November 4, 2024, 5:21pm UTC](https://forum.scylladb.com/t/is-there-a-per-table-per-database-way-to-store-the-database-by-per-directory/2358/2 "2024-11-04T17:21:12Z")

</div>

> [@Kolin\_Fluence](#):
>
> if i want to delete a database / table, i can just delete the folder

You should definitely not do that, you should `DROP` it before-hand.

> e.g. 1 db or 1 table stores in 1 database folder or 1 table folder.

Kinda. `workdir` specifies which folder the database will use to store its files (commitlog, hints, etc). Although unusual, there’s nothing preventing you from creating different filesystems on a directory basis. I didn’t test it, but you should be able to assign a different filesystem to different keyspaces, tables are a bit different as they require assigning a random UUID at creation time.
