Robert Treat <xzilla@users.sourceforge.net> writes:
> Just out of curiosity, do any of the SQL specs deal with 0 column
> tables? I can't recall any dbms supporting a create table command that
> didn't require at least 1 column.
Actually, in SQL92 11.17 <drop column definition> I find
3) C shall be a column of T and C shall not be the only column of T.
SQL99 has the same rule. So they indeed prefer the no-drop wart to the
table-with-zero-columns wart. I have to disagree with that conclusion
though ...
regards, tom lane