Lines Matching refs:sql

115     SELECT sql FROM sqlite_master WHERE tbl_name='t1' AND sql!=''
130   SELECT sql FROM sqlite_master WHERE name='t3';
150   SELECT sql FROM sqlite_master WHERE name='t4';
159 do_execsql_test 3.4 { SELECT sql FROM sqlite_master WHERE type='trigger' } {
180   SELECT sql FROM sqlite_master WHERE name IN ('c1', 'p1');
194   SELECT sql FROM sqlite_master WHERE name IN ('c1', 'c2', 'p1');
286   SELECT sql FROM sqlite_master WHERE type='view';
297   SELECT sql FROM sqlite_master WHERE type='view';
310   SELECT sql FROM sqlite_master WHERE type='view';
321   SELECT sql FROM sqlite_master WHERE name='vvv';
327   SELECT sql FROM sqlite_master WHERE name='www';
338   SELECT sql FROM sqlite_master WHERE name='xxx';
354     foreach sql $lSchema { 
355       execsql $sql 
356       lappend lSorted [string trim $sql]
361       SELECT sql FROM sqlite_master WHERE sql!='' ORDER BY 1
372       SELECT sql FROM sqlite_master ORDER BY 1
467     SELECT sql FROM sqlite_master;
499   SELECT sql FROM sqlite_master WHERE tbl_name = 'sqlite_stat1'
551   SELECT sql FROM sqlite_master WHERE name='x1i';
557   UPDATE sqlite_master SET sql = 'CREATE INDEX x1i ON x1(j)' WHERE name='x1i';
567   UPDATE sqlite_master SET sql = '' WHERE name='x1i';
626   CREATE TABLE ddd(sql, type, object, db, tbl, icol, znew, bquote);
644   sqlite_rename_column(sql, type, object, db, tbl, icol, znew, bquote, 0)
671   SELECT sql FROM sqlite_master WHERE type='view';
779   SELECT sql FROM sqlite_master WHERE name = 'v2';
793   SELECT sql FROM sqlite_master WHERE name='t1';
799   SELECT sql FROM sqlite_master WHERE name='t1';
807   SELECT sql FROM sqlite_master WHERE name='t1';
824   SELECT sql FROM sqlite_schema WHERE name IS 'tr1'
837   SELECT sql FROM sqlite_schema;
865   SELECT sql FROM sqlite_schema WHERE name='t1';
878   CREATE TABLE schema_copy(name TEXT, sql TEXT);
879   INSERT INTO schema_copy(name,sql) SELECT name, sql FROM sqlite_schema WHERE sql IS NOT NULL;
885   SELECT name, sql FROM sqlite_master
886     EXCEPT SELECT name, sql FROM schema_copy;
894      WHERE (name, sql) NOT IN (SELECT name, sql FROM schema_copy);
904   INSERT INTO schema_copy(name,sql) SELECT name, sql FROM sqlite_schema WHERE sql IS NOT NULL;
910   SELECT name, sql FROM sqlite_master
911     EXCEPT SELECT name, sql FROM schema_copy;
919      WHERE (name, sql) NOT IN (SELECT name, sql FROM schema_copy);
926   INSERT INTO schema_copy SELECT name, sql FROM sqlite_schema;
930   SELECT name FROM sqlite_schema WHERE (name,sql) NOT IN (SELECT * FROM schema_copy);