[sqlite] Re: How to change or add fields to a table ?

[Igor Tandetnik]

Stef Mientki <[EMAIL PROTECTED]> wrote:
Are there SQL commands to add or change the fields of an existing
table, or should the table completely be rebuild ?

Some limited changes may be done with ALTER TABLE statement:

http://www.sqlite.org/lang_altertable.html

For anything else, you would need to create a new table and migrate 
data.

Igor Tandetnik 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------