[PLUG] SQLite (was: mdbtools)
Rich Shepard
rshepard at appl-ecosys.com
Thu Jul 24 13:54:36 UTC 2008
On Thu, 24 Jul 2008, Robert Citek wrote:
> sqlite's a great little RDBMS that is portable across Windows, Linux, OS
> X, and Solaris. But I have run into some quirks. For example:
>
> How do I drop a column?
> How do I rename a column?
Robert,
It's not possible now with the implementation of the ALTER TABLE command.
I believe that's on the to-do list of the developers.
> How do I change the column definition, e.g. text to integer?
Usually by changing the data type in there. Take a look at
<http://www.sqlite.org/datatype3.html>. Text values are quoted (single or
double) while integer values are not. If I had to make those changes I'd
dump the table and use a text editor to remove the quotation marks around
the values I wanted to change. Then, drop the original table and read the
revised one.
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
More information about the PLUG
mailing list