sqlserver如何取得以指定前缀开头的表名?

Question

SELECT a.name AS tableName, CONVERT(NVARCHAR(100),isnull(g.[value],'-')) AS remarks 
FROM sys.tables a LEFT JOIN sys.extended_properties g ON (a.object_id = g.major_id AND g.minor_id = 0)
WHERE a.name like 'JB_%';

SQLServer 2019 运行查询结果. 出现了不以:JB_开始的表名

发现有没有_都是一样的结果

Answer 1

‘_’是代表一个任意字符，需要将‘_’转义

SELECT a.name AS tableName, CONVERT(NVARCHAR(100),isnull(g.[value],'-')) AS remarks 
FROM sys.tables a LEFT JOIN sys.extended_properties g ON (a.object_id = g.major_id AND g.minor_id = 0)
WHERE a.name like 'JB[_]%';