000001  hash-threshold 8
000002  
000003  statement ok
000004  CREATE TABLE t1( x INTEGER, y VARCHAR(8) )
000005  
000006  statement ok
000007  INSERT INTO t1 VALUES(1,'true')
000008  
000009  statement ok
000010  INSERT INTO t1 VALUES(0,'false')
000011  
000012  statement ok
000013  INSERT INTO t1 VALUES(NULL,'NULL')
000014  
000015  statement ok
000016  CREATE INDEX t1i1 ON t1(x)
000017  
000018  onlyif mssql
000019  halt
000020  
000021  # EVIDENCE-OF: R-61172-15671 The DROP TRIGGER statement removes a
000022  # trigger created by the CREATE TRIGGER statement.
000023  
000024  statement ok
000025  CREATE TRIGGER t1r1 UPDATE ON t1 BEGIN SELECT 1; END;
000026  
000027  statement ok
000028  DROP TRIGGER t1r1
000029  
000030  # already deleted
000031  statement error
000032  DROP TRIGGER t1r1
000033  
000034  # never existed
000035  statement error
000036  DROP TRIGGER tXrX
000037  
000038  # TBD-EVIDENCE-OF: R-32598-49611 The trigger is deleted from the database
000039  # schema.
000040  
000041  # EVIDENCE-OF: R-37808-62273 Note that triggers are automatically
000042  # dropped when the associated table is dropped.
000043  
000044  statement ok
000045  CREATE TRIGGER t1r1 UPDATE ON t1 BEGIN SELECT 1; END;
000046  
000047  statement ok
000048  DROP TABLE t1
000049  
000050  # already deleted when table dropped
000051  statement error
000052  DROP TRIGGER t1r1
000053