Ron,
> I don't know about other commercial RDBMSs, but some have this:
> DROP TABLE <foo> CASCADE
>
> Thus, any views, constraints, triggers, etc, that refer to <foo> get
> dropped automatically when the table is dropped. This seems to be a
> step beyond what you mention for v7.4. (Of course, all the deleteted
> objects are listed as they are deleted, so you can easily recreate
> them...
Hmmm. Not sure this is planned; I personally would not want to *ever* use a
"DROP TABLE CASCADE". Not up to me, though.
--
-Josh Berkus
Aglio Database Solutions
San Francisco