Markus Hoenicka <markus.hoeni...@mhoenicka.de> wrote: > Quoting Igor Tandetnik <itandet...@mvps.org>: > >> >> Well, you get that 1 in the last column, indicating the column is in >> fact part of a primary key. So, if it's INTEGER, and it's the only >> column marked PRIMARY KEY, then it's the special one. >> > > Your reply seems to imply that I might end up having several INTEGER > columns with the pk column set to 1.
Of course: create table t(x integer, y integer, primary key(x, y)); > Does that mean that I cannot > unambiguously identify that one autoincrementing column? You can: none of them. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
