Here is a query which will show you the defined tables in a database:

SELECT name FROM SysObjects
where xtype = 'U'
order by name