--テーブルの拡張プロパティーを追加するコマンド

Declare @TableName as nvarchar(50)
Declare @TableNameDesc01 as nvarchar(100)
Declare @TableNameDesc02 as nvarchar(100)

Set @TableName='TableName'
Set @TableNameDesc01='テーブル名'
Set @TableNameDesc02='テーブルの説明'


-- 新規で作成する場合
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=@TableNameDesc01 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName
EXEC sys.sp_addextendedproperty @name=N'Description', @value=@TableNameDesc02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName


-- 情報を更新する場合

exec sys.sp_updateextendedproperty @name=N'MS_Description', @value=@TableNameDesc01 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName
exec sys.sp_updateextendedproperty @name=N'Description', @value=@TableNameDesc02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=@TableName