Dump Specific Table Using Dump Command
In this section we will see how we can use the dump command to dump a specific table of the database into a text file, not the entire database.
Sometimes, we might need to dump only a specific table into another file, not the entire database. For that, the syntax will change a bit. We need to provide the output filename as last time, but with the dump command, we need to provide the name of the specific table, which we want to dump.
Syntax:
.output <Location of File with Filename.Extension>
.dump <Table_Name>
Query:
Here, we will dump just the Employees table into a file named Employee_Table.txt
.output C:\Users\user\Downloads\SQLite\Employee_Table.txt
.dump Employees
Explanation: Here, just like the last time we are using the output dot-command and providing the entire path of the file in which we want to store the results / commands. But the difference is, here we just want to store the commands used to create and populate a certain table of the database, not the entire database. This is why we need to provide the name of the Table after the DUMP command to signify that we want to store the commands related to that table only.
Content of the Employee_Table Text File After Dumping:
Explanation: As we can see, only the details of the Employees table has been saved / dumped. Not the entire Database.
SQLite Dump Command
SQL stands for Structured Query Language, which is the common language (with minor changes) used to manipulate relational databases. It is used to create, store, retrieve, and manipulate databases and tables. SQLite is a lightweight version of SQL with some major changes, it doesn’t have a separate server, it is not a common language, and it can’t connect with databases like Oracle or MySQL server.
In this article, we will learn about DUMP Command in SQLite in depth along with its examples, practical implementations, and so on.
Contact Us