"Gino LV.Ledesma" wrote:
>
> >> hello all!
> >>
> >> how to drop columns in postgresql?
> >
> > according to pg expert Mike, hindi pwede. Alam ko hindi rin pwede sa
> > Oracle.
>
> Yep... Learned in databases class that dropping tables as a feature has
> been "dropped" or probably never implemented in the first place was
> because of the problems that'd arise when you tables are dropped, namely
> that of broken relations and the like.
The question was about dropping columns. DROP TABLE is and has always
been a SQL. Referential integrity is often implemented via database
triggers, so when a table with a primary key referenced from other
tables is dropped, the trigger(s) is/are dropped as well. The database
remains consistent.
Brian
_
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]
