Sun ONE Active Server Pages Product Home Page Developer Site Version
 

ContentsPreviousNextIndex



You are here: Using Database Tools > DBMS > Working with Tables > Updating Existing Tables > Deleting Data

Deleting Data

Use the following procedure to delete data (records) from an existing table. A record cannot be recovered after it has been deleted.

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

  2. Do one of the following:

    • Expand the Tables node and click a specific table.

      • - or -

    • Click the word Tables under a database connection in the left pane, and then click Edit data in the right pane in line with the table you want to change.

      • The table opens on the Edit data tab by default.

  3. Select a specific row or rows, and then click Delete selected rows. To select all rows, select the check box in the very first row (the box in the title bar not associated with a record).

    4. A message displays, asking you to confirm deletion. A record cannot be recovered after it has been deleted.

Note icon Note The Edit data tab also provides a navigation bar used to navigate records. When a table is open, the first 20 rows of records are displayed by default. To change the number of records displayed, change the number in the #Shown box, and then click Refresh. If the total number of records exceeds the number shown, use the navigation buttons (< > symbols) in the lower right corner to navigate through the records. Clicking << or >> takes you to the first or last set of records. Records are displayed in increments of the number in the #Shown box.

See also:

Changing Table Design


ContentsPreviousNextIndex



Copyright © 2003 Sun Microsystems, Inc. All rights reserved.