# SQLite

SQLite component can be used to interface with the Android device built-in SQLite Relational Database Management System (RDMBS). Using this component, you'll be able to create complex data structures and create parent-child tables (e.g. employer, employees) and query data from 1 or multiple tables by joining tables together.

In this tutorial, we'll show you simple steps to perform basic CRUD (Create, Read, Update, Delete) functions. For full functionality of SQLLite SQL commands, please refer to document [HERE](https://sqlite.org/lang.html),

SQLite component is a non-visible component that has blocks that you see in image blow:.

* RunQuery - can be used to run any valid[ SQL-92](https://en.wikipedia.org/wiki/SQL-92) statements; such as creating tables, executing queries
* DropTable - used to drop an existing table
* DisplayTables - displays all table names within the current database

![](/files/-L9Bu_aFFlc5yjglHXQL)

In our sample app, we will add ability to create table, insert data, read data, drop table. First, we will create a table that has 4 columns of type varchar:

![](/files/-L9Bu_aSzKzSh1QrWMZz)

Next, we will insert some test-data into this table. Notice from image below:

![](/files/-L9Bu_aZwRSYGC1OLRPo)

Now, we will query data to display result. The result will be in form of a LIST where 1st row will be the column headings.

![](/files/-L9Bu_ahkodt45IY8Hz6)

If you wish to eliminate the column heading, just get the values starting from 2nd element of the LIST:

![](/files/-L9Bu_aqXMvAYXZn8_WW)

Use link below to get .aia that can be loaded and test using <http://Gold.AppyBuilder.com>

<http://AppyBuilder.com/tutorials/sqlite/SQLiteTest.aia>


---

# 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://help.appybuilder.com/components/reference/advanced/sqlite.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.