> ## Documentation Index
> Fetch the complete documentation index at: https://docs.xano.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Get Database Schema

You can use the Get Database Schema function to retrieve all of the schema in JSON format for a particular table.

<Frame>
  <img src="https://mintcdn.com/xano-997cb9ee/RVHCrB1RJjFkWEmQ/images/18686235-image.jpeg?fit=max&auto=format&n=RVHCrB1RJjFkWEmQ&q=85&s=ad0844cdabac5d411659c431eecdd003" width="592" height="484" data-path="images/18686235-image.jpeg" />
</Frame>

You can use the Path option to only get a specific field from the database if you don't need the entire table delivered.

This function is great for scenarios where you need your APIs to react based on a table's schema, or you need to provide option lists (an enum field) to a front-end connection.


## Related topics

- [Database Operations](/xanoscript/function-reference/database-operations.md)
- [Retrieve the complete schema definition for a database table](/api-reference/table-schema/retrieve-the-complete-schema-definition-for-a-database-table.md)
- [Replace the entire schema definition for a database table](/xano-features/metadata-api/instance_api/replace_the_entire_schema_definition_for_a_database_table.md)