databasesqlitecreate-tabletablecolumndbtable

How to create a table with no columns in SQLite?

I want to create table with no columns in sqlite3. It is possible in postgres database, but not in a sqlite3 one. Is there any way to achieve this, or is it simply not supported (maybe not in sql standard?) I have checked sqlite3 CREATE TABLE grammar and it seems, that there must be at least one column, but maybe I have missed something?

Solution

  • Zero-column tables aren't supported in SQLite. Or in the SQL standard either.