How delete all data from all tables in sql?



How delete all data from all tables in sql?..

Answer / Jai Srivastava

There is no direct way to delete all data from all tables in a SQL database at once. You would need to execute the DELETE command individually for each table, or create a script to automate this process.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the advantage of nosql?

1 Answers  


What is example of database?

1 Answers  


How can we implement rollback or commit statement in a trigger?

1 Answers  


How can you load microsoft excel data into oracle? : aql loader

1 Answers  


What is indexing oracle sql?

1 Answers  


What is difference between procedure and trigger?

1 Answers  


How many sql are there?

1 Answers  


how many columns can be used for creating index? : Sql dba

1 Answers  


Is the primary key an index?

1 Answers  


What is a delimiter in sas?

1 Answers  


What is audit logout in sql profiler?

1 Answers  


I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,


Categories