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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help about choosing efficient database technology 3
Converting table info in sqlce3.5 database to 3.1 2
XML to SQLce 4
sqlce & "The column name cannot be resolved to a table" 1
How to create a primary key 1
.NET CF SQLCE & Chinese characters 4
SQLCE 3.5 and Management Studio 2005 9
SQLCE nvarchar length 5

Back
Top