[OT] Table Creation Syntax + Visual SQL Query Builder // A GREAT Mac Cocoa MYSQL tool - Donationware

Ruslan Zasukhin ruslan_zasukhin at valentina-db.com
Thu Jan 6 14:29:12 EST 2011

On 1/6/11 9:22 PM, "Bob Sneidar" <bobs at twft.com> wrote:

> Are you saying that an Alter Table command will create a second record with
> the alter table syntax in it? I didn't know that.

Actually as I know, Sqlite have no normal ALTER Table

> It throws a bit of a wrench
> in my works, but then again the best practices for sqLite table mods is to
> create a new table with the new structure from scratch and port the old data
> in from the old table.

This is "best" practice, because no ALTER.

And our guys have spend days to workaround this behind the scene.
Yes, they do create new table, copy records, trash old ...

> There are a lot of things you cannot do with Alter
> Table in sqLite, as was discussed in another thread, so maybe this is a
> non-starter anyway.

> Bob
> On Jan 6, 2011, at 11:11 AM, Ruslan Zasukhin wrote:
>>> This will give me all the Create Table syntax for every table in the sqLite
>>> database I access.
>> I see, Bob,
>> You are using sqlite_master  system table to extract original
>>    create table ... command
>> Interesting, if this is changed on any ALTERs ...
>> Although it seems there is no alters ...

Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information

[I feel the need: the need for speed]

More information about the Use-livecode mailing list