Skip to end of metadata
Go to start of metadata

Follow these step-by-step instructions for managing the database table of a database form block.

Step-by-step guide

Refer to the appropriate instructions for the desired database table management.

Locate a database table to create, update, export or clear

  1. Log into the Database Services Management System.
  2. Input the web address of the database form webpage into the Form Address field.


  3. Select Lookup Form to finish.

Locate a database table to only export or clear

  1. Log into the Database Services Management System.
  2. Input the web address of the site where the form is located into the Site Address field.


  3. Select Lookup Database.


  4. Select the Select link in the row with the desired database table name to finish.

Create or update the database table

  1. Locate the desired database table in the Database Services Management System.
  2. Select Update Table Structure.


  3. Review the Existing Structure table and the Proposed New Structure table (differences between them will be marked in red).
  4. Select Update Table to finish.

Export the database table

  1. Locate the desired database table in the Database Services Management System.
  2. Select Export Records.


  3. Download the prompted Excel document of the current database table records to finish.

Clear the database table

Warning

Since database records cannot be recovered after clearing them, we highly recommend exporting the current records before clearing the database table.

  1. Locate the desired database table in the Database Services Management System.
  2. Select Clear All Records.


  3. Select Ok to finish.




For questions or comments, contact the Computer Services Help Desk
HelpDesk@MissouriState.edu
417-836-5891