Are there useful static analysis tools for databases?

Question

Is there a tool for examining the configuration and schema of a database for dubious fields, relationships and configuration, similar to how static analysis tools like lint will flag dubious lines of code?

I'm not necessarily asking for normalization, but surely there's stupid stuff that can be detected without solving Hard AI or the Halting Problem.

Answer 1

I regularly use SqlSpec from www.elsasoft.org
It makes a nice documentation you can navigate (in html or chm formats), and works with most databases.
It's not completely flawless, but it's quite good, affordable, and the author responds emails, which I appreciate.

Answer 2

Not sure if this does absolutely everything you are looking for...but all of red gates tools rock!

http://www.red-gate.com/products/SQL_Dependency_Tracker/index.htm