Creating a sqlce index in code?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: mikeb (mike_at_nohostanywhere.com)
Date: 02/18/05 

Date: Thu, 17 Feb 2005 17:23:20 -0800

Suppose I have the table below - I'm new to sqlce and am wondering what I
need to do to add an index to the table on trackno+factory. ??

sqlCreateTable.CommandText = _
   "CREATE TABLE TestTable " & _
            "(" & _
            "trackno nchar (20), " & _
            "factory nchar (10), " & _
            "sealno nchar (40), " & _
            "length nchar (04), " & _
            "add_date datetime " & _
            ")"

sqlCreateTable.ExecuteNonQuery()