Lines Matching refs:tbl

31   CREATE TABLE tbl(a, b);
34   CREATE VIEW v1 AS SELECT * FROM tbl;
35   CREATE INDEX i1 ON tbl(a);
39   CREATE TRIGGER t1 AFTER INSERT ON tbl BEGIN
42   CREATE TRIGGER v1 AFTER UPDATE ON tbl BEGIN
45   CREATE TRIGGER i1 AFTER DELETE ON tbl BEGIN
51   INSERT INTO tbl VALUES(1, 2);
52   UPDATE tbl SET b=a+b, a=a+1;
53   DELETE FROM tbl;
65   INSERT INTO tbl VALUES(1, 2);
66   UPDATE tbl SET b=a+b, a=a+1;
67   DELETE FROM tbl;
77   INSERT INTO tbl VALUES(1, 2);
78   UPDATE tbl SET b=a+b, a=a+1;
79   DELETE FROM tbl;
85   CREATE VIEW v1 AS SELECT * FROM tbl;
86   CREATE INDEX i1 ON tbl(a);
98     INSERT INTO tbl VALUES(1, 2);
99     UPDATE tbl SET b=a+b, a=a+1;
100     DELETE FROM tbl;
109     CREATE TABLE tbl(a, b);
116     CREATE TRIGGER t1 AFTER INSERT ON tbl BEGIN
119     CREATE TRIGGER i1 AFTER DELETE ON tbl BEGIN
127     INSERT INTO tbl VALUES('a', 'b');
128     DELETE FROM tbl;
137     INSERT INTO tbl VALUES('c', 'd');
138     DELETE FROM tbl;
143     CREATE TEMP TRIGGER x1 AFTER UPDATE ON tbl BEGIN
155   do_execsql_test schema4-2.7 { ALTER TABLE tbl RENAME TO tbl2 } {}