Re: [sqlite] What's the difference of "select * from tb" and "select "ID" from tb"?

I'm using SQLite 3.08 for Windows, SQLite.Net. Sqlite3Explorer(developed by delphi) can also see this situation.

Re: [sqlite] What's the difference of "select * from tb" and "select "ID" from tb"?

create table tb (ID varchar); Code example: IDataReader reader = command.ExecuteReader("select * from tb"); Console.WriteLine((string)reader["ID"]); While: IDataReader reader = command.ExecuteReader("select \"ID\" from tb"); Console.WriteLine((string)reader["\"ID\"]; // using reader["ID"] wi

[sqlite] What's the difference of "select * from tb" and "select "ID" from tb"?

A table: create table tb (ID varchar); When execute select * from tb, I can refer the column row["ID"], while using "select "ID" from tb", I must using row["\"ID\"']. Why Sqlite return column name as "ID"?