Thanks for the replies.
Actually I wanted to add a new field into a table. Or maybe delete a field from
the existing table.

What do you meant by running a script. Sorry I'm pretty new to SQL Server.
If possible could anyone enlighten me by quoting me some examples?Thnks.

>It depends on the type of change you want to make. If you want to add a field which will accept NULL then you can if the new field can not accept NULL you have to drop the table and recreate it (Like Michel said use a script because you want to keep the data.)
>
>What kind of change do you want to make?