The Schema module is a great tool when working with databases. You can use it to inspect your site's database, to see if there are changes, and to get more detailed descriptions for what all of the tables and fields are being used for. You can also use Schema to create the code you need to create database tables and fields. In this lesson we take a look at Schema's inspection features, and then we add a new table to the database for our custom module, build it out with some fields, and have schema generate the code, which we can just copy/paste into our custom module's install file.
* Note that this video was originally recorded in 2008, using the Drupal 6 version of the module, but the same features are available in the Drupal 7 version as well.