SQLite Forum

SELECT * Column Sequence / Order (not ORDER BY)
Trying to verify that SELECT * will always return results based on the column order in the CREATE TABLE statement.  From my reading, SQL should use the column ordinal position for SELECT * but I don't know how to check this in SQLite.  Also, threads like this make me nervous:


See caution area.  I realize this is SQLServer but I'd like to know without a doubt if SELECT * has a well defined returned or if I really need to list all the fields out.