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'
...