DDL Statements

A database file can have any number of tables. A table consists of rows, and each row has a certain number of columns. Each column of the table has a name and a data type (text string, number, and so forth). You define these tables and column names by first running Data Definition Language (DDL) statements. Here's a statement that creates a table with three columns:

Download SQLite/create.sql

create table mytable (

_id integer primary key autoincrement, name text, phone text );

One of the columns is designated as the PRIMARY KEY, a number that uniquely identifies the row. AUTOINCREMENT means that the database will add 1 to the key for every record to make sure it's unique. By convention, the first column is always called _id. The _id column isn't strictly required for SQLite, but later when we want to use an Android ContentProvider, we'll need it.

Note that, unlike most databases, in SQLite the column types are just hints. If you try to store a string in an integer column, or vice versa, it will just work with no complaints. The SQLite authors consider this to be a feature, not a bug.

0 0

Post a comment