How can I tell if a column in my sqlite3 RoR database has a database index on it?

Question

How can I tell if a column in my sqlite3 database has a database index on it?

Answer 1

.schema

Answer 2

Look up the table definition in the schema, or the CREATE TAbLE statement in your DB creation script.