向資料庫中全部表中增加一個欄位的SQL

SELECT 'ALTER TABLE ' + NAME + ' ADD 欄位名 int not null default 0' FROM sysobjects AS s
WHERE s.[type] ='u'  ORDER BY s.name