Looping in SQL

I want to keep trying to alter a table until it is successful. If the alter table command
is not successful, then try the alter command again. If it is not successul then do the
next SQL command. I need to somehow check the SQL error code for alter command
if it's OK or not. Can somebody tell me how to do this in SQL ??

Thank You Very Much! Received on Sat Mar 24 2001 - 02:53:34 CST