I assume you are referring to metadata. Take a look at the INFORMATION_SCHEMA views. For example:

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

This will show you all tables in the database. Look up INFORMATION_SCHEMA in Books Online.