Use the ALTER TABLE command to make your structure changes.

>> I want perform all operation client side.

Don't you mean "server" side?

-Mike

>Hi
>
>Everybody
>
>There are several table in my database sqlserver 2000. Now i want change table field data type and add other field in table . My problem is that
>there are lot of record in the database. How to convert database with new field and recquired datatype. I want perform all operation client side.
>
>
>Thanks