Saturday, February 7, 2009

Tables to search on the SQL Server 2005 with query

If you want to list table with query , run the following query.

select * from INFORMATION_SCHEMA.TABLES where
TABLE_NAME LIKE '%USER%';

Result:

No comments: