MS SQL這一點不如MySQL來的方便，語法如下：

DECLARE @TableName NVARCHAR(128) = 'TableName';
DECLARE @ColumnName NVARCHAR(128) = 'ColumnName';
DECLARE @Description NVARCHAR(255) = '這是欄位註解';

EXEC sp_addextendedproperty 
    @name = 'MS_Description', 
    @value = @Description, 
    @level0type = 'SCHEMA', 
    @level0name = 'dbo', 
    @level1type = 'TABLE', 
    @level1name = @TableName, 
    @level2type = 'COLUMN', 
    @level2name = @ColumnName;

因此有些人會希望把它包成自訂函數來使用。

CREATE FUNCTION AddColDescription(
    @TableName NVARCHAR(128),
    @ColumnName NVARCHAR(128), 
    @Description NVARCHAR(255)
)
RETURNS INT
AS
BEGIN
    EXEC sp_addextendedproperty 
        @name = 'MS_Description',
        @value = @Description,
        @level0type = 'SCHEMA',
        @level0name = 'dbo',
        @level1type = 'TABLE',
        @level1name = @TableName,
        @level2type = 'COLUMN', 
        @level2name = @ColumnName
    RETURN 1
END

了解下述這三個函數或查 [擴充屬性] 關鍵字就可以操作描述 (MS_Description) 了

• sp_addextendedproperty
• sp_updateextendedproperty
• sp_dropextendedproperty