I am working with volatile tables in stored procedure.
I need to handle errors for drop table X:
a) when table being dropped already exists (from prior run of stored procedure)
b) when table being dropped doesn't exist yet (first run of stored procedure)
I want to drop volatile tables created by sotred procedure, but I cannot find anywhere SQLSTATE values to handle those two errors.
Anyone struggled with this before. This is for voaltile tables....