Dropping Objects
From: Brandon Duncan <bduncan_at_pietechnet.com>
Date: Thu, 25 Jan 2001 14:13:53 -0500
Message-ID: <94pu66$fuh$1_at_bob.news.rcn.net>
Date: Thu, 25 Jan 2001 14:13:53 -0500
Message-ID: <94pu66$fuh$1_at_bob.news.rcn.net>
Hi,
I actually have two questions.
One : Is there a command which drops all objects associated with a
Database/User?
Two : Does the command "DROP TABLE X CASCASE CONSTRAINTS" drop all
objects associated with the table X (Indexes, Constraints, triggers, ect) or
just the constraints? If it doesn't drop everything, what happens to the
orphaned objects? If it doesn't drop everything associated with table X,
how do you drop all objects associated with table X?
Thanks,
Brandon
Received on Thu Jan 25 2001 - 20:13:53 CET