Posted onNovember 3, 2010 by Josephine list of all tables in a sql server database USE yourdbname SELECT * FROM sys.Tables WHERE name like ‘%something%’ ORDER BY name