Adding a column to all user tables in ms sql server

There is an undocumented but well known stored procedure sp_msforeachtable:

exec sp_msforeachtable 'alter table ? add {colname} {dataType} {null|not null} ....';