User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 xi
Define File Attributes......................................................................................12-3
Add Columns..................................................................................................12-4
Change Column Attributes..............................................................................12-7
Delete Columns ..............................................................................................12-7
Change Column Sequence...............................................................................12-8
Creating Table Partitions.................................................................................12-8
Creating Table Constraints..............................................................................12-8
Save the Table ..............................................................................................12-11
Altering a Table.................................................................................12-11
Choose a Table .............................................................................................12-12
Display Dependencies ................................................................................... 12-13
Change File Attributes ..................................................................................12-13
Change Security............................................................................................ 12-14
Add Columns................................................................................................12-14
Dropping a Table ..............................................................................12-14
Choose the Table .......................................................................................... 12-15
Display Dependencies ................................................................................... 12-15
Drop the Table.............................................................................................. 12-16
Renaming a Table..............................................................................12-16
Choose a Table .............................................................................................12-17
Display Dependencies ................................................................................... 12-17
Enter the New Name.....................................................................................12-18
Rename the Table ......................................................................................... 12-18
Managing Table Constraints..............................................................12-18
Adding Constraints .......................................................................................12-18
Modifying Constraints...................................................................................12-20
Dropping Constraints....................................................................................12-22
Managing Constraint Comments ................................................................... 12-23
Managing Help Text..........................................................................12-25
Choose the Column.......................................................................................12-26
Add, Change, or Delete Help Text ................................................................12-26
Save the Help Text .......................................................................................12-26
Managing Table Comments...............................................................12-27
Choose a Table .............................................................................................12-27
Add, Change, or Delete Table Comments...................................................... 12-27
Save the Table Comment ..............................................................................12-28
Managing Column Comments............................................................12-28
Choose the Column.......................................................................................12-29
Add, Change, or Delete the Column Comment.............................................. 12-29
Save the Column Comment...........................................................................12-30
Managing Table Statistics..................................................................12-30
Choose the Tables.........................................................................................12-31
Display the Statistics..................................................................................... 12-31
Display Dependencies ................................................................................... 12-33