Hello,
I always assumed that dropping table will drop everything associated
with it like indexes, references etc.
I just noticed that after dropping table A and recreating it and then
creating index on it gave me error
DROP TABLE tmp
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0204N "TMP" is an undefined name. SQLSTATE=42704
CREATE TABLE tmp ( a INTEGER, b CHAR(2), c CHAR(2) )
DB20000I The SQL command completed successfully.
CREATE UNIQUE INDEX tmp_ix ON tmp (a)
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0601N The name of the object to be created is identical to the
existing
name "tmp_ix" of type "INDEX". SQLSTATE=42710
please explain ?