Documentation of Table Structure

  • I need to print out the tables and their relationships. However if I use Database Diagram it will attempt to create the foreign keys. Is there a non cost way to do this without having the fk's created.

  • Have you tried using Information_Schema.table_constraints?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • You can try to use Visio.

  • Thanks been trying visio but it does not graphicly display the relationships correctly(arrows are the wrong way and not connected to actual fields just the table box). I thinks it just the connector that I am using. Thank you.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply