So, should we answer in
Applications and Tools, in
MS-SQL, or in
Database Concepts and Design?
Yes, there are several tools that will do this. I don't know of any tools that are accepted "standards" within the industry, everybody seems to more or less "roll their own" depending on the needs of the moment. What exactly are you looking for, something that will extract basic column definitions, or something more complex?
-PatP