Hi Andrea, There are several commercial products that will provide this capability along with many other schema maintenance functions not available in sqlite itself. I have one such available, SQLiteAdmin, at www.lcsql.com. Pete lcSQL Software <http://www.lcsql.com>
On Sun, Sep 9, 2012 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > Message: 9 > Date: Sun, 9 Sep 2012 11:19:21 +0200 > From: Andrea Peri <aperi2...@gmail.com> > To: sqlite-users@sqlite.org > Subject: [sqlite] Alter table constraint question > Message-ID: > <CABqTJk-URe6sGd143HQ_9pso1C8= > nxznqt0f+jyqmnyqbda...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, > > I'm an user of sqlite with the spatial extension "spatialite". > > I see the sqlite db allow to define a constraints when are in the creating > phase of the table. > But is not possible to add or drop a constraint after the table is created. > > In the GIS data the availability of the constraints is a really useful > think, > but if not so smart to have they locked to the creation phase. > > So it is a continuous drop and recreate the table. > > This is a really time consuming work. > > So I like to understand if the not availability of the > both > > Alter table add constraint ... foreign key (..) > Alter table drop constraint ... > > is a technology choose. > and how much complex could be to add both to the sqlite sql. > > Thx, > > Andrea > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
