Simon, Thanks!
Vance on Mar 07, 2013, Simon Slavin <slav...@bigfraud.org> wrote: > > >On 7 Mar 2013, at 5:51pm, ven...@intouchmi.com wrote: > >> Simon, >> >> Thanks for the detailed response! > >You're welcome. > >> Can I say: >> Create INDEX c on myTable(c); > >Well, technically yes you can. But to keep your code clear I would not have >an index >name the same as a column name. For instance, if you start trusting index >names >like that you're going to be very confused if you accidentally do > >Create INDEX c on myTable(b) > >Your index names can be anything you like, but SQL itself never looks at the >name >of the index, just which table and columns it indexes. The only time SQL >cares about >the name of the index is if you later issue a 'DROP INDEX' command and have to >get >the name right so it knows which index to drop ! So I deliberately pick names >for >indexes that I'd never pick for a column. > >Simon. >_______________________________________________ >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
