David Swigger wrote:
Anyone know a more direct way?
You could also try using pragma table_info(tablename).
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hello all,
Lets say I have created a table like this:
CREATE TABLE mytable(
id INTEGER PRIMARY KEY
first text,
second text,
third text)
How do I go about retrieving the specifics on that table
at a later date?
I know I can do:
PRAGMA empty_result_callbacks=ON
PRAGMA show_datatypes = ON
Note: forwarded message attached.
--- Begin Message ---
--- Tim Anderson <[EMAIL PROTECTED]> wrote:
> It's worth noting that Sqlite is not the equivalent
> of Microsoft Access.
> If anything, Sqlite is the equivalent of JET, the
> Access database
> engine. In order to offer a meaningful
SQLite will store anything UTF-8 or ANSI as long as its null terminated
and escaped for '. The only place where encoding makes a difference is
in functions like length.
Will
Steven Van Ingelgem wrote:
If I have a table like:
CREATE TABLE routing (
FIELD1 VARCHAR(40)
);
what if I get a
4 matches
Mail list logo