Xano Documentation

Database controls

The Database table page contains multiple controls to make it easy for you to create, edit, and view your tables. Let's go over these controls.
Search Perform a simple text search across all your records
Sort Sort your records by multiple columns and asc/desc orders
Hide Fields Clicking on this shows a list of the different columns of the Database table. There is a toggle on the right that can be used to hide columns from the view.
Show JSON This is the way your Database table is represented in JSON.
Indexes Indexing is a way of sorting a number of records on multiple fields. You can read more about Indexes here.
API Endpoints This is the list of API Endpoints that are associated with this Database table.
5. More Actions(ellipsis icon): This is a drop-down with one action(for now). Keyboard Shortcuts: This is a list of the current keyboard shortcuts that are used to manipulate the Database table spreadsheet.
There are additional controls under the More Actions(ellipsis icon) in the upper right.
Settings: In the Table Settings, you can edit the Title, the description, and the Authentication of the table. You can also delete the table. Title: name of the table. Description: internal description about the table. Authentication: disabled(default) or enabled. If this is enabled then any time the table is accessed, users can be authenticated by using information stored in that database. Trash icon: delete the table.
There are Column controls as well. Click on a Column header and a dropdown will appear. Hide: Hide can toggle the visibility of the Column. Rename: Rename can be used to change the name of the Column.
Change Type: Change type can be used to change the Data Type and structure.
Settings: Settings can be used to change the description, API access(public, private, internal), can be nullable (yes/no), and is required(yes/no).
Delete: Delete can be used to delete the Column.
Filters: Filters can be used to specify requirements for the data stored inside the selected field. This can include things like minimum number of symbols, which are typically used for enforcing password requirements. Note: these filters are only enforced in the function stack -- you can still add data manually that does not conform to these filters.