HP NonStop G-Series - Manual (Page 12)

Contents x
Define File Attributes ...................................................................................... 12-3
Choose Table Format...................................................................................... 12-4
Choose Partition Array: .................................................................................. 12-4
Add Columns.................................................................................................. 12-5
Change Column Attributes .............................................................................. 12-7
Delete Columns .............................................................................................. 12-8
Change Column Sequence............................................................................... 12-8
Creating Table Partitions................................................................................. 12-9
Creating Table Constraints .............................................................................. 12-9
Save the Table .............................................................................................. 12-11
Altering a Table.................................................................................12-12
Choose a Table ............................................................................................. 12-12
Display Dependencies ................................................................................... 12-13
Change File Attributes .................................................................................. 12-13
Choose Table Format.................................................................................... 12-14
Choose Partition Array: ................................................................................ 12-14
Change Security............................................................................................ 12-14
Add Columns................................................................................................ 12-15
Dropping a Table ..............................................................................12-15
Choose the Table .......................................................................................... 12-16
Display Dependencies ................................................................................... 12-16
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