Handy Query

I was looking for an SQL query that would list all the tables I have on our server. Well, found it! Here it is if you're interested:

use (database name)

GO

Select *
From sys.Tables
Go