Arpit Vaishnav
Arpit Vaishnav

Reputation: 4780

drope table mechanism in sql

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

Answers (1)

Brian Hooper
Brian Hooper

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

Related Questions