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: