Re: [sqlite] Why can't SQLite drop columns?

[gregorinator]

On 10/8/12, Petite Abeille  wrote:
> How do they deal with constraints? triggers? indexes? others?
> If this was as straightforward as a 'create table bar as select a, b, c from
> foo; drop table foo; alter table bar rename to foo;', we would most likely
> not having this conversation :)

I'm sorry for not being more comprehensive in my answer.  Also, as I
pointed out, I can only speak for SQLiteStudio -- there are other
tools; you need to investigate for yourself.

When dropping a column from a table, SQLiteStudio preserves the
original table's primary key, foreign keys, null constraints,
defaults, check constraints, unique constraints, and indexes on
columns other than the one being deleted.  At _least_ that much.  I
confess I've never done an exhaustive exploration of what it preserves
-- I only look for the things I need preserved in my applications.  I
haven't come across anything I need that it doesn't preserve, but I
confess I haven't tried it with triggers or that really powerful SQL92
"others" functionality that you asked about. :)

Honestly, I wouldn't even have recommended SQLiteStudio or tools like
it if my experience was that all it did was "create table bar select
from foo", but I can see it would have made my earlier post more clear
if I had mentioned this from the start.  And, as I said, SQLiteStudio
isn't the only SQLite db manager out there; I suggest that you take
them each for a spin and come to your own conclusions.  But my point
was that there are third party tools that might be able to give you a
robust DROP COLUMN capability -- and maybe other functionality that
SQLite can't do itself -- without your having to reinvent the wheel.
Might.

gs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why can't SQLite drop columns?

[gregorinator]

Some freeware SQLite tools, such as SQLiteStudio, allow you to drop
columns (they do it by copying the table, but it's transparent to
you).  If you don't need to drop the column programmatically, as part
of a bigger automated process, it works and you don't have to code
anything.

gs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI for SQLite

[gregorinator]

I've been happy with SQLite Studio:

http://sqlitestudio.one.pl/

One of the things I like about it is that it can do table edits not
supported by SQLite's ALTER TABLE -- it automatically creates a new
table and copies the existing data.  Saves me a lot of effort.  Other
SQLite managers may be able to do this, too -- I don't know -- but
after using SQLite Studio I would consider this a must-have feature.

gs

On 3/7/12, BareFeetWare  wrote:
> On 08/03/2012, at 8:47 AM, Rose, John B wrote:
>
>> We are new to SQLite and have experimented with a few GUIs, Firefox
>> plugin, SQLite DB Browser, and Navicat. Is there a single GUI that is
>> considered the best, with the most features?
>
> Some time back, I compared several SQLite GUI editors, mainly for Mac, and
> published at:
> http://www.barefeetware.com/sqlite/compare/?ml
>
> Tom
>
> Tom Brodhurst-Hill
> BareFeetWare
>
> --
> iPhone/iPad/iPod and Mac software development, specialising in databases
> develo...@barefeetware.com
> --
> Twitter: http://twitter.com/barefeetware/
> Facebook: http://www.facebook.com/BareFeetWare
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there way to modify table structure after > initial definition ?

[gregorinator]

On 2/21/12, Andrew Barnes  wrote:
>> You need to study the ALTER TABLE statement and its limitations.
{snip}
> SQLLite uses dynamic typing so you can put data of any type into any column.

Modification of the table structure might not be necessary in this
case, but in a general case, SQLite's ALTER TABLE command is very
limited.  One solution is to use a database administration tool that
supports a more full-featured table modification capability.  I use
SQLite Studio (http://sqlitestudio.one.pl) -- there are probably
others.  It allows removing and creating primary keys, foreign keys,
and many, many other table modifications that ALTER TABLE does not.  I
assume that "under the hood" it's building a new table and copying the
data from the old one, but all that's seamless to you.  It's made my
life a lot easier.

gs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users