Lines Matching refs:name

12 # Check to ensure that the type, name, and tbl_name fields of the
44   SELECT type, name, tbl_name, '|' FROM sqlite_master;
48   UPDATE sqlite_master SET tbl_name=NULL WHERE name='t1';
49   SELECT type, name, tbl_name, '|' FROM sqlite_master;
58   UPDATE sqlite_master SET tbl_name='tx' WHERE name='t1';
59   SELECT type, name, tbl_name, '|' FROM sqlite_master;
67   UPDATE sqlite_master SET tbl_name='t1', type='tabl' WHERE name='t1';
68   SELECT type, name, tbl_name, '|' FROM sqlite_master;
76   UPDATE sqlite_master SET tbl_name='t9',type='table',name='t9'WHERE name='t1';
77   SELECT type, name, tbl_name, '|' FROM sqlite_master;
86   UPDATE sqlite_master SET name='t1',tbl_name='T1' WHERE name='t9';
87   SELECT type, name, tbl_name, '|' FROM sqlite_master;
97   UPDATE sqlite_master SET type='view' WHERE name='t1';
98   SELECT type, name, tbl_name, '|' FROM sqlite_master;
108   UPDATE sqlite_master SET type='table', tbl_name='t1' WHERE name='t1';
109   UPDATE sqlite_master SET tbl_name='tx' WHERE name='i1';
110   SELECT type, name, tbl_name, '|' FROM sqlite_master;
120   UPDATE sqlite_master SET type='table', tbl_name='t1' WHERE name='i1';
121   SELECT type, name, tbl_name, '|' FROM sqlite_master;
131   UPDATE sqlite_master SET type='view', tbl_name='t1' WHERE name='i1';
132   SELECT type, name, tbl_name, '|' FROM sqlite_master;
142   UPDATE sqlite_master SET type='index', tbl_name='t1' WHERE name='i1';
143   UPDATE sqlite_master SET type='table', tbl_name='v2' WHERE name='v2';
144   SELECT type, name, tbl_name, '|' FROM sqlite_master;
154   UPDATE sqlite_master SET type='view',name='v3',tbl_name='v3' WHERE name='v2';
155   SELECT type, name, tbl_name, '|' FROM sqlite_master;
165   UPDATE sqlite_master SET type='view',name='v2',tbl_name='v2' WHERE name='v3';
166   UPDATE sqlite_master SET type='view' WHERE name='r1';
167   SELECT type, name, tbl_name, '|' FROM sqlite_master;
176   UPDATE sqlite_master SET type='trigger',tbl_name='v2' WHERE name='r1';
177   SELECT type, name, tbl_name, '|' FROM sqlite_master;