Lines Matching refs:create
25 # trig-1.9: Ensure that we cannot create a trigger on sqlite_master
127 } {1 {cannot create trigger on system table}}
135 create table t1(a,b);
140 create trigger r1 after delete on t1 for each row begin
150 create table t1(a,b);
155 create trigger r1 after update on t1 for each row begin
164 # Ensure that we cannot create INSTEAD OF triggers on tables
167 create table t1(a,b);
168 create trigger t1t instead of update on t1 for each row begin
172 } {1 {cannot create INSTEAD OF trigger on table: t1}}
173 # Ensure that we cannot create BEFORE triggers on views
176 create view v1 as select * from t1;
177 create trigger v1t before update on v1 for each row begin
181 } {1 {cannot create BEFORE trigger on view: v1}}
182 # Ensure that we cannot create AFTER triggers on views
186 create view v1 as select * from t1;
187 create trigger v1t AFTER update on v1 for each row begin
191 } {1 {cannot create AFTER trigger on view: v1}}
430 # example, that you can drop and re-create tables referenced by triggers.
501 # Drop and re-create the insert_log table in a different database. Note