You can use the INFORMATION_SCHEMA views to get the metadata on any database:

SELECT * FROM INFORMATION_SCHEMA.TABLES

You can also get information on table columns, table constraints, etc.  You can check what views are available by going to the System Views node under the Views node of the database from the Microsoft SQL Server Management Studio.