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 |
What is the advantage of nosql?
What is example of database?
How can we implement rollback or commit statement in a trigger?
How can you load microsoft excel data into oracle? : aql loader
What is indexing oracle sql?
What is difference between procedure and trigger?
How many sql are there?
how many columns can be used for creating index? : Sql dba
Is the primary key an index?
What is a delimiter in sas?
What is audit logout in sql profiler?
I want to know last five transactions or records from emp table, from now?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)