How to determine the existence of a table in a DB

cy163 · #1 (**permalink**) 04-15-11, 19:06

Hello ALL,

I wonder how to determine whether a table has already existed in a database.

Thanks

Marcus_A · #2 (**permalink**) 04-15-11, 20:12

You can determine whether it exists now by querying syscat.tables. I don't think you can determine whether it existed in the past, but has been dropped.

db2girl · #3 (**permalink**) 04-15-11, 23:19

You can find info about dropped tables in the history file if it hasn't been pruned.

stolze · #4 (**permalink**) 04-19-11, 05:16

You can also try to create the table and check for an error code returned by DB2.

Internet Services

Web Development

Digital Marketing

Consumer Tech