How do you create an index on the tables themselves in a database?
I'm using APSW to wrap my SQL code in python, like so:
connection=apsw.Connection("dbfile"); cursor=connection.cursor()
cursor.execute("create table foo(x,y,z)")
cursor.execute("create table bar(a,b,c)")
cursor.execute("create table baz(one,two,three)")
I plan on using a gui framework to display these table names (and
subsequently their columns and rows). I would also like to sort these
table names by different criteria.
Is there a way to create an index on the tables themselves to be used for
sorting--e.g.:
cursor.execute("CREATE INDEX index_name ON foo")
Thanks in advance.
No comments:
Post a Comment