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  
000019  # EVIDENCE-OF: R-01463-03846 The DROP TABLE statement removes a table
000020  # added with the CREATE TABLE statement.
000021  
000022  statement ok
000023  DROP TABLE t1
000024  
000025  # already dropped
000026  statement error
000027  DROP TABLE t1
000028  
000029  # never existed
000030  statement error
000031  DROP TABLE tX
000032  
000033  # TBD-EVIDENCE-OF: R-40197-14811 The dropped table is completely removed
000034  # from the database schema and the disk file.
000035  
000036  # EVIDENCE-OF: R-33950-57093 All indices and triggers associated with
000037  # the table are also deleted.
000038  
000039  # this should error, as was dropped with table
000040  statement error
000041  DROP INDEX t1i1;
000042  
000043  # PARTIAL-EVIDENCE-OF: R-57089-01510 The optional IF EXISTS clause suppresses
000044  # the error that would normally result if the table does not exist.
000045  
000046  statement ok
000047  CREATE TABLE t1( x INTEGER, y VARCHAR(8) )
000048  
000049  skipif mssql
000050  statement ok
000051  DROP TABLE IF EXISTS t1
000052  
000053  skipif mssql
000054  statement ok
000055  DROP TABLE IF EXISTS t1