What are destructive statements in SQL?

B) Recreate a Table d) Recreate a View

Interview Candidate
Sep 4th, 2004
1
3626

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

priya

Dec 13th, 2005

recreate a table ofcourse. A view is just a SQL query stored and is executed everytime you access it. it does not store any values, just retieves them from the tables in the query. Where as table acutally has values stored so if recreated with data present it is destructive. If no data present then go ahead and recreate it.