How to Limit integer digits in a table in SQLite

Question

How to Limit integer digits in a table in SQLite in a programatical way in ios?

Eg: "CREATE TABLE IF NOT EXISTS TIMINGS (ID INTEGER PRIMARY KEY AUTOINCREMENT, Phone no INT (5), TIMING TEXT)";

we have to limit the phone no to 5 digits.

It is the right way or wrong way ????

Thanks in Advance.

Answer 1

One way you could do this with a check constraint. See the documentation here.

The particular syntax would be something like:

create table . . .
    check (phonenum between 0 and 99999);

Alternatively, just make the phonenum a five character field -- you then cannot store more than five characters.