Reputation: 4780
When a table is dropped using a simple DROP statement, SQL performs some more operations simultaneously, select all the valid operations?
a. Removes all rows from the table
b. Drops all the table's indexes
c. Removes all dependent views
d. Removes all dependent procedures
Upvotes: 0
Views: 424
Reputation: 22084
DROP will do (a) and (b), but not (c) and (d) which can lead to trouble later if care isn't taken.
Upvotes: 2