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.
Change View Switch to a saved database view.
Search Perform a simple text search across all your records
Filter Filter your database 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.
Referenced By Referenced By will show you all of the places your database table is referenced in Xano -- any tasks, functions, or API endpoints that perform a database action on this table will be shown here and you can navigate to them.
Show Schema 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.
View Keyboard Shortcuts This is the list of keyboard shortcuts you can use in the database table.
Undo / Redo Undo or redo your last edit on the database. Right-click on these icons to show a list of the undo / redo history and move directly back to a specific point.
Refresh Refresh the database view
Copy / Paste Copy / paste data inside your database table. You can also paste data from external spreadsheets.
Additional Options (ellipsis in the top-right corner)
  • Settings
    • Edit the table name, description, and authentication options. You can also delete the table from here.
  • Security
    • Edit the GUID of the database table (for advanced users only)
  • Versions
    • View and restore previous versions of database schema -- this does not restore lost data.
  • Auto-complete
    • Modify the data that is displayed from this table in table reference fields. See this section of our documentation for more information.
  • Clear All Records
    • Remove all records in the database. You can also select an option at the bottom of the panel to reset the record IDs back to 1.
  • Clone Table
    • Clones the schema to a new table
  • Export CSV
  • Import CSV
    • Imports a CSV to an existing table. If your CSV has a primary key specified, and that primary key matches the primary key of records that already exist in your database (this is typically the ID field), you can use this to bulk edit records.

Column Controls

Click on a column header and a dropdown will appear.
  • Hide
    • Hides this field from the database view
  • Filter
    • Filters the current view by this column
  • Rename
    • Renames the column. This will result in data loss -- if you need to retain the data, please copy it to a new column instead.
  • Change Type
    • Changes the data type of the column. This will also usually result in data loss, so please plan accordingly.
      • When changing type, if you choose Integer, you can link a table to this column and turn it into a table reference field.
      • Structure: one value per record or multiple values per record
      • Nullable: determine if the field should allow null values
  • Insert Column After
    • Inserts a column next to the one selected
  • Settings
    • Description
      • Add a description to the field
    • Default Value
      • Add a default value to be populated when that field is blank
    • API Access
      • Determines the visibility of the field in API requests. See this section of our documentation for more information.
    • Required
      • Enforces at the database level whether or not this field is required in each record
    • Filters
      • Enforces certain data restrictions or manipulation at the database level, such as "this field must contain at least 1 number".
      • Please note that these filters are only enforced when data is added or changed via your function stacks. You can still add data manually that does not conform to the filters you have set.