sqlite3: creating table with no columns

sqlite create-table
gruszczy picture gruszczy · Dec 31, 2010 · Viewed 7.2k times · Source

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?

Answer

dan04 picture dan04 · Dec 31, 2010

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

Related questions

Create table in SQLite only if it doesn't exist already

I want to create a table in a SQLite database only if doesn't exist already. Is there any way to do this? I don't want to drop the table if it exists, only create it if it doesn't.

Read More
android sqlite CREATE TABLE IF NOT EXISTS

Having a little problem with creating new tables. When I use the CREATE TABLE command my new tables form as they should, but when I exit the activity the app crashes and I get a TABLE ALREADY EXISTS in the …

Read More
SQLite composite key (2 foreign keys) Link table

I've read the rather cool styled BNF grammar for the SQLite create table statement found here: http://www.sqlite.org/lang_createtable.html I was wondering how I'd go about creating a link table between these I have one table, …

Read More