Sqlite: SELECT * BUT id FROM Table

No, you cannot do that.

You list the ones you need, or you accept that the result set contains one more column than you need.

Absolutely, no.

But here's a workaround. Create a VIEW of the table, eg

CREATE VIEW ViewName
AS
    SELECT col1, col2, col3, .... -- don't select the column name you want to hide
    FROM tableName;

once the VIEW was created, you can now call it,

SELECT * FROM ViewName

Related