向数据库中全部表中增加一个字段的SQL

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