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

[Bob Sneidar]

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. 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. 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