Robert Treat <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
