SQL加字段和备注

ALTER TABLE dbo.Product ADD AAAName nvarchar(50);

-- 字段加注释
EXEC sys.sp_addextendedproperty @name = N'MS_Description',
@value = N'名称',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'Product',
@level2type = N'COLUMN',
@level2name = N'AAAName ';