On Wed, 18 Jul 2001, Brian Baquiran wrote:
..
> Then you still have to ALTER TABLE to add constraints and defaults,
> re-create the indexes that are created automagically, re-establish any
> referential integrity constraints referring to other tables, etc.
>
> Much easier just to get it right at CREATE TABLE time, or learn to live
> with the overhead of the unused columns.
Yes that is correct. People really shouldn't use ALTER TABLE at all, in a
perfect world. =)
--
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GE d(-) s: a-25 C++++ UBLSI++++$ P+++ L+++>++++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
------END GEEK CODE BLOCK------
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
