> ## 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.
# Tables And Schema
The following are various examples of how to leverage the Metadata API to create and modify database tables including the schema and indexes included within them.
### Get Workspaces
Browse the workspaces of the instance. This API endpoint does not require any parameters. Retrieving the workspaces gives you information on the workspace name and ID. The workspace ID is particularly important for use in other Metadata API endpoints.
Example response body:
```json theme={null}
[
{
"id": 1,
"name": "my workspace 1",
"description": ""
},
{
"id": 3,
"name": "test",
"description": ""
},
{
"id": 2,
"name": "to do app",
"description": "my to do app example"
}
]
```
### Get Tables of a Workspace
Browse workspace tables. This API endpoint requires a workspace ID and will provide various information about each database table in a workspace, including database table ID, which is needed in various Metadata API endpoints.
Example response body:
```json theme={null}
[
{
"id": 7,
"created_at": "2023-04-12 22:00:38+0000",
"updated_at": "2023-04-12 22:00:42+0000",
"name": "category",
"description": "",
"guid": "yu2eB8E0dSEtL6MbBPzzJUM06gA",
"auth": false
},
{
"id": 8,
"created_at": "2023-04-12 22:00:51+0000",
"updated_at": "2023-04-12 22:01:07+0000",
"name": "items",
"description": "",
"guid": "eP9O-rD-7sGKpbLOEhdED6YGrmA",
"auth": false
},
{
"id": 1,
"created_at": "2022-03-24 20:20:26+0000",
"updated_at": "2022-03-24 20:20:26+0000",
"name": "user",
"description": "",
"guid": "nTOiqqb31ecz1Te6v_3YMkfp5xc",
"auth": true
}
]
```
### Create Table and Add Schema One by One
First, create a new table in the desired workspace. The default request values suffice. In this example, first, we will create a table and then add schema individually. The Metadata API is capable of adding schema in bulk but that will be covered in another example.
Example response body:
```json theme={null}
{
"id": 9
}
```
Taking the newly created database table ID, we can add schema 1 by 1 to the table.
1. A text field called name.
Example response body:
```json theme={null}
{
"name": "name"
}
```
Next, let's add an integer field called score with a default value of 30
As we execute these Metadata API calls, our new table in Xano is being created along with the new schema, one by one.
### Create an Index
The Metadata API gives control over indexes on database tables. In this example, let's create a Unique Index on the name field of new table 123.
Example response body:
```json theme={null}
{
"id": "baa524c4"
}
```
The API responds with the ID of the index. In Xano, we can see the index has been created:
### Create Table with Schema and an Index in One Call
In this example, we will create a new database table along with schema and an index in the same API call. The Metadata API is flexible enough to accommodate this method.
Here's the example request body:
```json theme={null}
{
"name": "new stuff",
"description": "",
"auth": null,
"guid": null,
"schema": [
{
"name": "id",
"type": "int",
"description": "",
"nullable": false,
"default": "",
"required": true,
"access": "public",
"style": "single"
},
{
"name": "created_at",
"type": "timestamp",
"description": "",
"nullable": false,
"default": "",
"required": true,
"access": "public",
"style": "single"
},
{
"name": "name",
"type": "text",
"description": "",
"nullable": false,
"default": "",
"required": true,
"access": "public",
"style": "single"
}
],
"index":[
{
"type": "btree",
"fields": [
{
"name": "name",
"op": "desc"
}
]
}
]
}
```
This creates a new table called "new stuff" with three fields: id, created\_at, and name with an index on the name field.
For defining schema, the Metadata API needs a minimum of "name" and "type" but the other fields aren't required. If you are defining schema during table creation, the first field must be the ID field.
For Request body examples of schema and index, check out the PUT examples in Swagger for table/schema and table/index.
### Browse Content
Browse table content is a simple method of getting content (database records) in a database table. It requires a workspace ID and table ID, while paging is optional.
Example response body:
```json theme={null}
{
"items": [
{
"id": 1,
"created_at": 1681336868222,
"name": "Basketball",
"description": "round ball to shoot hoops",
"category_id": 1
},
{
"id": 2,
"created_at": 1681336868456,
"name": "French Press",
"description": "Make delicious coffee with this",
"category_id": 2
},
{
"id": 3,
"created_at": 1681336868658,
"name": "Bluetooth Speaker",
"description": "Portable music player",
"category_id": 3
},
{
"id": 4,
"created_at": 1681336868931,
"name": "Camera",
"description": "Take photos with this",
"category_id": 3
}
],
"itemsReceived": 4,
"curPage": 1,
"nextPage": null,
"prevPage": null,
"offset": 0,
"itemsTotal": 4,
"pageTotal": 1
}
```
###
Example response body:
```json theme={null}
[
{
"id": 1,
"name": "my workspace 1",
"description": ""
},
{
"id": 3,
"name": "test",
"description": ""
},
{
"id": 2,
"name": "to do app",
"description": "my to do app example"
}
]
```
### Get Tables of a Workspace
Browse workspace tables. This API endpoint requires a workspace ID and will provide various information about each database table in a workspace, including database table ID, which is needed in various Metadata API endpoints.
Example response body:
```json theme={null}
[
{
"id": 7,
"created_at": "2023-04-12 22:00:38+0000",
"updated_at": "2023-04-12 22:00:42+0000",
"name": "category",
"description": "",
"guid": "yu2eB8E0dSEtL6MbBPzzJUM06gA",
"auth": false
},
{
"id": 8,
"created_at": "2023-04-12 22:00:51+0000",
"updated_at": "2023-04-12 22:01:07+0000",
"name": "items",
"description": "",
"guid": "eP9O-rD-7sGKpbLOEhdED6YGrmA",
"auth": false
},
{
"id": 1,
"created_at": "2022-03-24 20:20:26+0000",
"updated_at": "2022-03-24 20:20:26+0000",
"name": "user",
"description": "",
"guid": "nTOiqqb31ecz1Te6v_3YMkfp5xc",
"auth": true
}
]
```
### Create Table and Add Schema One by One
First, create a new table in the desired workspace. The default request values suffice. In this example, first, we will create a table and then add schema individually. The Metadata API is capable of adding schema in bulk but that will be covered in another example.
Example response body:
```json theme={null}
{
"id": 9
}
```
Taking the newly created database table ID, we can add schema 1 by 1 to the table.
1. A text field called name.
Example response body:
```json theme={null}
{
"name": "name"
}
```
Next, let's add an integer field called score with a default value of 30
As we execute these Metadata API calls, our new table in Xano is being created along with the new schema, one by one.
### Create an Index
The Metadata API gives control over indexes on database tables. In this example, let's create a Unique Index on the name field of new table 123.
Example response body:
```json theme={null}
{
"id": "baa524c4"
}
```
The API responds with the ID of the index. In Xano, we can see the index has been created:
### Create Table with Schema and an Index in One Call
In this example, we will create a new database table along with schema and an index in the same API call. The Metadata API is flexible enough to accommodate this method.
Here's the example request body:
```json theme={null}
{
"name": "new stuff",
"description": "",
"auth": null,
"guid": null,
"schema": [
{
"name": "id",
"type": "int",
"description": "",
"nullable": false,
"default": "",
"required": true,
"access": "public",
"style": "single"
},
{
"name": "created_at",
"type": "timestamp",
"description": "",
"nullable": false,
"default": "",
"required": true,
"access": "public",
"style": "single"
},
{
"name": "name",
"type": "text",
"description": "",
"nullable": false,
"default": "",
"required": true,
"access": "public",
"style": "single"
}
],
"index":[
{
"type": "btree",
"fields": [
{
"name": "name",
"op": "desc"
}
]
}
]
}
```
This creates a new table called "new stuff" with three fields: id, created\_at, and name with an index on the name field.
Example response body:
```json theme={null}
{
"items": [
{
"id": 1,
"created_at": 1681336868222,
"name": "Basketball",
"description": "round ball to shoot hoops",
"category_id": 1
},
{
"id": 2,
"created_at": 1681336868456,
"name": "French Press",
"description": "Make delicious coffee with this",
"category_id": 2
},
{
"id": 3,
"created_at": 1681336868658,
"name": "Bluetooth Speaker",
"description": "Portable music player",
"category_id": 3
},
{
"id": 4,
"created_at": 1681336868931,
"name": "Camera",
"description": "Take photos with this",
"category_id": 3
}
],
"itemsReceived": 4,
"curPage": 1,
"nextPage": null,
"prevPage": null,
"offset": 0,
"itemsTotal": 4,
"pageTotal": 1
}
```
###