<p>I'd like to create a table which has an integer primary key limited between 000 and 999. Is there any way to enforce this 3 digit limit within the sql?</p>

<p>I'm using sqlite3.
Thanks.</p>

You may be able to do so using a CHECK constraint.
But,
CHECK constraints are supported as of version 3.3.0. Prior to version 3.3.0, CHECK constraints were parsed but not enforced.
(from
here
)
So unless SQLite 3 = SQLite 3.3 this probably won't work