I’m never going to ALTER TABLE ever in my life. I thought I was going to have a heart attack. Or something worse, like getting laughed at by Felix the bwiset. I needed to alter my table but I know I’d hafto drop it and re-create the table but my oh-so-helpful Pangs said “ay pwedeng magAlter-Table sa 8.2 .. *wapaks* Wow, pagOK button ko eh wuuuuuuuuushh. Vanishing act ang aking views. I almost threw a tantrum and cried on the carpet. 11 freaking views were missing and I have no backup. (pinagalitan pa ako ni Pangs.. grrrr) good thing nagbabackup pala ng Development Server. And Friggin Felix was laughing. GRRRR.
So, MORAL lesson learned. Generate your DDLs, AND if shortcuts feel that they’re too good to be true, they probably are.