sqlserver如何取得以指定前缀开头的表名?-灵析社区
应该是最帅的鹅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_开始的表名  发现有没有`_`都是一样的结果
时光旅人‘’是代表一个任意字符，需要将‘’转义
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[_]%';