ONE Active Server Pages Product Home Page Developer Site Version


Working with Tables

The DBMS application can be used to perform data maintenance and query a database using SQL statements. Users with full access to the MySQL database can add, update, and delete tables.

Table names are displayed in the left pane of the DBMS interface, and corresponding properties are displayed in the right pane. Clicking the word Tables in the interface displays a list of tables that have been created and saved.

You can also click the plus (+) sign to expand the list of tables. Clicking a specific table displays that table. This section describes how to add, update, and delete tables.

Note icon Note The tables displayed and the actions you can take in DBMS are governed solely by the privileges granted to you by the MySQL database administrator.

In this section:

Data Validation

Adding New Tables

Updating Existing Tables

Deleting Tables