title: Query to get the names of all tables in SQL Server 2008 Database
body: <p>Is it possible to write a query that will give me the names of all the tables in an SQL Server database? I'm working on some 'after the fact' documentation on a system I didn't create and am looking for a shortcut to get a listing of the tables in a database.</p>