mssql里，寻找有哪些table包含某个字符串。

如何知道那些表里有abc字样的字段名呢？

-- declare my search table
declare @Columns TABLE (TableName varchar(50), ColumnName varchar(50))
declare @Results TABLE (Results VARCHAR(255))
declare @SearchData INT
SET @SearchData = 500

declare @TableName VARCHAR(50)
declare @ColumnName VARCHAR(50)
declare @Command VARCHAR(1024)

-- Find all tables with an integer column
insert INTO @Columns
select sysobjects.[Name] as TableName, syscolumns.[Name] as ColumnName
from dbo.sysobjects INNER Join dbo.syscolumns ON dbo.sysobjects.id = dbo.syscolumns.id
Where sysobjects.xtype = 'U' and syscolumns.xtype = 56 Order By TableName, ColumnName

select * from @Columns where columnname like '%你要找的字符%'

以上语句可以在mssql 2000通过/