Select All User Tables

To get a list of all the user tables in a database, open a new query window and execute the following line of code:

SELECT *
FROM   [Sys].[Tables];