# Local

When you add Tables to this Profile, you are defining a Database Table (from scratch) that only exists on the device where the developed Project is running.

In Kalipso you can define a structure for a local database and when the application is deployed, the database will be automatically created on the device. This type of database is normally used to store temporary information.

The data can be loaded from text files, used and then exported back to text files. Kalipso has actions to automatically export and import data to and from text files. For further information see the “[File Import to Table](/kalipso5/developing/form/actions/actions-description/group-files/file-import-to-table.md)” and “[File Export From Table](/kalipso5/developing/form/actions/actions-description/group-files/file-export-from-table.md)” in the “[Actions](/kalipso5/developing/form/option-window/actions.md)” chapter.

When you click on add tables the information that appears is that represented in the following window. The window is divided in three tabs: table, Columns and Browse Data.

### Tab - Table

![](/files/-MZncJc0vrT9dLR50ajW)

*Details*

* **Name** - Name for the table
* **Database Profile** - *Not applicable to this profile.*
* **ODBC Connection** - *Not applicable to this profile.*
* **User** - *Not applicable to this profile.*
* **Sync. Profile** - *Not applicable to this profile.*

*Description*

* **Text area** - Open field for the description of the table. Kalipso does nothing with this information.

### Tab - Columns

![](/files/-Mb7lOU-Q0bctfe_x4Y8)

In this tabulation, the columns of the table created in the previous option are created. The criteria to consider are:

* **Column** - Name for the column of the table.
* **Column Type** - Select the type for the column. It can be one of:
  * Varchar
  * Numeric
  * Decimal
  * Date
  * Time
  * DateTime
* **Size** - Define the size for the column in characters.
* **Decimal Places** - Define the number of decimal places
* **Key?** - Check box to indicate which of the available columns is the key.
* **Output Mask** - Enter the output mask to specify exactly how data should be presented
* **Input Mask** - Enter the input mask to specify exactly how data should be entered

In the right there are four icons to work with the columns:

* **Move up** - Moves the selected column up on the list.
* **Move down** - Moves the selected column up on the list.
* **Rename** - Rename the selected column.
* **Delete** - Deletes the selected column.

To add a column just click on the field "column".

### Tab - Browse Data

![](/files/-Mb7lkCkpMrdxPO28SWN)

To use this tab you can introduce a script in the first area, click on the refresh icon and you will see the search result in the area immediately below.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://doc.sysdevmobile.com/kalipso5/developing/form/database-connection-profiles/tables/local.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.