MS SQL Server database schema retrieval
Posted on 2004-09-03
I would like to retrieve the database schema and determine the following:
* User Tables
* Keys (primary keys, composite keys, no keys)
* Relationships (all types)
* Null possible
I am really desperate to retrieve this information and will award maximum points for solution.
Can someone please provide an example of how to retrieve the schema and the above information.