[SQL] Modify column type

Is there a way to modify the type of an existing column? All I actually want to do is extend the length of the type from a VARCHAR(6) to VARCHAR(100). Column | Type | Modifiers +---+ ema

[SQL] Alter Table problems

I am attempting to add a few attributes to an existing table that already contains data. The problem that I am having is that the new attributes that I want to add need to be forgein key references to other tables. I can't figure out how to create the attribute with a reference to another table.