8.2. Raw Table Editing
Be careful! Manipulations without proper knowledge and skills in the "Raw Table Editing" section may lead to the incorrect database structure!
Current section was created to allow you to work with the database tables and fields directly.
On this page, you can see 2 panes: list of all tables available at your store on the left, and contents of the tables selected from this list on the right. Once you've selected a table, it will be shown on the right within 3 tabs.
"Data" tab displays all data stored in table cells, showing the actual table.
"DDL" tab displays table's data structure in Data Definition Language (any formal language for describing data or information structures of your Database). A subset of SQL instructions is common.
"Fields" tab shows a table, structured by fields.
The upper toolbar includes the options, which help to perform the basic operations, namely:
- Adding a new record. The form to fill appears after pressing the [Add] button:
- Edit field. An identical form with the similar filled data, which can be edited or modified, appears once you click on the [Edit] button.
- [Delete] button erases the selected field from a list of existing ones.
If you select more than one table, the content of each will be shown in a separate tab. No matter what tables are selected, there are some general export options available, such as Export to Excel/HTML and Edit-as-HTML option. First two options are typical in Store Manager. Edit- as-HTML option is active for the "Data" tab of the selected table. It opens HTML Editor to edit any text in table cells easier and see its actual view.