ONE Active Server Pages Product Home Page Developer Site Version


Changing Table Design

Use the following procedure to change table design for an existing table.

To change table design

  1. Open DBMS using the URL provided by your Sun ONE ASP administrator.

  2. Do one of the following:

    • Expand the Tables node, click a specific table in the left pane, and then click the Design table tab in the right pane.

    • - or -

    • Click the word Tables under a database connection in the left pane, and then click Design table in the right pane in line with the table you want to change. The table displays on the Design table tab by default.

    • The Add new table page displays, opening on the Design table tab by default. This page is used to design the table.

  3. Make changes as desired (columns with changes will be selected by default). Note the following:

    • To add more columns to the table, click Add more columns at the bottom of the page. Ten blank rows of input boxes will be added.

    • Default settings based on data type are provided for some fields. For descriptions of each field and detailed information about MySQL conventions and rules, consult MySQL documentation at the following URL (particularly the language reference section):


  4. Click Save to submit the selected information and save the table, or Reset to revert to the data that was last saved.

Note icon Note To remove entire columns, select the columns and click Remove selected fields.