--カラムの拡張プロパティーを追加するコマンド

Declare @ColName as nvarchar(50)
Declare @TableName as nvarchar(50)
Declare @ColNameDesc01 as nvarchar(100)
Declare @ColNameDesc02 as nvarchar(100)

Set @TableName='TableName'
Set @ColName='ColmunName'
Set @ColNameDesc01='データソース'
Set @ColNameDesc02='カラム名'


-- 新規で作成する場合

EXEC sys.sp_addextendedproperty @name=N'DataSours', @value=@ColNameDesc01 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName, @level2type=N'COLUMN',@level2name=@ColName
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=@ColNameDesc02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName, @level2type=N'COLUMN',@level2name=@ColName

-- 情報を更新する場合
EXEC sys.sp_updateextendedproperty @name=N'DataSours', @value=@ColNameDesc01 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName, @level2type=N'COLUMN',@level2name=@ColName
EXEC sys.sp_updateextendedproperty @name=N'MS_Description', @value=@ColNameDesc02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName, @level2type=N'COLUMN',@level2name=@ColName