HP 3000 Manuals HP 3000 Manuals
Maintaining Tables (DBA) Table maintenance involves adding, deleting, and merging tables, or adding, deleting, merging and dividing columns. You can also restructure a table by merging it with another table or dividing it into two tables. See the "Database Creation and Security" chapter for a description of creating new tables. If your tables use integrity constraints, rules, or procedures, the operations described in the next few sections can have unexpected consequences. For more information, see the section "Maintaining Sets of Interrelated Objects" later in this chapter.[REV BEG] Changing a Table's Locking Behavior You can use the ALTER TABLE statement to change a table's type. You can also optionally reset the implicit grant of authority to the special user PUBLIC for tables that were created PUBLIC, PUBLICROW, or PUBLICREAD. When you use the ALTER TABLE statement, you change the table type permanently. To change it back to its original state, you must issue another ALTER TABLE statement. (To change locking behavior for the duration of a transaction, use the LOCK TABLE statement.)[REV END]