So I needed to add 2 columns to about 20 tables. Not much and I could have easily wrote a script for each table. But thats boring. So I started searching around.
I came up with this
Select 'Alter table '+table_name+' Add yourcol datatype' from information_schema.tableswhere table_name<>'dtProperties'
...
I had a new Flood in my kitchen Sunday. From a clogged pipe. I started to do laundry and my great basement plumbing, consisting of my tub draining into my sump well and then the sump pump draining it up and out. Well I mentioned the clog, and it didn't get past it. Didn't go into the bath tub because there is a check valve there. So it went all the way back to the kitchen sink. And I was playing my game. So I didn't hear water dripping everywhere. By the time I did the sink was full...