Question

Which one will delete the table data as well as table structure?

Answer 1

TRUNCATE TABLE EMPTIES IT, BUT LEAVE ITS STRUCTURE FOR FUTURE DATA.REMOVE ALL ROWS FROM THE TABLE WITHOUT LOGGING THE INDIVIDUAL ROW DELETIONS.



Truncate table is similar to delete statement with no where clause; however truncate table is faster and uses fewer system and transection log sources.

Hope this helps you If it helps please mark it as brainliest answer