查找字段sql

Create Procedure sp_LookForColumn ( @DBName VarChar(100) , @ColumnName VarChar(100) ) As Declare @SQL VarChar(8000) Select @SQL = ' Select A.Name TableName, B.Name ColumnName From [' + @DBName + ']..sysobjects A , [' + @DBName + ']..syscolumns B Where A.ID = B.ID And B.Name Like ''%' + @ColumnName + '%'' And A.XType = ''U'' Order By A.Name , B.Name ' Exec (@SQL)