# Dynamically defining schema in function with schema macro

**URL:** <https://forum.elixirforum.com/t/dynamically-defining-schema-in-function-with-schema-macro/46813>\
**Category:** Questions\
**Tags:** ecto\
**Created:** [March 25, 2022, 8:01pm UTC](https://forum.elixirforum.com/t/dynamically-defining-schema-in-function-with-schema-macro/46813 "2022-03-25T20:01:48Z")\
**Posts on this page:** 1\
**Showing post:** 12

<div class="post-metadata">

**Author:** ![dimitarvp](https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/dimitarvp/32/38664_2.png) [@dimitarvp](https://forum.elixirforum.com/u/dimitarvp)\
**Post date:** [March 26, 2022, 1:00am UTC](https://forum.elixirforum.com/t/dynamically-defining-schema-in-function-with-schema-macro/46813/12 "2022-03-26T01:00:58Z")

</div>

So you basically have N tables that look exactly like “fields\_in\_common”?

---

_[View the full topic](https://forum.elixirforum.com/t/dynamically-defining-schema-in-function-with-schema-macro/46813)._