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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top