> > SQLite will complain because of the duplicate index names, but in > > other database packages it will be accepted. You then have to > > specify the table name when deleting indexes. > > The only database I'm aware of that does this is SQL Server. > Don't overgeneralize. :)
No worries - I was just going from the list of syntaxes for this from the original posting - see http://www.w3schools.com/SQL/sql_drop.asp Shall we say "but in *some* other database packages" ? ;-) Hugh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users