比如我们要找出数据库里列名中含有“paym”的表:
SELECT
B.name
,A.name
FROM [DataWarehouse].[dbo].syscolumns A
LEFT JOIN
(
SELECT * FROM [DataWarehouse].[dbo].sysobjects
)B
ON A.id=B.id
WHERE A.name like '%paym%'
谢谢!
比如我们要找出数据库里列名中含有“paym”的表:
SELECT
B.name
,A.name
FROM [DataWarehouse].[dbo].syscolumns A
LEFT JOIN
(
SELECT * FROM [DataWarehouse].[dbo].sysobjects
)B
ON A.id=B.id
WHERE A.name like '%paym%'
谢谢!