"Hugh Gibson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I see from the syntax of DROP INDEX that a table name is not > specified. Are there any plans for adding a way of specifying the > table? > > I note that SQLite prevents creation of indexes with the same name, > regardless of table.
Quite. So it's unclear why you would want to be able to mention table name in the DROP INDEX statement. > Also, is there any good reason for creating a primary key versus > creating a separate index afterwards? INTEGER PRIMARY KEY column has a special meaning in SQLite: http://sqlite.org/autoinc.html Other than this one special case, a PRIMARY KEY is implemented internally simply by creating an index. Functionally, making a column (or a group of columns) PRIMARY KEY or UNIQUE has the same effect as creating a UNIQUE index on the same columns. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
