change the datatype of an existing column of a table in sqlce database

G

Guest

how do I change the datatype of an existing column of a table in sqlce database in a PDA application which is developed with .net copactframework.Please mail me the soluation in my mail id.
 
G

Guest

Gopal

I have replied to the newsgroup rather than your e-mail address to share the information with other people

Check the SQLCE documentation, you will need to use 'ALTER TABLE'
I don't know if you can change the data type of a column, you may have to drop the column and add it again

Chris


----- Gopal Haldar wrote: ----

how do I change the datatype of an existing column of a table in sqlce database in a PDA application which is developed with .net copactframework.Please mail me the soluation in my mail id.
 

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

Converting table info in sqlce3.5 database to 3.1 2
Help about choosing efficient database technology 3
XML to SQLce 4
sqlce & "The column name cannot be resolved to a table" 1
sqlce concurrency issues 1
Learner : Unable to connect SQLCE 0
Make a setup.exe with SQLCE 1
SQLCE performance from .NET CF v2.0 8

Top