2种方法增加表注释，都没查到。何故？

[handsome1234]

 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'2019秋冬工艺号成本价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'YHJ_TEMPFFGG190304'

-- 修改表注释
execute sp_updateextendedproperty 'MS_Description','2019秋冬工艺号成本价','user','dbo','table','YHJ_TEMPFFGG190304',null,null;

查询表备注查不着：
SELECT  A.name AS table_name ,
        B.name AS column_name ,
        C.value AS column_description
FROM    sys.tables A
        INNER JOIN sys.columns B ON B.object_id = A.object_id
        LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id
                                               AND C.minor_id = B.column_id
WHERE   CAST(C.value AS NVARCHAR(4000)) LIKE '%成本%'

[卖水果的net]

-- 加个 N 试试呢？
WHERE   CAST(C.value AS NVARCHAR(4000)) LIKE N'%成本%'

[handsome1234]

--查询表备注查不着：
SELECT  A.name AS table_name ,        
        C.value AS column_description
FROM    sys.tables A        
        LEFT JOIN sys.extended_properties C ON C.major_id = A.object_id                                               
WHERE   CAST(C.value AS NVARCHAR(4000)) LIKE '%成本%'

应该是 INNER JOIN sys.columns B ON B.object_id = A.object_id 这里有问题

[handsome1234]

上面的脚本就成查到了，之前的是INNER JOIN sys.columns B ON B.object_id = A.object_id 这里有问题