如何使用SQL语句在建立表时给字段添加注释

Question

如题所述

Answer 1

SQL语句添加字段说明语法：EXECUTE sp_addextendedproperty N'MS_Description','列属性说明',N'user',N'dbo',N'table',N'table_name(表名)',N'column',N'column_name(列名)'
--以下示例是给Card表的字段CardID添加注释/说明为“卡号”
EXECUTE sp_addextendedproperty N'MS_Description','卡号',N'user',N'dbo',N'table',N'Card',N'column',N'CardID'