Friday, February 11, 2011

How to Search the Table in all the Database

----How to Search the Table in all the Database
sp_msforeachdb "SELECT '?' DatabaseName, Name FROM ?.sys.Tables WHERE Name LIKE '%data%'"
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)