UniREST Solution 3.5

⌘K
  2. Home
  4. Docs
  6. UniREST Solution 3.5
  8. UniREST Server
  10. Database Manager
  12. Table Management

Table Management

The Database Manager has some tools for managing the existing tables:

  • change the name, the data-type and the options of a column;
  • change the order of the columns;
  • add new columns;
  • delete existing columns;
  • delete the selected records (from version 2.7)
Keep in mind that modify the structure of an existing table is a delicate operation, which you should do very carefully, especially if the table already contains data.

Add new record

Clicking the [ADD NEW RECORD] button you can manually add data to your tables. If a column requires a value (because it doesn’t accept NULL values) is marked as mandatory with a red asterisk.

However, keep in mind that this feature is provided just to have a complete set of management tools and it's not intended as a tool for filling tables with data. Indeed, the table records are expected to be managed by the REST APIs.

Modify table

Clicking the [MODIFY TABLE] button you can perform 3 distinct operations on the table.

UPDATE STRUCTURE
Allows changing the current table structure, as renaming the table and the columns, change the columns order and data type.

DELETE COLUMNS
Allows deleting the selected unwanted columns.

DELETE SELECTED ROWS
Allows deleting the selected rows. The id column has a checkbox for each table’s row.

Checking/unchecking the id checkbox will check/uncheck all the rows. Checking/unchecking a row’s id checkbox will involve that row only. Finally, by clicking the Delete Selected Rows button, the selected rows will be deleted.

Delete

Clicking the [DELETE] button you have a menu with 2 functions:

  • EMPTY YABLE
    To empty a table. In this case, only the table’s records are deleted and the ids generation starts from 1 again.
  • DELETE TABLE
    To delete a table from the Database. Do it only if you are absolutely sure of deleting a table. Once deleted, the table is lost and you can’t recover it (maybe you can do it through the administration panel of your hosting/server if it has such a feature)

Modify / delete single Records

An existing record can also be modified and deleted (clicking the pencil icon or the X icon at the end of each record).