>>Just new to SQL Server 6.5 ...
>>
>>Is it possible to modify the structure of tables
>>in SQL Server after the table is created? I don't
>>find any delete button in the Enterprise Manager to
>>delete columns from the table designer.
>>
>>I can think of only one solution: hit the syscolumns
>>table. But what if I want to change the names of
>>certain fields in a table? Must I doing something
>>like create new_table and append from old_table?
>>
>>Are there any freeware/shareware for use with SQL
>>servers 6.5?
>
>You can add new fields only (probably, you can also change name of existing fields but not datatype, length etc.). If you want to change something, then you can 'Generate Script' then edit it (basically it's CREATE TABLE... command), drop existing table and generate new one.

You can actually use a passthrough statement to do an ALTER TABLE. I would have to look at the SQL docs to give you the exact syntax, but that would be the general realm.