diff options
| author | drh <drh@noemail.net> | 2000-05-31 02:27:49 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2000-05-31 02:27:49 +0000 |
| commit | dce2cbe65f9bedf260d320c775d59727a6ddb9bb (patch) | |
| tree | f8a0b3281313cedf3734d4284fd1204548bcb2fb /www/sqlite.tcl | |
| parent | 7e391e1728770cf09f0b544e9a417990292235cd (diff) | |
| download | sqlite-dce2cbe65f9bedf260d320c775d59727a6ddb9bb.tar.gz sqlite-dce2cbe65f9bedf260d320c775d59727a6ddb9bb.zip | |
:-) (CVS 20)
FossilOrigin-Name: 01d85b35e9c4ca5619ad21a4232a8f8bf9ec3538
Diffstat (limited to 'www/sqlite.tcl')
| -rw-r--r-- | www/sqlite.tcl | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/www/sqlite.tcl b/www/sqlite.tcl index a69b3763e..873d3e28f 100644 --- a/www/sqlite.tcl +++ b/www/sqlite.tcl @@ -1,7 +1,7 @@ # # Run this Tcl script to generate the sqlite.html file. # -set rcsid {$Id: sqlite.tcl,v 1.3 2000/05/29 18:50:16 drh Exp $} +set rcsid {$Id: sqlite.tcl,v 1.4 2000/05/31 02:27:50 drh Exp $} puts {<html> <head> @@ -354,6 +354,18 @@ SELECT sql FROM sqlite_master ORDER BY tbl_name, type DESC, name </pre></blockquote> +<p>Of, if you give an argument to ".schema" because you only +one the schema for a single table, the query looks like this:</p> + +<blockquote><pre> +SELECT sql FROM sqlite_master +WHERE tbl_name LIKE '%s' +ORDER BY type DESC, name +</pre></blockquote> + +<p>The <b>%s</b> in the query above is replaced by the argument +to ".schema", of course.</p> + <h2>Other Dot Commands</h2> <p>The ".explain" dot command can be used to set the output mode |