HI,
I am on a new project and just trying to get my head around the domain model. Has anyone any good tips for how I could get all the foreign keys in a schema quickly?

Or, is there any tool which will show me a visual version of my schema? Thanks.

I strongly recommend SQL Spec for this kind of "discovery" and for other purposes as well. The author of SQL Spec is an old friend of mine who stops by DBForums occasionally as Jezzemine.

SQL Spec can generate documentation files from many ODBC/OLEDB database formats. This documentation can be presented as web pages, or in many cases as a simple click-able help file.

-PatP

Thanks Pat. I ended up using SqlServer's Database Diagrams.

That will work. I'm biased because the developer of SQL Spec pays close attention to the user's needs, so it has literally evolved to suit my needs in many cases.

-PatP