HP NonStop G-Series User Manual

Page 13

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004

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