Anyone know how to modify table in SQLCE query?

it can add new or delete column, but can't modify a exist column. why?

I mean in the Sqlce Query program on PPC.

I know use sql can do it. But I just don't know why this offical database
tool don't provide this basic function.


"Alex Yakhnin [eMVP]" <(E-Mail Removed)> wrote in message
news:1ac201c38428$c0b261a0$(E-Mail Removed)...
> You should be able to use ALTER TABLE ddl statement.
> Check the "SQL Server CE Books Online" for exact sintax..
>
> --
> Alex Yakhnin, MVP
> IntelliProg, Inc.
> http://www.intelliprog.com
>
>
>
> >-----Original Message-----
> >Anyone know how to modify table in SQLCE query?
> >
> >it can add new or delete column, but can't modify a exist
> column. why?
> >
> >
> >.
> >

Because unfortunately T-SQL syntax does not provide for column
modifications. The only way to modify a column is to copy the key and the
column data to the temporary table, drop the column, recreate it and
repopulate from the temporary table. I suppose the SQL CE Query dfevelopers
considered this to be too much for a small-footprint tool

"CafeCat" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I mean in the Sqlce Query program on PPC.
>
> I know use sql can do it. But I just don't know why this offical database
> tool don't provide this basic function.
>
>
> "Alex Yakhnin [eMVP]" <(E-Mail Removed)> wrote in message
> news:1ac201c38428$c0b261a0$(E-Mail Removed)...
> > You should be able to use ALTER TABLE ddl statement.
> > Check the "SQL Server CE Books Online" for exact sintax..
> >
> > --
> > Alex Yakhnin, MVP
> > IntelliProg, Inc.
> > http://www.intelliprog.com
> >
> >
> >
> > >-----Original Message-----
> > >Anyone know how to modify table in SQLCE query?
> > >
> > >it can add new or delete column, but can't modify a exist
> > column. why?
> > >
> > >
> > >.
> > >
>
>