Using SQLite how do I index columns in a CREATE TABLE statement?

Viewed 73520

How do I index a column in my CREATE TABLE statement? The table looks like

command.CommandText =
    "CREATE TABLE if not exists file_hash_list( " +
        "id    INTEGER PRIMARY KEY, " +
        "hash  BLOB NOT NULL, " +
        "filesize INTEGER NOT NULL);";
command.ExecuteNonQuery();

I want filesize to be index and would like it to be 4 bytes

2 Answers
Related