SQLite Forum

SELECT * Column Sequence / Order (not ORDER BY)
Login
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:

https://docs.microsoft.com/en-us/sql/relational-databases/tables/change-column-order-in-a-table?view=sql-server-ver15

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.

Thanks,
-Rich