列名和表名的描述说明
添加字段说明:
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字段描述的内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'表名称', @level2type=N'COLUMN',@level2name=N'列名称'
GO
删除字段说明:
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'fm_jx_statementaccount',
@level2type=N'COLUMN',@level2name=N'pzzName'
GO
表描述:
EXEC sp_addextendedproperty N'tablecaption', N'学生表', 'SCHEMA', N'dbo', 'TABLE', N'Student', NULL, NULL