Change schema for existing SDF

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



Created a SDF in VS2008. Saved it to VSS and saw that a field was
misspelled. Welp used Server Explorer in VS2008 to connect to it but could
not modify the schema field names at all.
Then went into SQL 2005 and tried to connect to it and it said if it was CE
3 or later i'd need to run compact/repair on it to be able to open it. All
the help points to programmatic manipulation. How do I best modify the
field name for an SDF?

TIA
Harry


.