Error when trying to drop a table that doesn’t exist in RUNSQLSTM
If I try and DROP a table that does not exist the RUNSQLSTM will fail. Is it possible to monitor for this in the RUNSQLSTM so it won't fail?
View Answer
| Jul 2 2008 10:03 AM GMT
| asked by
Gingertosser
DROP, tables, RUNSQLSTM
Stored Procedure for dropping indexes
I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops.Then I would like another strored procedure that takes a table name as...
View Answer
| Feb 28 2008 4:04 PM GMT
| asked by
Dangagne
Indexes, DROP, Restore
