Re: How to change a field name?

Hadi wrote:
>
> Is there a quick way to change the name of a column/field in another
> user's table without having to create a copy of the table minus the
> column to be changed, then adding the column back in with the new name?

You can't change the name of an existing column, but a little easier than the above would be to create a view to the table with the names of the columns changed. Another way is to create a new table from the old one and change the column (but that would involve duplicating the data and it doesn't sound like you want to do that).

• TRW