Table Structure Overview

I was recently asked to provide a high level overview of a SQL database. I put together a script that provided:

  • Table Name
  • Column Position
  • Column Name
  • Data Type
  • Max Length and/or Precision
  • Is the field is NULLable
  • Is the field a Primary Key

Here is the script:

 

One comment on “Table Structure Overview

  1. hi That’s a nice post.

Leave a Reply

Your email address will not be published.

HTML tags are not allowed.