Posted February 05, 2020 11:59:52With the new SQL 10.1.0, we can delete our database data in Excel with just one command.
To delete a single database from the Excel 2016 database, simply right-click on it, and select “Delete Database”.
There are a couple of other options you can use for deleting databases, including the “Delete All” option.
You can also delete the database in the same way as you delete other files and folders.
The new SQL update also introduces a new data source, and we’ll talk more about that in a moment.
We’ve talked a lot about how you can quickly create and edit a database in Excel, but if you’re looking to delete a database, the old way to delete it in Excel is to open a file in Excel and select the “delete all” option from the “database” section.
To delete a particular database, click on it.
This opens a dialog that will ask you to select the database you want to delete, and then click OK.
Then, you’ll be asked to select which database to delete.
If you click on the “all” option, Excel will delete all of the databases in your Excel 2016 environment.
You can also specify an arbitrary database by selecting “Database name” and then selecting the “option” that starts with the database name.
This is where you can specify any of the following options:For example, if we were to delete the data for a particular person, we could type in the following in our Excel 2016 window:For more information on deleting databases in Excel 2017, check out our post on how to delete your database data from Excel 2017.