One would be to use the undoented call sp_msforeachtable, as in
sp_msforeachtable 'ALTER TABLE ? ADD NEWCOL INT NULL'
Since its a undoented call, please refrain from using it in production
Another option would be to generate sql scripts, as in
SELECT 'ALTER TABLE '+QUOTENAME(table_name)+' ADD NEWCOL INT
WHERE table_type = 'BASE TABLE'
SQL Server FAQ at
"james" <net> wrote in message