Which single SQL command would you use to permanently remove all the - ProProfs Discuss
Advertisement

Which single SQL command would you use to permanently remove all the data from the student table, and you need the table structure in the future?

This question is part of ORACLE SQL
Asked by Karthicksugadev, Last updated: Nov 24, 2020

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

John Adney

John Adney

John Adney
John Adney

Answered Oct 09, 2017

You have decided to permanently remove all the data from the STUDENT table and you need the table structure in the future. Which single command performs this?

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered May 20, 2017

TRUNCATE TABLE student;
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.