Retrieve Database Schema

Question

I want to know, how can I retrieve Sql-Database schema informations such as Tables, Columns and Their relation between Tables and etc. I know it's possible if I execute different particular queries on Master Database and the targeted Database. But Is there any efficient way to retrieve schema of database ?

Thanks in advance.

Answer 1

Take a look at this project on codeplex: http://dbschemareader.codeplex.com/releases/view/71696