Hp Integrity NonStop J-Series Manuel d'utilisateur Page 55
- Page / 110
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
2. In the right pane, click Store Order.
The following details appear:
• Position: — The position of the column in the key, for the physical file.
• Column Name: — The name of the column (string)
• Sort Order: — The order specified as Ascending or Descending.
• Added by: — The property indicates whether the column was added by the system or by
the user.
Viewing check constraints
To view the check constraints for a table:
1. In the navigation tree, select the table.
2. In the right pane, click Check Constraints.
The following details appear:
• Constraint Name: — The name of the check constraint.
• Metadata UID: — The internal UID number for the constraint.
• Text: — A string that defines the constraint, as shown in the SHOW DDL output.
Viewing unique constraints
To view the unique constraints for a table:
1. In the navigation tree, select the table.
2. In the right pane, click Unique Constraints.
The following details appear:
• Constraint Name: — The name of the unique constraint.
• Metadata UID: — The internal UID number for the constraint.
• Columns: — The names of the columns that are constrained.
Viewing foreign key properties
To view the foreign key properties:
1. In the navigation tree, select the table.
2. In the right pane, click Foreign Key.
The following details appear:
• Name: — The name of the foreign key constraint.
• Metadata UID: — The internal UID number of the foreign key.
• Foreign Table: — The name of the foreign table.
• Local Column: — The name of the local column of the foreign key.
• Foreign Column: — The name of the foreign column of the foreign key.
• Enforced: — The property indicates whether the referential integrity is enforced.
Viewing table attributes
To view the table attributes:
1. In the navigation tree, select the table.
Viewing table properties 55
- Release 3.2 1
- Contents 3
- 4 Contents 4
- Contents 5 5
- 6 Contents 6
- About this guide 7
- Related documentation 8
- • Migration guides 9
- • Data management guides 9
- • Online help 9
- Notation Conventions 10
- HP encourages your comments 11
- 1 Introduction to MXDM 12
- MXDM functional flow 13
- 14 Introduction to MXDM 14
- Supported version of SQL/MX 15
- Prerequisites 15
- Installing MXDM 16
- Uninstalling MXDM 16
- Uninstalling MXDM 17 17
- Starting up MXDM 18
- Adding a system 18
- Connecting to a system 19
- Disconnecting from a system 21
- Using the Systems Tool 21
- Editing a system definition 23
- Copying a system definition 23
- Removing a system 24
- Testing a system definition 24
- Exiting MXDM 25
- 4 Navigating MXDM 26
- MXDM banner 27
- Using the MXDM menus 27
- Using the File menu options 28
- Using the Edit menu options 28
- Using the Tools menu options 28
- Using the MXDM toolbar 29
- Selecting an area 30
- Using the My Favorites pane 32
- Using the navigation tree 33
- Using the right pane 35
- Figure 9 Window controls 37
- Working with data grids 40
- Working with data grids 41 41
- Copying data grid information 42
- Customizing the data grid 42
- Searching the data grid 43
- Copying data 44
- Copying data to a browser 45
- 6 Viewing database objects 47
- Viewing catalog attributes 48
- Viewing catalog registrations 48
- Viewing schemas 49
- Viewing schema attributes 50
- Viewing schema views 51
- Viewing schema procedures 51
- Viewing table properties 52
- Viewing table properties 53 53
- Viewing hash key properties 54
- Viewing check constraints 55
- Viewing unique constraints 55
- Viewing table attributes 55
- 56 Viewing database objects 56
- Viewing table properties 57 57
- 58 Viewing database objects 58
- Viewing table properties 59 59
- 60 Viewing database objects 60
- Viewing table properties 61 61
- 62 Viewing database objects 62
- ◦ Delete 63
- ◦ Insert 63
- ◦ Select 63
- ◦ Update 63
- Viewing attributes of a view 66
- 68 Viewing database objects 68
- ◦ CONTAINS SQL 69
- ◦ MODIFIES SQL DATA 69
- ◦ READS SQL DATA 69
- 70 Viewing database objects 70
- 72 Viewing database objects 72
- 74 Viewing database objects 74
- 7 Managing MXCS objects 76
- Stopping an MXCS server 78
- Viewing MXCS Services 78
- Starting up an MXCS service 79
- Stopping an MXCS service 80
- Viewing data sources 81
- Creating a data source 82
- Using General Properties 83
- About DEFINEs 85
- About SETs 86
- Creating a data source 87 87
- If-Locked 88
- Priority 88
- Copying a data source 89
- Starting up a data source 90
- Stopping a data source 90
- Updating a data source 91
- Deleting a data source 91
- Viewing MXCS user permissions 92
- Adding an MXCS user 93
- Editing MXCS user permissions 94
- Deleting an MXCS user 94
- Deleting an MXCS user 95 95
- Interface 96
- Setting Auto Logon options 97
- A Using the SQL Whiteboard 98
- Statement List pane 99
- Statement pane 100
- Page mode 101
- Statement Details pane 102
- Reusing a connection 103
- Highlighting the SQL syntax 104
- Managing the layout of panes 104
- Glossary 105
- 106 Glossary 106
- 108 Index 108
- 110 Index 110
Produits connexes et manuels pour Matériel informatique Hp Integrity NonStop J-Series
(110 pages)
(82 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.038 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels