text: /* **********************************************
   * Simple Table Creation - Columns and Primary Keys
   *
   * School Transcript
   *  Version 1.0.0
   *
   * Author: Dan Gilleland
   ********************************************** */
  -- Create the database
  IF NOT EXISTS (SELECT name FROM master.sys.databases WHERE name = N'SchoolTranscript')
  BEGIN
      CREATE DATABASE [SchoolTranscript]
  END
  GO
  
  -- Switch execution context to the database
  USE [SchoolTranscript] -- remaining SQL statements will run against the SchoolTranscript database
  GO
  
  -- Create Tables...
  