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[_]%';