SQLite db / other db; table without column?

Databases
1

When creating a SQLite / Database, why does the newly created table require a column before it can be saved? This is illogical and backwards as you can create a table without columns in other languages… Oh, and the DB editor is a pain. You can’t delete tables/columns using the delete/backspace button (deletes the DB), even when the navigator doesn’t have focus; and any changes are not saved if you exit the DB via the navigator. Hell, even saving your project DOES NOT save the DB, which is downright stupid.

Please provide a DB editor that is truly “for the rest of us”.

2

[quote=58715:@Shane Gibbs]
Please provide a DB editor that is truly “for the rest of us”.[/quote]

There are plenty of others (free/paid) alternatives (has been discussed enough on the forums). I’d rather have them get rid of the DB editor at all and focus on what they can do best: the IDE/Framework/Compiler. Certainly not a DB editor.

3

See following threads.
Favorite SQL editor?
browse a Database
There might be more threads about this subject.

4

Because the “CREATE TABLE” statement requires columns

http://sqlite.org/lang_createtable.html

5

Out of curiosity, what is your use case for a table with no columns?

6

Really doesn’t matter as SQLite doesn’t support a create table with no columns hence the editor doesn’t either

7

I get that; my question is how/why one would want to be able to create a table with no columns in any database. Presumably, the OP has some purpose in mind that would be served by that capability…

8

I suppose but I don’t think ANSI SQL allows it so it really won’t matter as you can’t create it anywhere whether you have a use case or not

9

I wondered then, what this claim refers to…

10

ANSI SQL doesn’t let you actually create a table that way.
Tools MAY make it appear that you can.
I know a couple old language that had their own db as part of the language and they would but they had some very specific uses.
They certainly weren’t ANSI SQL or any kind of SQL then (don’t think they are to date)

11

[quote=58879:@Norman Palardy]ANSI SQL doesn’t let you actually create a table that way.
Tools MAY make it appear that you can.
I know a couple old language that had their own db as part of the language and they would but they had some very specific uses.
They certainly weren’t ANSI SQL or any kind of SQL then (don’t think they are to date)[/quote]

Your right. I’ve been reviewing other SQL code (PHP, etc) and when creating a table, they also insert columns. I guess my best bet would be to manually create the tables and columns via code rather than the editor.

[quote=58778:@Paul Sondervan]See following threads.
Favorite SQL editor?
browse a Database
There might be more threads about this subject.[/quote]

Thanks for those.

12