Thread: ALTER TABLE vs. CREATE TABLE

ALTER TABLE vs. CREATE TABLE

From
Brian Minton
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

is it a bug or a feature that I can use ALTER TABLE ADD COLUMN to
add a column of a type that I can't get with CREATE TABLE?
Similarly, that I can drop *all* columns from a table, but can't
create a table with no columns?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE9/PbVcieIIFcDdHIRArbcAKCgrMNhPBC6F4HABlD4KfHKQUUewwCdHOQg
yC5N3Ou304KHFVFOBMyH+Ug=
=WM20
-----END PGP SIGNATURE-----