can't modify table in SQLCE Query

  • Thread starter Thread starter CafeCat
  • Start date Start date
C

CafeCat

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.
 
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
 
Back
Top