My apologies - I took a closer look and realized that I was actually putting a semicolon on the end of the statement:
.schema sqlite_temp_master; -- doesn't work. -Jon ______________________________________ Jon Polfer Project Engineer - High Level Software Engineering Office Phone: 262-832-0049 (Ext. 5 for Jon Polfer) Fax: E-mail: jpol...@forceamerica.com FORCE America Inc. W229 N1433 Westwood Drive, Suite 200 Waukesha, WI 53186 www.forceamerica.com The Leading Innovator in Mobile Hydraulic Solutions -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, July 08, 2010 9:48 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] sqlite_temp_master schema On Thu, Jul 8, 2010 at 8:49 AM, Jon Polfer <jpol...@forceamerica.com> wrote: > I'm running SQLite 3.5.9. > > In the interactive client sqlite3, when I type: > > .schema sqlite_temp_master > > No schema description is returned, even when data exists in the table. > > Is this to be expected? > Cannot replicate. Here is what I get: d...@elly:~> sqlite/history/bld/sqlite3-3.5.9 SQLite version 3.5.9 Enter ".help" for instructions sqlite> .schema sqlite_temp_master CREATE TEMP TABLE sqlite_temp_master ( type text, name text, tbl_name text, rootpage integer, sql text ); sqlite> .quit d...@elly:~> > > -Jon > > > ______________________________________ > Jon Polfer > Project Engineer - High Level Software > > Engineering Office Phone: 262-832-0049 (Ext. 5 for Jon Polfer) > Fax: > E-mail: jpol...@forceamerica.com > > FORCE America Inc. > W229 N1433 Westwood Drive, Suite 200 > Waukesha, WI 53186 > www.forceamerica.com > > The Leading Innovator in Mobile Hydraulic Solutions > > > > > The information contained in this message and any attachment may be > proprietary, confidential, and privileged or subject to the work > product doctrine and thus protected from disclosure. If the reader > of this message is not the intended recipient, or an employee or > agent responsible for delivering this message to the intended > recipient, you are hereby notified that any dissemination, > distribution or copying of this communication is strictly prohibited. > If you have received this communication in error, please notify me > immediately by replying to this message and deleting it and all > copies and backups thereof. Thank you. > > > Disclaimer added by CodeTwo Exchange Rules > http://www.codetwo.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- --------------------- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users