Which single SQL command would you use to permanently remove all the - ProProfs Discuss
Menu
SearchAsk a Question+ Ask Question
Advertisement
  1. Oracle
  2. Oracle SQL

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?

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?<br/>

Change Image    Delete

Asked by Karthicksugadev, Last updated: Nov 09, 2024

+ Answer
Request
Share
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 

More Oracle SQL Questions

Ask Your Own Question
Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
CancelLoader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
CancelLoader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
CancelLoader

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