title: Creating a table in SQL Server Express
body: <p>I'm trying to setup a SQL database for a local program management and install system. I think i've created a basic serviceable schema that should work, but i'm unsure how to translate it to a CREATE TABLE command. Can someone help me with the translation and/or point me to resources that will?</p>
  
  <p>Schema:</p>
  
  <pre><code>Programs(
      progID[key] (integer/index field?),
      name (text),
      desc (text), 
      iconFile (path to file),
      installScript (path to file))
  </code></pre>